Metadata
Technology & Computer Science Any Level Apply Medium-
Subject
Technology & Computer Science
-
Education level
Any Level
-
Cognitive goals
Apply
-
Difficulty estimate
Medium
-
Tags
normalization, 1NF, 2NF, 3NF, functional dependencies, relational design
-
Number of questions
5
-
Created on
-
Generation source
-
License
CC0 Public domain
-
Prompt
Assess students' ability to analyze unnormalized relations, identify functional dependencies and candidate keys, and perform stepwise normalization to 1NF, 2NF, and 3NF; tasks include decomposing schemas into lossless-join, dependency-preserving relations and justifying primary keys and design choices.
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%
Mock data used for demo purposes.