Ch 21: Second Normal Form (2NF)

Technique for eliminating partial functional dependencies in composite primary key relations by decomposing tables into separate relations.

2 Questions2 MCQs0 Short Questions0 Long Questions

🎯 Exam Practice Papers

CS403 - Database Management Systems Examination Practice

Timed practice exam simulation for CS403 - Database Management Systems.

Showing 1 – 2 of 2 Questions

Page 1 of 1

❓ MCQ📘 CS403📑 Lec 21🏷️ 21.1. Summary of normalizationEasy🔁⭐💡📄🎓VU🏛️VU

Which of the following describes a systematic, step-by-step design process used to divide larger database tables into smaller ones, thereby minimizing data redundancy, protecting data integrity, and eliminating operational anomalies?

💻 sql Snippet

-- Redundant Non-3NF Schema:
-- STUDENT_REG(stId, stName, prName, prCredits)

A.Normalization
B.Integration
C.Classification
D.Modeling

❓ MCQ📘 CS403📑 Lec 21🏷️ 21.3. Decomposition and Lossless JoinHard🔁⭐💡🌟📄🎓VU🏛️VU

Identify the correct statement with respect to database normalization theory.

A.Normalization is a formal technique that can be used only at the starting phase of the database design.
B.Normalization can be used as a top-down standalone database design technique.
C.The process of normalization through decomposition must achieve the lossless join property at any cost whereas the dependency reservation property is sometimes sacrificed.
D.The process of normalization through decomposition must achieve the dependency reservation property at any cost whereas the lossless join property is sometimes sacrificed.

Ch 21: Second Normal Form (2NF)

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

CS403 - Database Management Systems Examination Practice

Mid Term Examination

Final Term Examination

📖 Related CS403 - Database Management Systems Curriculum Units