The information in Figure 5 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 pay rate. Print this list.
d. Sort these employees by test score. Print this list.
e. Sort these employees by department and alphabetically by last name within department.
f. What is the average test score for these employees?
g. What is the average score for females? What is the average score for males?
h. What is the average pay rate for these employees?
i. What is the average pay rate for females? What is the average for males?
j. What females scored over 70 on their examinations? What males scored over50?

Transcribed Image Text:

MMMMFFMFMMFMFMMMFMFFMMMM $7 7 6 5 7 7 9 8 7 8 6 7 689787998788 ID- B D B E C D D D B A A C D E D D A A B E B E B 42 41 55 58 45 47 53 55 61 40 67 86 37 66 62 55 48 67 46 41 56 0 TS