SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Creating database tables from models


Creating database tables from models

Author
Message
koosubscriptions
koosubscriptions
SSC-Enthusiastic
SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)

Group: General Forum Members
Points: 137 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.
sabyasm
sabyasm
SSCrazy
SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)SSCrazy (2K reputation)

Group: General Forum Members
Points: 2016 Visits: 524
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

alonzo
alonzo
SSC-Enthusiastic
SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)SSC-Enthusiastic (199 reputation)

Group: General Forum Members
Points: 199 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.



koosubscriptions
koosubscriptions
SSC-Enthusiastic
SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)SSC-Enthusiastic (137 reputation)

Group: General Forum Members
Points: 137 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum







































































































































































SQLServerCentral


Search