Creating an ERD Using SQL Server Management Studio

You can also create dynamic Entity Relationship Diagrams (ERDs) for Aptify entities using Microsoft SQL Server Management Studio.

Follow these steps:

1. Launch SQL Server Management Studio and connect to the Aptify server as an administrative user.
2. In the Object Explorer, expand the Databases folder to view a list of available databases.
3. Expand the APTIFY database.
   • Right-click the Database Diagrams folder and select New Database Diagram.
     
      
4. Select a table to add the diagram from the list provided. Click Add.
   
    
5. Add additional tables as necessary. Click Close when finish.
   
   • The database diagram loads, displaying information about the table or tables you added.
      
6. To add the tables related to a particular table in the diagram, right-click in a table's caption and select Add Related Tables from the pop-up menu.
   
   
   • SQL Server Management Studio adds the related tables to the diagram and displays the links between them. The figure below illustrates a sample diagram for the Committees entity and its related entities. 
     
      
7. Modify the diagram as necessary and save the results, if desired.