Please see the attached file.
The rule for assigning primary key is that it should uniquely identify each record in the table.
Primary key: Driver Identification_NO
Reason: This table contains the details of drivers. Driver Identification_NO field would be sufficient to uniquely identify each entry in the table as each driver has a unique identification no.
Table: DRIVER LOG
Primary key: Segment_ID, Driver_ID, Start_date and Start_time
Reason: None of the fields or combination of fields in this table would be able to uniquely identify each record. This is ...
This posting contains solution to following database question in MS Access.