Metadata
Technology & Computer Science Undergraduate Apply Medium
View More
Metadata

  • Subject

    Technology & Computer Science

  • Education level

    Undergraduate

  • Cognitive goals

    Apply

  • Difficulty estimate

    Medium

  • Tags

    normalization, indexing, schema design, transaction processing, query optimization, data integrity

  • 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 transactional relational schema, identify data anomalies and integrity risks, redesign tables into appropriate normal forms (3NF/BCNF as applicable), define primary and foreign keys, and propose indexing strategies (clustered/nonclustered, composite, covering, partial) with justification. Require evaluation of trade-offs for OLTP performance, storage and maintenance costs, expected query plan improvements for representative queries, and a brief migration or rollback strategy to implement the redesign safely.
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.