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.
  1. Prepare
  2. Databases
  3. Database Normalization
  4. Database Normalization #3
  5. Discussions

Database Normalization #3

Sort by

recency

|

36 Discussions

|

  • JiangHsin
     + 0 comments

    The ENROLLMENT table acts as a bridge, ensuring proper normalization and eliminating redundancy. Ekbet71 com login

  • saibhossain5
     + 0 comments

    it in 3

  • subhasdh_10
     + 0 comments

    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.

  • ericksantos25111
     + 0 comments

    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

  • native8901
     + 0 comments

    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!