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 |
|
Movva
Starting Member
15 Posts |
 Posted - 2011-08-16 : 11:49:30
|
| Hi, I am trying to catch up with some datbase design concepts. I am trying to find an article that help me understand on how to identify Table candidates in a given business scenario. Can some one help me with this or direct me to an article.Thanks,L |
|
|
Swaynebell
Starting Member
8 Posts |
Posted - 2011-08-17 : 14:38:05
|
| Hi Movva,If you google data modeling, you will find a number of items to get you started.A handy rule of thumb is that entities/tables will often be the nouns when your client is describing their business. For example, if the client tells you "Our customers rent or lease vehicles from us" the nouns "Customer" and "Vehicle" are good candidates for tables. I think you will find a number of good answers on Google. If not, consider purchasing a book on Data Modeling. There are many good ones, and the concept you are asking about will be among the first things covered.Steve |
 |
|
|
|
|
|
How to indentify table candidates