The Wilmer Ruiz Corporation employs the individuals listed in the data shown in Figure. Use a DBMS to create a database of this information.
a. What record structure did you use for this database? Identify the names, widths, and other characteristics of each field you created.
b. List all employees in Department 5. Print this list.
c. List all employees with first name €˜€˜Brenda.€™€™ Print this list.
d. List all those employees with pay rates over $6.50. Print this list.
e. List all those employees eligible for overtime (T = yes; F = no). Print thislist.

Transcribed Image Text:

Record Number Last Name First Name Social Security Number Pay Rate Over- time Dept ADCOX KOZAR MCLEAN CUNNINGHAM DANIELS MCGUIRE REEDER BLOOM DAVIS DUFFY HARPER MORGAN WELSH CHAPIN FINN HALPIN LAURIN MIAGLIO TURNER ZORICH NORMAN LINDA KAY TOM PATRICIA ANNE BRENDA BRENDA DENISE LESLIE LINDA 901795336 412935350 405751308 919782417 4 7.50 7.50 517351609 3 201891647 5.50 5.50 6.25 619294493 3 513321592 4 517351608 314532409 Yes 615824130 4 704563903 4 216253428 203767263 5 715386721 913541871 514484631 414224972 713589164 504455827 5 5.75 6.25 Yes KAREN GEORGE JOHN MARSHA PHILIP PEGGY BRENDA MILDRED 7.50 6.25 Yes 6.25