trying to figure out the bet way to manage pricing in my app and
basically the database design.
It’s a language school that also offers host family accomodation.
They therefore have
Courses which have to have the following prices
fixed fees
exam fee
reg fee
recurring fees
price_per_week (1 to 2 weeks)
price_per_week (3 to 4 weeks)
price_per_week (5 to 6 weeks)
Accomodation has the following prices
fixed fees
Accomodation Booking Fee
recurring fees
price_per_week (single summer)
price_per_week (shared summer)
price_per_week (single winter
price_per_week (shared winter)
I’m confused as to how to handle this, how many tables and what to call
them?
Any help would be most welcome.