Week 5 Summary Essay

1236 Words Mar 13th, 2015 5 Pages
Week 5 Summary Report
February 16, 2015
Devin Dickens

Week 5 Summary Report
Our learning team is getting off to a great start to our assignment we have created Visio diagrams to design and organize our database. We have also got started with the beginnings of the database by working to set up the tables that we are going to be using. We have also begun work on creating our PowerPoint presentation for the project. It has been a busy week with varied schedules, but we have sectioned the work off and kept in touch this has served us well. We followed the link to Entities and Attributes for the Fleet Truck Maintenance page and have been working on how we are going to incorporate them all into our design. We will use
…show more content…
The foreign keys are VIN and Type ID. These entities relate to each other because vehicles have different vehicle types, and every vehicle has to have maintenance. The primary keys were chosen because of their uniqueness, and each vehicle has its own VIN number as well as its own serial number.
Part Two: Parts
Five entity sets comprise the second part of our project: Vendors, Parts Catalogue, Parts Purchase History, Parts Inventory Purchases, and Parts Inventory Issues. This is the most complicated relationship because it follows the life of a part from purchase to issue: Huffman’s purchasing department consults its approved vendor list to acquire parts for inventory. Personnel run queries or print reports on purchasing history to research vendors. Parts are purchased from approved vendors. Huffman’s receiving department checks the parts into inventory upon receipt. When needed for truck maintenance, parts are checked out of inventory and billed directly to the appropriate work order. Primary keys for these entity sets focus on “ID” names; for example, VendorID. PartsID, and TransactionID. Foreign keys link the entity sets to enable creation of report forms and queries needed to adjust inventory, determine reorder points, and issue parts to work orders.
Part Three: Maintenance Entity sets for the third ERD section include Maintenance Work Order, Tire Maintenance, and Maintenance Descriptions. Huffman’s maintenance work

Related Documents