SQL

SQL Projects

Database queries, data manipulation, and analysis. Each project is interactive: run real queries in your browser.

Hospital Management System Coursework
A relational schema for hospital administration: patients, doctors, rooms, billing, and inventory. Includes an interactive ER diagram and a patient's journey walkthrough.
Hospital Hospital_ID Hname Doctor Doctor_no Dname Patient Patient_no Pname Room Room_no Availability Bills Bills_no Amount
Cinema Database Analytics Interactive
22 SQL queries on a cinema database: tickets, revenue, screening hours, voucher discounts. Run them live in your browser.
Customer Id Name City Ticket Id CustomerId Amount Screening Id MovieId Date Actor Id Name Cast Id MovieId ActorId Movie Id Name Release
Invoicing Database Design Schema design
Designing a relational schema from scratch: tables, foreign keys, migrations, normalization, and a trigger for premium customers.
Customer Id Name City Premium Invoice Id CustomerId City Date DeliveryId InvoiceLine Id InvoiceId ProductId Quantity Price Product Id Description Price Delivery Id Status Date