Metadata
Technology & Computer Science Undergraduate Apply Medium-
Subject
Technology & Computer Science
-
Education level
Undergraduate
-
Cognitive goals
Apply
-
Difficulty estimate
Medium
-
Tags
normalization, 1NF-3NF, schema design, functional dependencies, sql, data integrity
-
Number of questions
5
-
Created on
-
Generation source
-
License
CC0 Public domain
-
Prompt
Assess students' ability to apply relational normalization (1NF–3NF) to analyze relational schemas and functional dependencies, decompose tables to eliminate anomalies, assign primary/foreign keys, and implement SQL DDL and DML (CREATE TABLE with constraints, INSERT, SELECT with JOINs) that enforce data integrity; requires justification of decomposition choices and demonstration of constraint-based enforcement on sample data.
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%
Mock data used for demo purposes.