Q11hard
A decomposition of a relation R into R1 and R2 is said to be Lossless- Join if:
Back to Database Management Systems
20 Questions Total
Database Design & Normalization MCQs
Topic-wise practice questions for Database Management Systems. Test your knowledge, check solutions on demand, and pace your preparation.
Zero-leak answer engine • Rate-limited explanations
Practice in Timed ModeQ12hard
A database currently in 3NF has two candidate keys:
(StudentID, CourseID) and (StudentID, Email). An FD exists: Email →
Q13medium
A relation R(A, B, C, D) has the following Functional Dependencies: {A → B, B → C, C → D} What is the closure of attribute A, denoted as {A}+?
Q14medium
You have a Staff table: (staff_id, name, dept_id,
dept_manager_id). The Primary Key is staff_id.
The dependencies are: staff_id → dept_id and dept_id → dept_manager_id.
Q15hard
A developer refuses to normalize a table because they claim "the data is small and JOINs are slow." Which risk are they primarily ignoring?
Q16medium
You are auditing a database and find the following schema. Which normal form does it currently violate?
Q17medium
A senior architect suggests "Denormalizing" a high-traffic analytics table. What is the most likely reason for this recommendation?
Q18hard
In database normalization theory, what is the "Minimal Cover" (or Canonical Cover)?
Q19hard
A school database has a table Student_Courses(student_id, student_name, course_id, course_fee). If the school increases the fee for 'CS101', the admin must update every single row where a student is enrolled in 'CS101'. Failing to update one row creates a data conflict. What is this problem called?
Q20medium
You are tasked with fixing a 2NF violation in a schema. What is the standard SQL procedure to achieve this?