Dbm 380 Week 5 Learning Team Service Request Sr-Ht-003 Presentation

Service Request SR-ht-003 PresentationAdam HolmesNelson NolanWilliam PurcellBurton RheutonKevin ThistlethwaiteJune 18, 2012Ilka Kawashita Proposed TablesPARTS INVENTORY PurchasesTransaction ID Purchase DatePurchase PriceQuantityPARTS INVENTORY ISSUESTransaction ID Issue Date Purchase Price Quantity Proposed Tables Cont.PARTS CATALOGUE Huffman Trucking.IDDescription Type Manufacturer Quantity On Hand Reorder Point Reorder QuantityVENDORS Maintenance operation. Vendor ID Name Order addressStreet City State Zip Order Contact Order Phone Number Order Fax Number Billing AddressStreet City State Zip Billing Contact Billing Phone Number Billing Fax Number Proposed Tables Cont.Parts Purchasing History Maintenance operation.Transaction ID Catalogue ID Quantity Purchased Manufacturer ID Order Quantity PriceShipping Tax FOBVEHICLE MAINTENANCEVehicle Serial Number Vehicle Part ID Maintenance Type ID Put in Service Date Last Maintenance Date Next Scheduled Maintenance Date Under Warranty Flag Proposed Tables Cont.Tire MaintenanceBarcode Type Vehicle Type Manufacturer ID Put in Service Date Rotation Schedule Last Rotated Disposal DateMAINTENANCE DESCRIPTIONMaintenance Type ID Level Code Description Average Hours Required Days Between Recommended MaintenanceMaximum Days Between Maintenance Relation Table NormalizationThe first normal form includes having a unique name for each column the order of the rows and columns doesn’t matter each column has a single data type no two rows contain identical values each column contains a single value columns do not contain repeating groups Normalization