How to create a database diagram?

Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.

How to create a database diagram?

Rating:

Take the following steps to create a database diagram:

1. Run SQL Server Management Studio from Start > Programs > Microsoft SQL Server 2005 > SQL Server Management Studio.
   
   



2. In the Connect To Server window, select the Server name and click the Connect button.
   
   



3. In the Microsoft SQL Server Management Studio window, double-click the Databases folder.
   
   



4. In the Microsoft SQL Server Management Studio window, double-click the database for which a database diagram is to be created.
   
   



5. In the Microsoft SQL Server Management Studio window right-click the Database Diagrams folder and select New Database Diagram.
   
   



6. In the Add Table dialog box, select the tables and click the Add button. Now, click the Close button.
   
   



7. The tables are added in the work area. Drag the column from the first table to the second table. Both the columns should be either primary or foreign key.
   
   



8. In the Tables and Columns dialog box, specify a name for the relationship. Also specify the primary key and foreign key table names.
   
   



9. In the Foreign Key Relationship dialog box, edit the properties for the relationship as required.
   
   



10. A relationship is created between the tables.
    
    



11. On the File menu, select the Save Diagram_0 option.
    
    



12. In the Choose Name dialog box, specify a name for the diagram and click the OK button.
    
    



13. In the Save dialog box, click the Yes button.
    
    



14. The diagram is saved in the specified database.
    
    

Rating: