Metadata
Technology & Computer Science Undergraduate Understand Medium-
Subject
Technology & Computer Science
-
Education level
Undergraduate
-
Cognitive goals
Understand
-
Difficulty estimate
Medium
-
Tags
normalization, 1NF, BCNF, anomalies, denormalization, functional dependencies
-
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 understanding of relational database normalization from 1NF through BCNF: objectives (data integrity, redundancy reduction), identification and explanation of common anomalies (insertion, update, deletion), recognition of dependency types (functional, partial, transitive), evaluation of decomposition for lossless join and dependency preservation, and analysis of practical denormalization trade-offs for performance and maintainability.
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%
Mock data used for demo purposes.