VVIP Timed question 8o minutes

[VVIP timed question; 80 minutes) Using above tables , create SQL queries to answer the following questions: (10 marks)

a. Identify primary and foreign keys for both tables.

b. Write insert statements to enter first two records into EMPLOYEE table as shown in above figure.

c. Display a list that presents the data contained in employee table sorted first by employee last name and then by employee first name.

d. Display all of the data from both tables for Marketing' department.

e. How many employees belong to either Production or Finance department?

Consider the database for a company named Wedgewood Pacific Corporation (WPC) that contains data about company employees, department, projects, company assets, and other aspects of company operations. For the following questions, two tables will be considered as provided below: DEPARTMENT (DepartmentName, BudgetCode, OfficeNumber, Phone) EMPLOYEE( EmployeeNumber, FirstName, LastName, Department, Phone, Email) . . Dapartment Table: DepartmentName BudgetCode OfficeNumber Phone Administration BC-100-10 BLDG01-300 360-285-8100 Legal BC-200-10 BLDG01-200 360-285-8200 Accounting BC-300-10 BLDG01-100 360-285-8300 Finance BC-400-10 BLDG01-140 360-285-8400 Human Resources BC-500-10 BLDG01-180 360-285-8500 Production BC-600-10 BLDG02-100 360-287-8600 Marketing BC-700-10 BLDG02-200 360-287-8700 InfoSystems BC-800-10 BLDG02-270 360-287-8800 LastName Phone Email Jacobs Department Administration Administration 360-285-8110 Mary Jacobsen Rosalie Jackson Jackson 360-285-8120 Legal Bandalone Caruthers 360-285-8210 360-285-8310 Richard.Bandak Tom.Caruthers Accounting Jones Accounting 360-285-8320 Heather Jones Employee Table: EmployeeNumber FirstName (AutoNumber] Mary [AutoNumber] Rosalie [AutoNumber] Richard [AutoNumber] Tom (AutoNumber] Heather (AutoNumber] Mary (Auto Number] George [AutoNumber] Tom (AutoNumber] George (AutoNumber] Ken (AutoNumber] James (Auto Number] Rick Abernathy Finance 360-285-8410 Smith Human Resources 360-285-8510 Jackson 360-287-8610 Mary Abernathy George.Smithes Tom Jacksonen George Jones Ken.Numoto w Jones Production Production Marketing InfoSystems Info Systems 360-287-8620 360-287-8710 Numoto Nestor James.Nestores Brown 360-287-8820 Rick BrownGWE