Question

Date: This is the take home portion of your exam. It is due on the following class. Total Points:15 1. Examine the tables and relationship diagram below. Answer the questions that follow Relationship Diagram Titles Location!D EmplayeelD TaleNamae Employees Table 2016-01-3001581000 eming Mc Key Location Table LocationlD Location Address State 430 Peachtree Road 3 Commons Blvd 15 Forbes Avenue 3750 River Road 3495 Fifth Awenue, Suite 33998 4Montgomery Street 404) 333-5555 517) 1214444 412) 555-1111 816) 555-9998 212) 555-6654 (419 555-3757 30316 MA PA Mo NY MA NURL L02 L05 LDS NULL etsburgh Kansas City New York San Francisco NULL 15219 64101 0029 94102

Answer 1

a. select e.LastName, e.FirstName from Employees e, Location l where e.LocationID=l.LocationID and l.State='MO';

b.

LastName	FirstName
Fleming	Karen
Daniels	Phil

c. if we need to select the Value dynamically rather than static mode. We have to write the query as

• select e. LastName, e. FirstName from Employees e, Location l where e. LocationID=l.LocationID and l.state=&state;

d. because for each employee the minimum salary is greater than 20000. So each and every record in the employee table and their corresponding data will be printed.

LastName	FirstName	State	EducationRequired	MinimumSalary
Lacher	Tom	GA	FourYear Degree	25000
Fantis	Lauries	MA	Four years Degree	25000

Like this other employees information in the employees is also printed.

Image is not clear that's why it us unable to write whole table.