SQL 概説
ここに示すのは、
EMP_PHOTO ファイル (従業員の写真) と EMP_RESUME ファイル (従業員の履歴書) に含まれているデータです。
図 7. Delores M. Quintana

db200130.asc および db200130.scr のファイルに含まれているテキストは、
次のとおりです。
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
図 8. Heather A. Nicholls

db200140.asc および db200140.scr のファイルに含まれているテキストは、
次のとおりです。
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
図 9. Bruce Adamson

db200150.asc および db200150.scr のファイルに含まれているテキストは、
次のとおりです。
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
図 10. James H. Walker

db200190.asc および db200190.scr のファイルに含まれているテキストは、
次のとおりです。
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
[ ページのトップ | 前ページ | 次ページ | 目次 | 索引 ]