SQL Normalization
6.Which of the following is a benefit of normalization?
-
A. Data redundancy increases
-
B. Inconsistent data
-
C. Better data integrity
-
D. More NULL values
Better data integrity
Better data integrity
7.Consider the table: What normal form is this likely violating?
Student (StudentID, Name, Subject1, Subject2)
-
A. 1NF
-
B. 2NF
-
C. 3NF
-
D. 4NF
1NF
1NF
8.What will be the issue with this design? - If dept_name and dept_location always appear together
Employee(emp_id, emp_name, dept_name, dept_location)
-
A. 1NF violation
-
B. Repetition of dept info → 3NF violation
-
C. No issues
-
D. Composite key issue
Repetition of dept info → 3NF violation
Repetition of dept info → 3NF violation
9.Which is true about 3NF?
-
A. All attributes depend only on primary key
-
B. No transitive dependency
-
C. No partial dependency
-
D. All of the above
All of the above
All of the above
10.Which scenario violates 2NF?
OrderDetails(OrderID, ProductID, ProductName)
-
A. ProductName depends only on ProductID
-
B. ProductName depends on OrderID
-
C. Composite key used correctly
-
D. Each attribute depends on both keys
ProductName depends only on ProductID
ProductName depends only on ProductID