Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Creating database tables from models Expand / Collapse
Author
Message
Posted Sunday, August 03, 2008 6:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 26, 2009 2:38 PM
Points: 7, Visits: 15
Hi,
I've been looking a lot at data modeling of late and I must say, it is difficult to create a database out of the structure. Sometimes, the tables are too many. At time, the nested nature of the entities in the diagram makes it difficult to know what goes where.

Let's look at the structure below
Party
--Person
--Employee
--Organization (recursive)
- Employment (joins organization with Employee or another organization)
etc, etc

Sometime, there is even the statement that the parent of entity A is either entity B or entity C but not both.

1. Can I be directed as to how to create databases out of these models?
2. Is implementing the models as they are really the best thing?

Thank you.

Post #545772
Posted Monday, August 04, 2008 3:09 AM


Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, April 11, 2014 7:30 AM
Points: 346, Visits: 518
Which data modeling tool are you using? Use any good tool like ERWIN and use option of forward engineering to get your database creation script. The reverse option is available too ..

--
Sabya
Post #545936
Posted Monday, August 04, 2008 12:11 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 30, 2009 11:36 AM
Points: 69, Visits: 210
The database forms the foundation of most applications. For this reason, your primary goals in creating a good database model or design must be to achieve data integrity, scalability, and performance. Reasonable normalization can help you in this regard. I suggest you search SQL BOL or the web for topics dealing with the benefits of normalization.


Post #546299
Posted Monday, August 04, 2008 6:42 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 26, 2009 2:38 PM
Points: 7, Visits: 15
I've have been normalizing my data a lot - almost always to the 3rd normal form. It is just that when I look at the model I saw with so many entities and sub entities, it appears that the tables will be a lot. With this, I do not know if I am on the right track.

sabyasachi.mukherjee:
I'm not using any data modeling tool. I'm checking out Erwin though.

Thank you.
Post #546448
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse