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 |
|
rajesh876
Starting Member
1 Post |
 Posted - 2009-04-16 : 11:09:49
|
| I would like to create a new database.I am not good at database creation .I need your help.Here is the situation I had. Location Names Department Hospital XXXX name1 Dept1 Hosp1YYYY name2 Dept2 hosp2-----------etc... Location Names Department Hospitalzzzz name3 dept3 hosp4nnnn name4 dept4 hosp1---------------------------etc....here Names are unique valuesand they are up to 150.Dept names would be 7 to 8.Hospitals would be 4.locations would be 5.Please help me out how to create database for this.I am thing to create tables "locations","Authors","departments","Hospitals" .I am worrying about how to relate between the tables.Please guide me. |
|
|
|
|
|
Need help in Database creation