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

    relational database, normalization, schema design, e-commerce, inventory, orders

  • Number of questions

    5

  • Created on

  • Generation source

  • License

    CC0 Public domain

  • Prompt

    Assess learners' ability to design and normalize a relational database for an e-commerce inventory and orders system: create an ER model, map entities to tables with appropriate primary/foreign keys, normalize to 3NF (justify denormalization if any), define constraints and indexes, and provide sample CREATE TABLE statements and brief rationale for handling stock levels, order items, and transactional integrity.
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.