Search results

Hope someone can help. I need to create (for college) a small database for a hotel. It must prevent double bookings. I have the following tables: Customer BookingStaff Rooms Bookings (with composite key: BookingDate and RoomID. It also has CustomerID as a foreign key.) This works well...