Creating an ERD Using SQL Server Management Studio

You can also create dynamic entity diagrams 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.Create Database Diagram
4. Select a table to add the diagram from the list provided. Click Add. Add Tables to Diagram
5. Add additional tables as necessary. Click Close when finish.

• The database diagram loads, displaying information about the table or tables you added.

1. 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. Adding Related Tables

• 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. Sample Database Diagram

1. Modify the diagram as necessary and save the results, if desired.