Data Conversion - Information Systems Reengineering, Integration and Normalization - page 176

Relation Car_rental
Car_model

Staff_ID *Trip_ID

MZ-18 A002 T0001

MZ-18 B001 T0002

R-023 B004 T0001

R-023 C001 T0004

SA-38 A001 T0003

SA-38 A002 T0001

Relation People
Staff_ID

Name DOB

A001 Alexander 07/01/1962

A002 April 05/24/1975

B001 Bobby 12/06/1984

B002 Bladder 01/03/1980

B003 Brent 12/15/1979

B004 Belandar 08/18/1963

C001 Calvin 04/03/1977

C002 Chevron 02/02/1974

Relation Car
Size

Car_model Description

Relation Trip
Trip_ID *Department_ID
T0001 AA001
T0002 AA001
T0003 AB001
T0004 BA001
Relation Departme nt
*Department_ID Salary

AA001 35670

AB001 30010