Capstone project for Meta Database Engineer specialization on Coursera
Details at https://www.coursera.org/professional-certificates/meta-database-engineer
Caution
Notes for reviewers:
- database model difference: orders contain arbitrary menu items (à la carte) instead of fixed menus with prespecified items
- stored procedure GetMaxQuantity() returns 15 instead of 5 due to different test data
- stored procedure ManageBooking() is called AddValidBooking()
Important: There are bugs in the grading answers, fewer points correspond to better results. Please select the grading answers with the highest amount of points, if you think everything is correct. E.g. select:
5 points
AddBooking() books the available table and but generates no confirmation message.
instead of
1 point
AddBooking() books the available table and generates an appropriate confirmation message.
you don't need to run the SQL queries if you want to save time, I stored the results that I got in the following files: