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
 Old Forums
 CLOSED - General SQL Server
 Normalization

Author  Topic 

websyd
Starting Member

16 Posts

Posted - 2006-06-17 : 11:19:32
hi guys,im new here and i want u guys to shed more light to me on the issue of normalization,primary key and foreign key.i need to build an application that requires a database to store customer info,products,CustomerOrder,as well as Payments made by the Customer.
thanks

nr
SQLTeam MVY

12543 Posts

Posted - 2006-06-17 : 16:21:44
http://en.wikipedia.org/wiki/Database_normalization
http://databases.about.com/od/specificproducts/a/normalization.htm
http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
http://www.databasejournal.com/sqletc/article.php/1428511

google for database normalization


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-06-19 : 02:18:05
http://www.datamodel.org/NormalizationRules.html
http://www.agiledata.org/essays/dataModeling101.html

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

gurusamy.senthil
Yak Posting Veteran

65 Posts

Posted - 2006-06-19 : 06:15:36
http://www.devbuilder.org/article/13
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.sqlr.doc/sqlrmst283.htm

http://searchoracle.techtarget.com/ateQuestionNResponse/0,289625,sid41_gci1072518,00.html
http://www.aisintl.com/case/primary_and_foreign_key.html
Go to Top of Page
   

- Advertisement -