CODEWITHSUNDEEP
databasenormalization
John Snowden
John Snowden

Reputation: 767

Does a second normal form normalization always lead to a many-to-many relationship?

Can you give me an example where it is the case and another where it's not?

Upvotes: 1

Views: 313

Answers (1)

greenkode
greenkode

Reputation: 3996

2nd Normal form means eliminating Repeating groups. this would typically lead to Many to one relationships. eg. If you have a group of students registered for the course ISY23AT, you move the course into a different table. Many to many relationships fall under 3rd Normal form.

Upvotes: 1

Related Questions