How can i apply normalization rules in the flowing database ? need help with N1,N2,N3,BCNF Student Stu_ID

How can i apply normalization rules in the flowing database ?
need help with N1,N2,N3,BCNF

 

Transcribed Image Text:

Student Stu_ID FirstName Last Name Gender Age Contact Number StudEmail Stud Pass Courses Course ID Course Name Schooly ear Schedule Sch_ID Course ID Stu ID Staff ID Subject ID Class Num Starting time Ending time Staff Staff ID First Name LastName Job Title Green - Primary Key Blue-Foreign Key Gender Age Contact Number StaffEmail StaffPass Subjects Subject ID Sub Name Course ID Student Stu_ID FirstName Last Name Gender Age Contact Number StudEmail Stud Pass Courses Course ID Course Name Schooly ear Schedule Sch_ID Course ID Stu ID Staff ID Subject ID Class Num Starting time Ending time Staff Staff ID First Name LastName Job Title Green - Primary Key Blue-Foreign Key Gender Age Contact Number StaffEmail StaffPass Subjects Subject ID Sub Name Course ID

Answer rating: 100% (QA)

Normalization is a database design technique that reduces data redundancy and ensures data integrity It involves organizing the columns attributes and tables relations of a database to ensure that the... View the full answer