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
  • 88 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by Drlionheart
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.