The MyCompany database schema
The database schema has the following assumptions:
- An accommodation has many rooms
- Reservations are made for a single user
- A reservation may include more than one room
- A reservation has a start date and an end date
- Rates are valid for one room from a start date to an end date
- A room has many amenities
- The start date of the reservation must come before the end date
- A reservation cannot be made for more than fifteen days
- A reservation cannot include more than four rooms
..................Content has been hidden....................
You can't read the all page of ebook, please click
here login for view all page.