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

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.

[order_calculator]
CategoriesUncategorized