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, 3NF, functional dependencies, schema design, relational databases

  • 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' ability to analyze a denormalized online bookstore schema: identify functional dependencies and candidate keys, detect update/insert/delete anomalies, and decompose tables through 1NF to 3NF. Require submission of the resulting normalized schemas with attribute lists, justification that decompositions are lossless and preserve dependencies, and brief example SQL CREATE TABLE statements and mapping of sample denormalized rows to the new design.
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.