I am going to be creating a golf course booking system. I have a few questions firstly based on the database setup. If I give you the background behind the system to give you a better idea of the theory.
They need a booking system whereby members and visitors can book tee off times based on the current availability. The tee off times will be based on 15 min increments and stored in the database along with the bookingID (primary, autoinc), playerID, bookingtime, bookingdate, no_of_players, etc. The methodology behind the database is the first thing that I need to get my head around, so a basic process scenario would be essential here. No cash transactions will be made during the process only booking times.
1. DATE: Booking Form displays a date picker whereby the player can choose a preferred date.
2. TIME (15 min increments): Once date is selected would it be easier to display all available times during that day or base it all around a search, whereby the player selects a preferred time?
3. Number of players: This isnt really essential, it is just a record to show the owners the number of players. Future bookings could be based around this number.
If someone could help me workout some database design or theory behind this scenario I would be very greatful as this is the first proper booking system I will be attempting.
Please excuse my droaning! Many thanks in advance