I need help setting up keys and relationships with the attached database. Please post your recommendations as a new MS Access file as well as a text explanation for the reasons.© BrainMass Inc. brainmass.com March 4, 2021, 7:26 pm ad1c9bdddf
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.