Normalization & ERD Practice Pack: Free Sample (5 Problems)

Most normalization practice shows you the answer. This sample also shows you how the answer gets graded.

You get 5 problems taken from the full Normalization & ERD Practice Pack, written by a college database instructor. Each one is set up like a real exam question: a scenario, sample data, and tasks with point values. The solution comes on the next page.

What's inside

• Problem 1: Pick the primary key (Easy)
• Problem 6: Repeating columns → 1NF (Easy)
• Problem 10: Transitive dependency → 3NF (Medium)
• Problem 15: Online store ERD, with a crow's foot diagram (Medium)
• Problem 21: The junction table (Medium)

Every solution includes

• The answer: the final tables, keys, or ERD.
• The steps: worked in the order you'd use on an exam.
• The common wrong answer: what students hand in most often, and why it loses points.
• A 10-point rubric: so you can score your own work honestly.

How to use it: try each problem on paper first, then turn the page and grade yourself. A score tracker is at the back. Your total out of 50 tells you which topics to review.

Good for: students in an intro database course, anyone preparing for a database design exam, and self-taught developers who want to check their schema skills.

File: PDF, 18 pages, US Letter. Prints cleanly and works on a tablet or laptop.