Metadata
Technology & Computer Science Any Level Apply Medium
View More
Metadata

  • Subject

    Technology & Computer Science

  • Education level

    Any Level

  • Cognitive goals

    Apply

  • Difficulty estimate

    Medium

  • Tags

    normalization, indexing, query optimization, relational databases, schema design

  • Number of questions

    5

  • Created on

  • Generation source

  • License

    CC0 Public domain

  • Prompt

    Test learners' ability to apply normalization principles and indexing strategies to improve relational query performance. Provide schema fragments and sample queries; ask students to identify normalization violations, propose schema redesigns (up to 3NF/BCNF where appropriate), recommend index types and columns (clustered, nonclustered, composite, covering, hash/B-tree), justify trade-offs (storage, maintenance, selectivity), and predict performance impact.
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.