Which of the following statements is NOT correct regarding the database design and optimization technique of De-normalization?
Ch 23: Boyce-Codd Normal Form (BCNF)
Rigorous analysis of BCNF (stricter 3NF), addressing edge cases where multiple overlapping candidate keys cause remaining anomalies.
20 Questions20 MCQs0 Short Questions0 Long Questions
SEMESTER PASS
CS403 - Database Management Systems Examination Practice
Timed practice exam simulation for CS403 - Database Management Systems.
Showing 11 โ 20 of 20 Questions
Page 2 of 2
Consider a fully normalized relational database schema in Second Normal Form (2NF) consisting of two tables:
- STUDENTS (StudentID, StudentName, ClassID)
- CLASSES (ClassID, CourseTitle, Venue)
You are asked to perform a 'De-normalization' step to convert these tables back into a single flat First Normal Form (1NF) table under the following 5 Terms and Conditions:
1. Merge all attributes into a single flat relation named STD_CLASS.
2. Retain duplicate ClassID, CourseTitle, and Venue attributes within the student table.
3. The primary key of the new table must be StudentID.
4. Re-introduce the partial functional dependencies into the flat schema.
5. Re-introduce the transitive dependency chain where StudentID determines ClassID, and ClassID determines CourseTitle and Venue.
Define the resulting flat table structure and describe the specific update, insertion, and deletion anomalies that are reintroduced by this denormalization.
During physical database partition design, which of the following partitioning techniques reduces the chances of creating unbalanced partitions (data skewing)?
Which of the following types of horizontal partitioning reduces the chances of creating unbalanced partitions (data skewing)?
Which of the following statements is NOT true regarding the database design technique of De-normalization?
Which of the following is NOT true about De-normalization?
Under physical database schema design, which of the following is NOT generally a target objective of data partitioning and data placement?
During the physical design phase of denormalization, database designers sometimes partition tables. Give three key reasons or performance benefits of partitioning tables.
Under physical database storage design and optimization guidelines, physical record clustering is most suitable for which of the following operational situations?
During physical database design, which of the following horizontal partitioning techniques applies an algorithm to a partitioning key to evenly distribute rows across physical disks, thereby minimizing the risk of unbalanced partitions?