You can also create dynamic entity diagrams Entity Relationship Diagrams (ERDs) for Aptify entities using Microsoft SQL Server Management Studio.
Follow these steps:
- Launch SQL Server Management Studio and connect to the Aptify server as an administrative user.
- In the Object Explorer, expand the Databases folder to view a list of available databases.
- Expand the APTIFY database.
- Right-click the Database Diagrams folder and select New Database Diagram.Create Database Diagram
- Right-click the Database Diagrams folder and select New Database Diagram.Create Database Diagram
- Select a table to add the diagram from the list provided. Click Add. Add Tables to Diagram
- Add additional tables as necessary. Click Close when finish.
- The database diagram loads, displaying information about the table or tables you added.
- The database diagram loads, displaying information about the table or tables you added.
- 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.
...
-
- Modify the diagram as necessary and save the results, if desired.