Now that you have worked with Robert Iko at the MovinOn moving and storage company to develop the…

Now that you have worked with Robert Iko at the MovinOn
moving and storage company to develop the design for the MovinOn database, he
explains that their most pressing task is to serve the needs of the Human
Resources department. Darnell Colmenero is an administrative assistant
responsible for many human resources tasks, and asks for your help extracting
information from the MovinOn database. Although an outside company processes
payroll for MovinOn, Darnell and others maintain all employment information and
strive to meet management’s goal of recruiting and retaining skilled, qualified
»

Now that you have worked with Robert Iko at the MovinOn
moving and storage company to develop the design for the MovinOn database, he
explains that their most pressing task is to serve the needs of the Human
Resources department. Darnell Colmenero is an administrative assistant
responsible for many human resources tasks, and asks for your help extracting
information from the MovinOn database. Although an outside company processes
payroll for MovinOn, Darnell and others maintain all employment information and
strive to meet management’s goal of recruiting and retaining skilled, qualified
employees who are well trained in customer service. Having employees working in
three warehouses in three states has made it difficult to track employee
information, and the potential merger and expansion means that human resources
must take advantage of the MovinOn database to maintain and retrieve employee
information. Darnell asks for your help in filtering data and creating queries
that provide the information that he needs.

Complete the following:

Darnell is completing a small business certification form
for the U.S. Department of Labor, and needs quick answers to some basic
questions about employees. Answer the following questions:

a. In what states do the MovinOn employees reside?

b. How many employees live in each state?

c. Who is the oldest employee? Who is the youngest?

d. Who makes the highest salary?

e. Who is paid by salary? Who is paid by hourly rate?

f. Who is paid the lowest hourly rate?

g. Are there any positions for which there are no employees?

h. How many types of jobs are offered at MovinOn? How many
people are employed in each type of job?

»