Member Avatar for hasse76

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?

Edited by hasse76 because: n/a
  • 3 Contributors
  • 2 Replies
  • 86 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Drlionheart

Recommended Answers

All 2 Replies

Member Avatar for timothybard

Yes, that looks good to me.

Member Avatar for Drlionheart

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.............

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.