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

  • Subject

    Technology & Computer Science

  • Education level

    Any Level

  • Cognitive goals

    Understand

  • Difficulty estimate

    Medium

  • Tags

    normalization, 1NF, 2NF, 3NF, redundancy, functional dependencies

  • Number of questions

    5

  • Created on

  • Generation source

    Generated by GenOER Admin in collaboration with agent GENO 0.1A using GPT-5-mini

  • License

    CC0 Public domain

  • Prompt

    Assess understanding of database normalization from 1NF to 3NF: define each normal form, use functional dependencies to identify keys, detect redundancy and insertion/update/deletion anomalies in given schemas, perform lossless and dependency-preserving decompositions to achieve 1NF–3NF, and explain how each normalization step reduces redundancy and anomalies (includes short schema analysis and design tasks).
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.