SQL WEEK 2

Implement the following relational database in SQL Server:

Person (pname, street, city)

WorksFor (pname, cname, salary)

Company (cname, city)

Manages (pname, mname)

Populate each table with at least 5 records.

Add additional four records to include:

1.            values “New York” and “Richmond” to the columns “city”  of the tables “Company” and “Person”.

2.            value  $35,000  to the column “salary” of the table “WorksFor”

3.            value “BigStore” to the column “cname” of the table “Company”.

Copy and paste SQL code (all the CREATE and INSERT statements) from SQL Server to Notepad document