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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-15 : 07:57:34
|
| Shiry writes "Hi, I'm a beginner and I'm a bit stuck here.. I'm creating this database for my homework, I'm using Marks & Spencer as anexample. It has a table, products, for the clothes idnamecat_id ....... connected to typ_catcolour_id ...... connected to typ_coloursize_id ....... connected to typ_sizepricesup_id ....... connected to typ_sup ...... but here i'm stuck a bit, are youallowed to connect a typ_table to another typ_table?this is the typ_sup:idnameaddresscity_id ......... connected to typ_cityor rather have a separate sup table with the same id, name, address, city_idid will be connected to typ_supand the products table.. sup_id will then be connected to typ_sup..?What way is better? and is it allowed to connect a typ_table to anothertyp_table?Thanks in advance!!!!Shiry" |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Foreign Keys 