SQL Reference
This section shows the data found in the EMP_PHOTO files (pictures of
employees) and EMP_RESUME files (resumes of employees).
Figure 13. Delores M. Quintana
The following text is found in the db200130.asc and
db200130.scr files.
Resume: Delores M. Quintana
Personal Information
- Address:
- 1150 Eglinton Ave Mellonville, Idaho 83725
- Phone:
- (208) 555-9933
- Birthdate:
- September 15, 1925
- Sex:
- Female
- Marital Status:
- Married
- Height:
- 5'2"
- Weight:
- 120 lbs.
Department Information
- Employee Number:
- 000130
- Dept Number:
- C01
- Manager:
- Sally Kwan
- Position:
- Analyst
- Phone:
- (208) 555-4578
- Hire Date:
- 1971-07-28
Education
- 1965
- Math and English, B.A. Adelphi University
- 1960
- Dental Technician Florida Institute of Technology
Work History
- 10/91 - present
- Advisory Systems Analyst Producing documentation tools for engineering
department.
- 12/85 - 9/91
- Technical Writer Writer, text programmer, and planner.
- 1/79 - 11/85
- COBOL Payroll Programmer Writing payroll programs for a diesel fuel
company.
Interests
- Cooking
- Reading
- Sewing
- Remodeling
Figure 14. Heather A. Nicholls
The following text is found in the db200140.asc and
db200140.scr files.
Resume: Heather A. Nicholls
Personal Information
- Address:
- 844 Don Mills Ave Mellonville, Idaho 83734
- Phone:
- (208) 555-2310
- Birthdate:
- January 19, 1946
- Sex:
- Female
- Marital Status:
- Single
- Height:
- 5'8"
- Weight:
- 130 lbs.
Department Information
- Employee Number:
- 000140
- Dept Number:
- C01
- Manager:
- Sally Kwan
- Position:
- Analyst
- Phone:
- (208) 555-1793
- Hire Date:
- 1976-12-15
Education
- 1972
- Computer Engineering, Ph.D. University of Washington
- 1969
- Music and Physics, M.A. Vassar College
Work History
- 2/83 - present
- Architect, OCR Development Designing the architecture of OCR
products.
- 12/76 - 1/83
- Text Programmer Optical character recognition (OCR) programming in
PL/I.
- 9/72 - 11/76
- Punch Card Quality Analyst Checking punch cards met quality
specifications.
Interests
- Model railroading
- Interior decorating
- Embroidery
- Knitting
Figure 15. Bruce Adamson
The following text is found in the db200150.asc and
db200150.scr files.
Resume: Bruce Adamson
Personal Information
- Address:
- 3600 Steeles Ave Mellonville, Idaho 83757
- Phone:
- (208) 555-4489
- Birthdate:
- May 17, 1947
- Sex:
- Male
- Marital Status:
- Married
- Height:
- 6'0"
- Weight:
- 175 lbs.
Department Information
- Employee Number:
- 000150
- Dept Number:
- D11
- Manager:
- Irving Stern
- Position:
- Designer
- Phone:
- (208) 555-4510
- Hire Date:
- 1972-02-12
Education
- 1971
- Environmental Engineering, M.Sc. Johns Hopkins University
- 1968
- American History, B.A. Northwestern University
Work History
- 8/79 - present
- Neural Network Design Developing neural networks for machine intelligence
products.
- 2/72 - 7/79
- Robot Vision Development Developing rule-based systems to emulate
sight.
- 9/71 - 1/72
- Numerical Integration Specialist Helping bank systems communicate with
each other.
Interests
- Racing motorcycles
- Building loudspeakers
- Assembling personal computers
- Sketching
Figure 16. James H. Walker
The following text is found in the db200190.asc and
db200190.scr files.
Resume: James H. Walker
Personal Information
- Address:
- 3500 Steeles Ave Mellonville, Idaho 83757
- Phone:
- (208) 555-7325
- Birthdate:
- June 25, 1952
- Sex:
- Male
- Marital Status:
- Single
- Height:
- 5'11"
- Weight:
- 166 lbs.
Department Information
- Employee Number:
- 000190
- Dept Number:
- D11
- Manager:
- Irving Stern
- Position:
- Designer
- Phone:
- (208) 555-2986
- Hire Date:
- 1974-07-26
Education
- 1974
- Computer Studies, B.Sc. University of Massachusetts
- 1972
- Linguistic Anthropology, B.A. University of Toronto
Work History
- 6/87 - present
- Microcode Design Optimizing algorithms for mathematical functions.
- 4/77 - 5/87
- Printer Technical Support Installing and supporting laser printers.
- 9/74 - 3/77
- Maintenance Programming Patching assembly language compiler for
mainframes.
Interests
- Wine tasting
- Skiing
- Swimming
- Dancing
[ Top of Page | Previous Page | Next Page ]