Service Request Sr-Ht003 Change Request 3

Service Request SR-ht003 Change Request 3

Well-defined relationships between tables create a database that allows for better applications, reports, and maintenance. Every database system should allow information to be obtained or updated easily and quickly. Relationships link tables together to enable applications and reporting software to gather and analyst information from all the tables in the database. A report on stock outages, an application to remove or add a part to a location, or a maintenance program to update a supplier’s price list can all be created using the relationships and links for the vehicle maintenance system at Huffman Trucking. The five system functions used in the Huffman Vehicle Maintenance System are parts data, purchasing transactions, supplier data, vehicle data, and work-order transactions.

Parts Data

Two tables deal directly with parts and parts inventory. Parts_Detail table lists parts, description, and other attributes including the order point of parts when inventory reaches a set point. Location_Inventory table does what the name implies, an inventory of parts in stock and location of the parts in storage. These two tables, linked through the Part_ID attribute, listed in both tables, in a many to one relationship.

Purchasing Transactions

The purchasing transactions are comprised of two tables and two relationships. The first relationship is with the Purchase_Header table. The Purchase_ID on the Purchase_Header table is auto-numbered and is connect minimal information such as the supplier’s identification number and purchase date on this table. To gain more detailed information about purchases made, the Purchase_ID is linked from the Purchase_Header table to the Purchase_ID on the Purchase_Detail table.

The second relationship is Part_ID on the Purchase_Detail_ID table which is linked to Part_ID from the Parts_Detail table. This will provide additional information during inventory searches about purchase details including...