Explore BrainMass
Share

Explore BrainMass

    MS acess: Setting up the keys

    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 October 9, 2019, 6:53 pm ad1c9bdddf
    https://brainmass.com/computer-science/files/ms-acess-setting-keys-101168

    Attachments

    Solution Preview

    Please see the attached file.

    PRIMARY KEYS
    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.

    $2.19