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 2000 Forums
 SQL Server Development (2000)
 Table Design

Author  Topic 

purisqlserver
Yak Posting Veteran

73 Posts

Posted - 2001-05-07 : 06:19:08
Hello Sir,
I have a table consisting of columns "Main Category","Sub Category1","Sub Category2".
Inorder to normalise,is it better to split
the columns into separate tables like

Table1
Main_Itemkeycode,Main Category----columns

Table2
Main_Itemkeycode,Sub_Itemkeycode1,
Sub Category1

Table3
Sub_Itemkeycode1,Sub_Itemkeycode2,
Sub Category1

Thank you

   

- Advertisement -