Database Design

3NF Advice

Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Oct 2009

Posts: 1

Reputation: hasse76 is an unknown quantity at this point

Solved Threads: 0

hasse76

Offline

Newbie Poster

3NF Advice

Oct 12th, 2009

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: (PrimaryKey)ProductID, Producttitle, Published.

In Author I have: (PrimaryKey)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?

Last edited by hasse76; Oct 12th, 2009 at 10:42 am.

•

Join Date: Mar 2007

Posts: 305

Reputation: timothybard is an unknown quantity at this point

Solved Threads: 25

timothybard timothybard is offline

Offline

Posting Whiz

Oct 12th, 2009

Yes, that looks good to me.

http://www.timothybard.com
http://www.oliveirabard.com

•

Join Date: Oct 2009

Posts: 10

Reputation: Drlionheart is an unknown quantity at this point

Solved Threads: 1

Drlionheart Drlionheart is offline

Offline

Newbie Poster

Oct 13th, 2009

Hi,

Please go through the full study of Normalization examples in oracle website. Then u will start the the above example and surely you will get the solution.............