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
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 ...
This posting contains solution to following problem on database using MS Access.