24 lines
1.3 KiB
Markdown
24 lines
1.3 KiB
Markdown
# 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:
|
|
>
|
|
> - [AddAvailableBooking (ManageBooking)](sql/available_booking_results.txt)
|
|
> - [AddBooking, UpdateBooking, CancelBooking](sql/modify_bookings_results.txt)
|
|
> - [GetMaxQuantity()](sql/query_optimization_results.txt) |