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 |
|
collie
Constraint Violating Yak Guru
400 Posts |
 Posted - 2013-01-09 : 04:13:19
|
| Hi,Lets say your company needs to build a web application for a client. If you were given a document that specifies what the application is all about and it's your job to design the db- how would you go about designing it?I know about normalisation, data type considerations but I want to know please how from a document of about 100 pages you are supposed to design the tables. Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-09 : 04:17:32
|
| start with identifying the core entities involved in application and relationships between them. This can be documented in ER diagram and would help in logical model. then think of attributes to be included in each entity to get physical model out of it. Finally convert it to scripts.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
design DB from scratch