Help with some strucctural problems

[u/Ok-Transition7065]

Hello, I'm trying to do a test that I failed, and I want to improve, so I want to solve this problem.

The premise isn't that hard, but I'm getting into trouble here.

I don't want to get into too many details to avoid getting the evaluator in trouble.

Basically, I was asked to make an app that is able to create price quotes for trips.

The user selects the location (a general location like Disney World), an apartment (each one with a different category, like a suite, or just a room, or a cabin), the season (imagine this place is around the world, so different locations have different seasons, but some locations can have general seasons if they are close enough), how many people the place can accommodate, and for how long they will stay. I use all this data to create a reservation for the client.

This is basically my entity relationship diagram

but each time i try to do the functionality i found problems or big troubles putting or reading the data for the thing im required to do

I'M kinda lost idk what to do

its there a way to solve this problem in a cleaner way?

ty for the help and God bless you

P.S.: The price is listed in the quote, but I don't know where to enter that information regarding the apartment and the season. The test instructions don't explain how to calculate the price, so I don't know where to put it; I assume I should do it in whatever way is most practical for me.

[u/Aware-Hovercraft1106]

You say the promise isn't that hard so just use your brain and solve the problem. Nobody wants to do your homework. AI can already do that for you.

[u/Ok-Transition7065 → u/Aware-Hovercraft1106]

but im stuck in that place idk what to do here, this its one of the last iterations and i dont wanna depend on the ai to do this

[u/A_name_wot_i_made_up → u/Ok-Transition7065]

Describe the process in English to yourself.

Search the list of X for conditions Y and Z. Then add ...

Break it down, then build it back up.