About the Project
This project requires us to build a simple database to help us manage the booking process of a sports complex. The sports complex has the following facilities: 2 tennis courts, 2 badminton courts, 2 multi-purpose fields and 1 archery range. Each facility can be booked for a duration of one hour.
Only registered users are allowed to make a booking. After booking, the complex allows users to cancel their bookings latest by the day prior to the booked date. Cancellation is free. However, if this is the third (or more) consecutive cancellations, the complex imposes a $10 fine.
The database that we build should have the following elements:
Tables
members
pending_terminations
rooms
bookings
View
member_bookings
Stored Procedures
insert_new_member
delete_member
update_member_password
update_member_email
make_booking
update_payment
view_bookings
search_room
cancel_booking
Trigger...