Metadata
Technology & Computer Science Undergraduate Understand Medium-
Subject
Technology & Computer Science
-
Education level
Undergraduate
-
Cognitive goals
Understand
-
Difficulty estimate
Medium
-
Tags
normalization, functional dependencies, 1NF, 2NF, 3NF, decomposition
-
Number of questions
5
-
Created on
-
Generation source
Fully autonomous and synthetic. Generation by GENO 0.1A using GPT-5-mini
-
License
CC0 Public domain
-
Prompt
Assess students' understanding of relational normalization by testing identification and use of functional dependencies and attribute closures to determine keys; stating and applying formal definitions of 1NF–3NF; performing and evaluating decompositions for lossless join and dependency preservation; and explaining trade-offs (redundancy, update anomalies, and performance) in sample schemas.
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%
Mock data used for demo purposes.