Core Concepts of Accounting Information Systems 12th Edition by Carolyn Strand Norman, Mark Simkin

Exercise 4

The information in Figure 4-20 is for the employees of the Marcia Felix Corporation. Use a DBMS software package to create a database for it.
a. What record structure did you design? Identify the names, widths, and other characteristics of each field in a typical record.
b. Sort these employees by department. Print this list.
c. Sort these employees by test score. Print this list.
d. Sort these employees by department and alphabetically by last name within department.
e. What is the average pay rate for these employees?
f. What is the average pay rate for females? What is the average for males?
g. What females scored over 70 on their examinations? What males scored over 50?