Explore BrainMass
Share

Explore BrainMass

    Keys and Relationships for Driver Log

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

    Using MS Access, create the keys and relationships between tables for the Driver LOG from the file attached.

    © BrainMass Inc. brainmass.com October 9, 2019, 7:27 pm ad1c9bdddf
    https://brainmass.com/computer-science/databases/keys-relationships-driver-log-118219

    Attachments

    Solution Preview

    Please find attached the modified database. I am also attaching the original document that i used to create the database originally. please check the reports section of database. It contains the relationships report. Also, when you open the relationship window, you can see all the relationships.

    Note: I have added Part_Id attribute in Part_Inventory purchases and Part_Inventory_Issues table.
    This was required for the table to make some sense.

    Entities and Attributes for Fleet Truck Maintenance

    This document was created by Smith Systems Consulting at the request of Huffman Trucking Maintenance Department. The descriptions provided are based on interviews with maintenance personnel who use the Fleet Truck Maintenance database. The creator of the database was not available.

    PARTS INVENTORY ...

    Solution Summary

    This posting contains solution to following problem on database using MS Access.

    $2.19