Week4 DBM Work

Running head: ENTITIES AND ATTRIBUTES

ENTITIES AND ATTRIBUTES

Huffman Trucking Fleet Maintenance Database Solution

Entities and Attributes

(Student’s Name)

(Professor’s Name)

(Course Title)

(Date of Submission)

Introduction

An Entity is an object in the real world; something that exist and can be distinguished from other entities. An Attribute on the other hand is a characteristic of an entity. Any association between two or more entities is called a relationship. An Entity Relationship Model (ER Model) is a data model in which information is stored in the database and viewed as sets of entities and sets of relationships among entities.

The following are the entities and their attributes of the Huffman Trucking Fleet Maintenance Database.

Entity: Vehicle

· Attributes: Vehicle_Identification_Number (VIN), Type_ID, Class_Code, Put_Into Service_Date, Gross_Weight, Mileage, Purchase_Price, Accumulated_Depreciation, Purchase_Price, Take_out of_Service_Date, Capacity

Entity: Vehicle Type

· Attributes: Type_ID and Type_Description

Entity: Vehicle Maintenance

· Attributes: Vehicle_Serial_Number, Vehicle_Part_ID, Maintenance_Type_ID, Put_In Service_Date, Last_Maintenance_Date, Next_Scheduled_Maintenance_Date, Under_Warranty_Flag

Entity: Maintenance Descriptions

· Attributes: Maintenance_Type_ID, Level_Code, Description, Average_Hours_Required, Days_Between_Recommended Maintenance, Maximum_Days_Between_Maintenance

Entity: Maintenance Work Order

· Attributes: Work_Order_ID, VIN, Part_DI_maintenance_Type_ID, Assigned_To, Date_Started, Date_Completed, Hours

Entity: Tire Maintenance

· Attributes: Barcode, Type, Vehicle_Type, Manufacture_ID, Put_In_Service Date, Rotation_Schedule, Last_Rotation

Entity: Parts Catalogue

· Attributes: Catalogue_ID, Description, Type, Manufacturer, Quantity_At_Hand, Record_Point, Recorder_Quantity

Entity: Parts Purchasing History

· Attributes: Trasaction_ID, Catalogue_ID, Quantity, Vendor_ID, Order_ID, Order_Quantity, Shipping, Tax, FOB, Purchase_ID

Entity: Parts Inventory Issues

· Attributes: Trasaction_ID, Date, Price, Quantity, Maintenance_Serial

Entity: Parts Inventory Purchases

· Attributes: Purchase_ID, Date, Price, Quntity

Entity: Vendor

· Attributes: Vehicle_ID, Name, Order_Address, Street, City, State, Zip, Order_Contact, Order_Tel