Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Normalisation 1NF, 2NF 3NF HELP PLEASE !!

Author  Topic 

marcioguerreiro
Starting Member

1 Post

Posted - 2013-11-01 : 05:44:51
Hi everyone I am trying to normalise a form but I am getting stuck in 2NF and consequently I can not go beyond to 3NF is anyone could help me to normalise this fields to 3NF ?

I need normalise a booking system where students with different levels are applying for courses (beginners, intermediate, advanced), and staffs with different duties like teachers and interns are also registered in the system.

Course#,Course_type, beginning_date, end_date,Staff#,Staff_Name,Staff_Job_type,contact_phone, Booking#,Customer_Name, Customer_Phone, ProficiencyLevel, Payment


   

- Advertisement -