← All topics
Quiz: Normalization: questions with answers
10 questions, each with the answer and a short explanation.
Take the timed quiz + get a certificate →- Q1. A table where one cell contains "Python, Java, SQL" violates:
- Q2. Key (orderid, productid); column customername depends only on orderid. This violates:
- Q3. empid → deptid and deptid → deptname in one table. deptname violates:
- Q4. "You can't add a new course until a student registers" is an example of a:
- Q5. A table whose primary key is a single column is automatically in:
- Q6. Teacher Gupta changes his phone number and it has to be edited in many rows of the registrations table. Which anomaly is this?
- Q7. Ravi was the only DSA student. Deleting his registration also loses the DSA fee and teacher. Which anomaly is this?
- Q8. What does the functional dependency course → teacher mean?
- Q9. In R(student, subject, teacher), (student, subject) → teacher and teacher → subject hold. Why is R not in BCNF?
- Q10. A reporting team deliberately keeps the customer name inside the orders table to make dashboards faster. This is: