Normalization

  • The Process of Normalization
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Inference Rules for FDs
  • Minimal Sets of...
    View Complete Description
    ×

    Topic Summary

    • The Process of Normalization
    • First Normal Form (1NF)
    • Second Normal Form (2NF)
    • Third Normal Form (3NF)
    • Inference Rules for FDs
    • Minimal Sets of Functional Dependencies
    • Data Redundancy and Update Anomalies
    • Insertion Anomalies
    • Deletion Anomalies
    • Modification Anomalies
    • Boyce–Codd Normal Form (BCNF)
46
Questions
Question Type Legends

Easy

Medium

Difficult

Multiple Choice Questions for Normalization

  • 1 Which type of dependency is removed in 2nd normal form to make the relation(s) full functional dependent:
    1. Full functional dependency
    2. Partial dependency
    3. Transitive dependency
    4. None of above

  • 2 One goal to eliminate various anomalies in relational database is to:
    1. Reduce attributes
    2. Reduce tables
    3. Increase data
    4. Reduce storage space

  • 3 _____________ is the most efficient method to reduce the duplication of data.
    1. Deletion
    2. Normalization
    3. Alter
    4. none of the above

  • 4 For some relations, updating the data can have undesirable consequences called
    1. Referential integrity
    2. Insertion anamoly
    3. Deletion anamoly
    4. Modification anamoly

  • 5 A table is in 1NF but not in 2NF if in the table:
    1. There are no repeating groups
    2. There are repeating groups
    3. There are repeating groups but no transitive dependency
    4. None

Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn and Evaluate

Follow Us
© 2020 - Subject Expert