A company provides transport services to high-ranked staffs.
There are 3 tables: DRIVERS, VEHICLES, STAFFS.
DRIVERS
- license number [PK]
- name
- language spoken
- ... (and so on..)
VEHICLES
- vehicle ID [PK]
- registration number
- model
- colour
- ... and so on...
STAFFS
- staff ID [PK]
- name
- position name
- ... and so on....
I want to create a new table called ORGANIZE
whereby, it will assign a driver and a vehicle to match the needs of the staff.
what will be the PK and FKs?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…