Explore BrainMass

Explore BrainMass

    MS acess: Setting up the keys

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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


    Solution Preview

    Please see the attached file.

    The rule for assigning primary key is that it should uniquely identify each record in the table.
    Table: DRIVER
    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 ...

    Solution Summary

    This posting contains solution to following database question in MS Access.