Ch 20: First Normal Form (1NF)

Step-by-step conversion of un-normalized tables into First Normal Form, ensuring every column contains indivisible, scalar values.

26 Questions26 MCQs0 Short Questions0 Long Questions

🎯 Exam Practice Papers

CS403 - Database Management Systems Examination Practice

Timed practice exam simulation for CS403 - Database Management Systems.

Showing 21 – 26 of 26 Questions

Page 3 of 3

Q21

❓ MCQ📘 CS403📑 Lec 20🏷️ 20.1. Second Normal Form (2NF)Hard🔁⭐💡🌟📄🎓VU🏛️VU

Consider a database table with the schema 'COURSE_REG(StudentID, StudentName, CourseID, CourseTitle, Grade)'. The functional dependencies identified are: - StudentID -> StudentName - CourseID -> CourseTitle - {StudentID, CourseID} -> Grade What normal form is this table currently in, and what is the correct decomposition to convert it into Second Normal Form (2NF)?

💻 sql Snippet

-- Unnormalized 1NF Table with Partial Dependencies:
-- COURSE_REG(StudentID, StudentName, CourseID, CourseTitle, Grade)

A.It is in First Normal Form (1NF) due to partial dependencies. To convert to 2NF, decompose into: - STUDENT(StudentID, StudentName) - COURSE(CourseID, CourseTitle) - ENROLLMENT(StudentID, CourseID, Grade)
B.It is in Second Normal Form (2NF) due to full functional dependency. To convert to 2NF, decompose into: - COURSE_REG(StudentID, CourseID, Grade)
C.It is in Third Normal Form (3NF) because there are no transitive dependencies. To convert to 2NF, merge all columns into a single flat table.
D.It is in First Normal Form (1NF) due to transitive dependencies. To convert to 2NF, decompose into: - STUDENT_COURSE(StudentID, CourseTitle, Grade)

Q22

❓ MCQ📘 CS403📑 Lec 20🏷️ 20.2. Third Normal Form (3NF)Medium🔁⭐💡🌟📄🎓VU🏛️VU

Under relational database normalization theory, which of the following concepts is applicable and directly addressed with respect to Third Normal Form (3NF)?

💻 text Snippet

-- Transitive Dependency chain violating 3NF:
-- Primary Key -> Non-Key Attribute A -> Non-Key Attribute B

A.Full functional dependency
B.Any kind of dependency
C.Transitive dependency
D.Partial functional dependency

Q23

🧠 Long Problem📘 CS403📑 Lec 20🏷️ 20.2. Third Normal Form (3NF)Hard🔁⭐💡🌟📄🎓VU🏛️VU

You are given a non-normalized relation 'CUSTOMER_SALES' that is currently in Second Normal Form (2NF). The schema and dependencies are defined as: CUSTOMER_SALES (CustomerID, CustomerName, SalesMan, Region) Primary Key: CustomerID Functional Dependencies: - CustomerID -> CustomerName, SalesMan - SalesMan -> Region Explain why this table schema violates Third Normal Form (3NF) requirements and show the step-by-step table decomposition needed to normalize it into 3NF relations.

💻 sql Snippet

-- Transitive Dependency violating 3NF:
-- CUSTOMER_SALES (CustomerID, CustomerName, SalesMan, Region)
-- SalesMan -> Region

Q24

❓ MCQ📘 CS403📑 Lec 20🏷️ 20.2. Third Normal Form (3NF)Easy🔁⭐💡📄🎓VU🏛️VU

In relational database normalization theory, which type of functional dependencies must be identified and completely eliminated to transition a relation from Second Normal Form (2NF) to Third Normal Form (3NF)?

💻 sql Snippet

-- Transitive Dependency: PrimaryKey -> Attribute_A -> Attribute_B
-- Eliminate by splitting into separate tables.

A.Partial functional dependencies
B.Transitive functional dependencies
C.Trivial functional dependencies
D.Multivalued dependencies

Q25

🧠 Long Problem📘 CS403📑 Lec 20🏷️ 20.2. Third Normal Form (3NF)Hard🔁⭐💡🌟📄🎓VU🏛️VU

You are given a non-normalized relation 'STUDENT_ENROLLMENT' that is currently in Second Normal Form (2NF). The schema contains details about students and their academic advisors: STUDENT_ENROLLMENT (StudentID, StudentName, MajorCode, AdvisorID, AdvisorName, AdvisorOffice) Primary Key: - StudentID (A single attribute, hence no partial dependencies exist) Functional Dependencies: - StudentID -> StudentName, MajorCode, AdvisorID - AdvisorID -> AdvisorName, AdvisorOffice Explain why this schema violates Third Normal Form (3NF) and show the step-by-step table decomposition to normalize it into 3NF relations.

💻 sql Snippet

-- Transitive dependency violating 3NF:
-- STUDENT_ENROLLMENT(StudentID, StudentName, MajorCode, AdvisorID, AdvisorName, AdvisorOffice)
-- AdvisorID -> AdvisorName, AdvisorOffice

Q26

❓ MCQ📘 CS403📑 Lec 20🏷️ 20.2. Third Normal Form (3NF)Easy🔁⭐💡🌟📄🎓VU🏛️VU

Under database normalization theory, which type of functional dependencies are specifically targeted and completely removed when transitioning a database table from Second Normal Form (2NF) to Third Normal Form (3NF)?

💻 sql Snippet

-- Transitive Dependency: CustomerID -> SalesMan -> Region
-- To resolve, extract SalesMan and Region into a separate table.

A.Partial functional dependencies
B.Transitive functional dependencies
C.Trivial functional dependencies
D.Multivalued functional dependencies

Ch 20: First Normal Form (1NF)

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