LSBUCruiseLiner Case Study C

We are each given a case study where we have to:

Design an ERD of the system

Produce a complete set of functional dependencies for the system

Create the database in a suitable relational database software (MS SQL Server)

Insert test data into the database

Write a query to show details of reservation clerks, including their location and the number of reservations taken, specifically for those employees who have taken the highest and the lowest total number of reservations

Write a query to calculate individual totals for the number of complete, incomplete and cancelled reservations

Write a query to find the details of the passenger cabins that are available for booking on each voyage

Implement using triggers and/or stored procedures automatic prevention of double booking passenger cabins during the reservation process

Write a stored procedure that can generate a complete reservation slip/invoice for any customer. This invoice must include customer details, details & quantities of all food/item/services purchased, invoice totals before and after VAT (@ 20%) has been added

Produce a dashboard combining 4-6 visualized elements that can be used to tell an effective story about the business in the scenario

Record a video demo (10 mins maximum) of the queries and the dashboard where during the video, we must demonstrate live execution of both the queries and the dashboard

Whats in the repository

All scripts and code used when completing the coursework, mainly in TSQL for Microsoft SQL Server Management Studio 18 with Tableau being used as the interface for the dashboard

Demo