Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 normalization

Author  Topic 

cadnaani
Starting Member

6 Posts

Posted - 2008-11-26 : 21:09:35
How to or what is the best way to normalize this table can anyone help please.

title author 1 author2 ISBN subjects pages publisher
php % myql Luke willy William F 333998 php, mysql 600 Simmons
mysql tutorial Luke willy William F 989889 mysql 900 Simmons

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-11-27 : 03:23:34
Is this homework?

What do you think is a normalised form for this? (hint, you have repeating groups, no declared candidate key and at least 1 column that doesn't depend on the others in the table)

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -