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.
Software/Hardware used:
Software/Hardware used:
ASKED:
April 3, 2009 12:52 AM
UPDATED:
April 3, 2009 2:34 PM
Answer Wiki:
If you are asking how to diagram an existing database, from within SQL Server Management Studio open the database, and select Diagrams. Add your tables, and it will create the diagram for you.
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:
<a href="http://www.informit.com/guides/content.aspx?g=sqlserver&seqNum=69">Database Design: Creating The Physical Database</a>
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
