Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
924 views
in Technique[技术] by (71.8m points)

database - What is the PK and FK i should assign to my table?

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

I've written a more exhaustive answer over at your other question.
normalization of database

If you need to match a driver and a vehicle to a staff member, then you can do a three column composite pk with fk associations with the three other tables. You'll need to wire up your own logic to actually do the organization... this would not be done in the database, the db should just retain the results of the organization.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...