🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← All topics

Quiz: Normalization: questions with answers

10 questions, each with the answer and a short explanation.

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