Essential session storage is required to sign in. Optional analytics remain off unless you allow them.
Design a small relational schema (e.g. a library, a store, or a blog) in third normal form: tables with appropriate data types, PRIMARY KEYs, and FOREIGN KEYs enforcing the relationships. Create the tables with DDL, seed realistic data, then write a set of queries that answer real questions using WHERE filters, JOINs, GROUP BY aggregation, and ORDER BY. NULLs must be handled correctly (IS NULL, not = NULL).
Tables in ~3NF with correct types; PRIMARY and FOREIGN KEYs enforce integrity; sensible NOT NULL/UNIQUE.
Queries use JOINs, GROUP BY/aggregates, and filtering correctly to answer the stated questions.
Results are right; NULLs handled with IS NULL; no accidental cartesian products.
Explicit column lists, qualified names in joins, readable formatting.
Use this README structure to make the work reviewable.
DevPath fetches a read-only, size-capped snapshot. Submitted code is never executed.
# Design and query a normalized relational schema ## Goal Design a small relational schema (e.g. a library, a store, or a blog) in third normal form: tables with appropriate data types, PRIMARY KEYs, and FOREIGN KEYs enforcing the relationships. Create the tables with DDL, seed realistic data, then write a set of queries that answer real questions using WHERE filters, JOINs, GROUP BY aggregation, and ORDER BY. NULLs must be handled correctly (IS NULL, not = NULL). ## Acceptance criteria - [ ] Schema & constraints: Tables in ~3NF with correct types; PRIMARY and FOREIGN KEYs enforce integrity; sensible NOT NULL/UNIQUE. - [ ] Querying: Queries use JOINs, GROUP BY/aggregates, and filtering correctly to answer the stated questions. - [ ] Correctness: Results are right; NULLs handled with IS NULL; no accidental cartesian products. - [ ] Clarity: Explicit column lists, qualified names in joins, readable formatting. ## Verification - [ ] Document installation and run commands. - [ ] Record automated checks and their exact commands. - [ ] Add representative output, screenshots, or a short demo where useful. - [ ] Confirm failure paths and known constraints. ## Decision log ### Decision title - Context: - Choice: - Alternatives considered: - Tradeoffs: ## Evidence - Link each rubric criterion to the file, test, or artifact that demonstrates it. ## Known limitations - List what is intentionally out of scope and what should be improved next.