Visualize the Database Relationships. Use "Database Diagram" in the left pane $($or the tab "Database Tools" on the tool bar if your management studio is older than $2012)$ to create a visual representation of the database tables and relationships. Add the figure to your report.

Database Visualization tool can be found on Database diagram:

Right click on Database Diagram under your Company database in Object Explorer in the left pane of SQL Server Management Studio or under database Tool menu. This may vary depending on the version of your server.

If your client has a difficulty to display a Scheme Diagram, show the scheme of your Company database from Object Explorer by expanding each table and columns with PK and FK marked from your system catalogue.

Document your work. Add comments explaining the meaning of each component included in the report.

$2-1)$ Identify all the relationships in the given ERD for Company Database as Explained in Class

$2-2)$ Transform them into a logical Company Database schema: Write the corresponding DDL to create Company Database Schema by Creating $($or Altering each table if already created$)$ all $6$ Relations by defining all the PK$-$FK Constraints and NotNull constraint as shown in the given ER Diagram.

The typical SQL commands $($DDL$)$ to look up for this lab are as follow: