Databases: final assessment
This covers the whole course. Take it after the last module.
Final quiz
Practical assessment: Design a clinic appointment database
Without using hints, design and build a database for a clinic's doctors, patients and appointments, and write the queries the reception desk needs.
- An ER model and tables in 3NF, with primary keys, foreign keys and suitable constraints
- A doctor cannot have two appointments at the same time, which the schema itself enforces
- Queries for each doctor's appointments on a given day, patients who have never had an appointment, and the busiest doctor this month
- Booking an appointment and recording its payment happen in one transaction
- At least one index, justified with a query plan
Final project
A library database: Design and build the database for a small library: members, books, copies, loans and fines, with the queries the librarians need every day.
How it is evaluated
- Correctness: every query returns exactly the right rows, including with NULL and empty tables
- Design: tables are normalized, and constraints refuse impossible data
- Safety: related changes are made in transactions
- Clarity: readable SQL with clear names, aliases and comments
To complete this course
- Score at least 70% on the final quiz
- Solve the beginner and intermediate exercises in every lesson
- Finish the final project and check it against the evaluation criteria