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 design, normalization, sql, indexes, joins, query optimization

  • Number of questions

    5

  • Created on

  • Generation source

  • License

    CC0 Public domain

  • Prompt

    Assess ability to design a normalized relational schema (to 3NF), define primary/foreign keys and constraints, and justify indexing choices (single-column, composite, covering) for performance; require writing optimized SQL queries using appropriate joins (inner, left, equi), index-friendly predicates, and interpreting EXPLAIN/optimizer output to avoid full scans and reduce I/O. Scope: moderate-sized OLTP schemas, trade-offs between normalization and indexing, and practical query-tuning techniques.
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.