We use cookies to ensure you have the best browsing experience on our website. Please read our cookie policy for more information about how we use cookies.
Database Normalization #3
Database Normalization #3
Sort by
recency
|
34 Discussions
|
Please Login in order to post a comment
You cannot add course details of each student in the students table as it would violate 2NF cause each student can take up more than 1 course. Also, you can't add the ids of students enrolled for each course for the same reason.
With an intermediate table which would map student_id to course_code, you can achieve the 2NF.
Hence, 2+1 tables required.
Hey guys here in Brazil, the result is 3 because when there's a many-to-many relationship, another table is created and then 3
3
Database Normalization is a crucial topic in database management, and I'm glad to see it being discussed here. Understanding the principles, like learnpaydayloan, is vital for maintaining data integrity and efficiency in systems. It's essential to implement normalization techniques to ensure a well-organized and optimized database structure. Great post!
This concept is as similar ......... but don't know why I'm getting an error message......... طريقة جلب الحبيب عن طريق اسمه فقط
I got this one ,very easy. Last one was messed up