Metadata
Technology & Computer Science Undergraduate Understand Medium
View More
Metadata

  • Subject

    Technology & Computer Science

  • Education level

    Undergraduate

  • Cognitive goals

    Understand

  • Difficulty estimate

    Medium

  • Tags

    normalization, functional dependencies, 1NF, 2NF, 3NF, database design

  • 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 database normalization by asking them to analyze given schemas and sets of functional dependencies: identify violations of 1NF, 2NF, and 3NF; detect partial and transitive dependencies; perform lossless and dependency-preserving decompositions into 2NF/3NF; and justify normalization choices and trade-offs in design decisions.
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.