NORMALIZATION PROCESS STRUGGLING

[theMISman]

Ok lets say I am given a this information

for each publisher,list the publisher code,publisher name, and city where publisher is located

would i do something on the lines of this

Publisher as Table (PublisherId as primary key ,Publisher_Code,Publisher_Name, City)

 

[theMISman]

another example is for each college, list the number, name, location, and number of employees working at the bookstore.

Would i do something on the lines of this

College as Table (CollegeID,College_Name,College_Location,Employee)

 

[r937]

publishers is correct -- the code, the name, and the city all depend on the (entire) primary key, so it's 3NF

colleges is incorrect -- name and location depend on the primary key, but i'm sure there is more than one employee in a bookstore, and employee is not an attribute of the college

in fact, where's bookstore?

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[theMISman]

another example is for each book,list its code,title,publisher code, name, and price


so a boook table(BookID, Book_Code,Book_Name, Publisher_Code,Publisher_Name, Publisher_Price)

 

[JoeAtWork]

so a boook table(BookID, Book_Code,Book_Name, Publisher_Code,Publisher_Name, Publisher_Price)

Think of it this way, any particular piece of information, other than a foreign key, should not appear in multiple records in a table. If you are finding that it does, you should likely put that information in another related table, then replace the field with a Foreign Key to that related table.

 

[PWise]

is ther a NORMALIZATION fourm in tek tips
perhaps we can start one

than you

Pwise