First Normal Form
Hi
Imagin I have table with these filels:
AuthorName, BookTitle, Pages, AuthorAddress.
There is n to n relation between Author and Book.
I want to put my table in 1NF.
How can i do it?
One method for bringing a table into first normal form is to separate Author and Book entity into separate tables then create AuthorBook table for match Author and Book tables.
I read some articles For normalization. Some of them offer this method and some of them offer just define primary key( AuthorName, BookTitle) that cause table be in 1NF.
Which one is true?
Subject
Written By
Posted
First Normal Form
February 11, 2008 05:41AM
February 11, 2008 07:18AM
February 11, 2008 09:16AM
February 11, 2008 11:37AM
February 11, 2008 02:34PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.