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 |
|
Abid
110 Posts |
 Posted - 2011-04-03 : 03:37:32
|
| hi, i saw a database yesterday in which there were many tables having 3 and 4 primary keys. my question is that in second normal form i have studied that all non key attributes must be completely dependent on primary key not on a subset of primary? it was further written that every table must have one primary key? so under the light of this definition its clear to not to use more than one primary keys, but if we use so why we use it? and doesn't it make the database complex? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-04-03 : 06:45:36
|
| Duplicate post. No replies to this thread please. Direct replies to:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=158977[/url]--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
composite primary key