Restaurant
| restaurant_id | names |
Date
| date_id | date |
Time_slots
| time_slots_id | start_time | end_time | restaurant_id | date_id |
Reservations
| reservation_id | No.of.people | time_slots_id|
Relations between tables:
Relation between time slots and restaurants = Many to Many
Relation between time slots and date = Many to Many
Relation between time slots and reservation = One to one
I will try to structure the restaurant reservation db....in which select restaurant than date after select date the available time slots displayed of selected restaurant on that date...If there is any mistake that i did in this sructure than plz guide me.