Hi everyone, I need some help with a project I have to do...
I'm still in the process of designing the database, which involves allowing users to book a certain lane in a swimming pool. I came up with some tables but I dont know if they make sense. Any help is appreciated:
Pool, Bookings, Accounts, Lanes.
However, I feel that lanes is kind of not needed. Do you think I'm getting it much too complicated where it can be done with about 2 entities? There won't be certain people booking, just a few standardized groups.
no, toxi, you don't need a Days table -- unless you specifically have certain days where no lanes can be booked, and these days cannot be predetermined through a simple formula (e.g. closed on statutory holidays)