Q:
How to implement an Entity Relationship Diagram into a working database?
I need to implement a ER diagram into a working database. I'm hoping to use Microsoft SQL Server 2005 Developer edition. I need to know all the details of how to implement an ER diagram such as what happens to a relationships between entities, how to implement "Is a" relationhips, how to implement has a relationships, how to refine many to many, one to many, many to one, one to one relationships, how to implements participation constraints, ect. References to online tutorials would be of great help.
ASKED:
Apr 3 2009 0:52 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
You can also use Visio to reverse engineer your database.
If what you are asking is how to create the database in Sql Server from the ER diagram you designed, take a look at the following article:
Database Design: Creating The Physical Database
