Metadata
Technology & Computer Science Undergraduate Apply Medium
View More
Metadata

  • Subject

    Technology & Computer Science

  • Education level

    Undergraduate

  • Cognitive goals

    Apply

  • Difficulty estimate

    Medium

  • Tags

    database 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 a given set of user requirements and an unnormalized data layout, identify entities and functional dependencies, and apply normalization steps through 1NF–3NF to produce a lossless, dependency-preserving relational schema; require specification of primary and foreign keys and brief justification for each decomposition choice.
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.