Service Request SR-ht-03
Service Request SR-ht-003
TechTarget says “Computer databases typically contain aggregations of data records or files, such as sales transactions, product catalogs and inventories, and customer profiles” (TechTarget pg. 1). This is exactly what Team A plans to accomplish for Huffman Trucking. Huffman Trucking is looking for fleet truck maintenance database to help keep track of all of their truck maintenance needs. The database began on April 1, 2013 and has a scheduled completion date on April 25, 2013. The scope of this service request is to keep track of parts, maintenance, vendors, and vehicles.
First our team decided on what to incorporate into our database to complete everything needed for Huffman Trucking’s truck maintenance needs. When a part is purchased a record is inserted into Parts Inventory Purchases and Parts Purchasing History adding to the quantity in Parts Catalogue. When a part is issued a record is inserted into Parts Inventory Issues and a quantity is decreased in Parts Catalogue. When a vehicle has maintenance a record is inserted into Maintenance Work Order and Vehicle Maintenance and a quantity is deducted from Parts Catalogue. When there is tire maintenance a record is inserted into Maintenance Work Order and Tire Maintenance is updated.
Next is the explanation of what are in the tables and the entity relationship between them. Table Tire Maintenance, this table has a relationship with Table Vehicle Maintenance. Their relationship is when the maintenance type ID is entered into the database it is automatically connected to the Table Maintenance work order section of the database. Table Maintenance work order has a relationship with Table Vehicle Types for type of vehicle. Part ID relates to Table parts Inventory Issues to link any kind of parts inventory subjects. Table Parts Inventory Issues has a relationship with Table Parts Inventory Purchases for any type of purchase information. Table Parts Catalogue has relationship with Table
TechTarget says “Computer databases typically contain aggregations of data records or files, such as sales transactions, product catalogs and inventories, and customer profiles” (TechTarget pg. 1). This is exactly what Team A plans to accomplish for Huffman Trucking. Huffman Trucking is looking for fleet truck maintenance database to help keep track of all of their truck maintenance needs. The database began on April 1, 2013 and has a scheduled completion date on April 25, 2013. The scope of this service request is to keep track of parts, maintenance, vendors, and vehicles.
First our team decided on what to incorporate into our database to complete everything needed for Huffman Trucking’s truck maintenance needs. When a part is purchased a record is inserted into Parts Inventory Purchases and Parts Purchasing History adding to the quantity in Parts Catalogue. When a part is issued a record is inserted into Parts Inventory Issues and a quantity is decreased in Parts Catalogue. When a vehicle has maintenance a record is inserted into Maintenance Work Order and Vehicle Maintenance and a quantity is deducted from Parts Catalogue. When there is tire maintenance a record is inserted into Maintenance Work Order and Tire Maintenance is updated.
Next is the explanation of what are in the tables and the entity relationship between them. Table Tire Maintenance, this table has a relationship with Table Vehicle Maintenance. Their relationship is when the maintenance type ID is entered into the database it is automatically connected to the Table Maintenance work order section of the database. Table Maintenance work order has a relationship with Table Vehicle Types for type of vehicle. Part ID relates to Table parts Inventory Issues to link any kind of parts inventory subjects. Table Parts Inventory Issues has a relationship with Table Parts Inventory Purchases for any type of purchase information. Table Parts Catalogue has relationship with Table