Metadata
Technology & Computer Science Undergraduate Apply Medium
Metadata
  • 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.
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.