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 |
|
wndrboy2k3
Starting Member
37 Posts |
 Posted - 2009-02-08 : 04:58:46
|
| EDIT: This is in the wrong forum, can a mod move it please? ThxSo this ultra normalized database is new to me and I have a question about how it would work. My understanding is the BusinessEntityID is the primary key for EVERY possible person the company deals with, and the table PERSONS.PERSONS is the table with all the actual information that is associated with a particular BusinessEntityID. Correct me if I am wrong.My question is how is the BusinessEntityID created? Is it automatically generated when a new person is made? Or are the BusinessEntityID's premade (in this case there are 27000 or so records) and whenever a new person is made you have to assign them a BusinessEntityID that is availabe.You don't have to use the Adventureworks db as a direct example but if you know what i mean, some help would be great. Thanks everyone. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-02-08 : 21:30:28
|
| one of the common way is to use identity columns as business key. Identity columns values are automatically generated upon insertion of each new record. |
 |
|
|
|
|
|
AdventureWorks 2008