Details of this Paper

SQL WEEK 2

Description

solution


Question

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

 

Paper#70528 | Written in 18-Jul-2015

Price : $27
SiteLock