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  3NF - advice needed

Author  Topic  hasse76 Starting Member 1 Post Posted - 2009-10-12 : 07:53:43 Hi I am sitting with an flat db file, and need it converted to 3NF Example: ProductID Published Title Authors 1 2000 Car Mech. Bill Meyer, Peter Daniels I have split this structure in 3 tables: Book Author Author_Book In Book I have the following fields: PK:ProductID, Producttitle, Published. In Author I have: AuthorID, Firstname, Lastname Ans in Author_Book I have: ProductID, Author So, one book can have many authors, and one author can have many books. It must be a many-many relationship. Have I thought correctly and made a proper 3NF?