Week 5 Summary Report
DBM/380
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 relational links where applicable to tie all the tables together and select appropriate primary keys for our tables. We have also gone through the process of assigning appropriate data types for your fields. All in all, I think that we are off to a good start and are looking forward to adding to our project over the coming weeks.
Week 3 Summary Report
Our team was required to create documentation that explains the process of creating the entity-relationship diagram (ERD) in the change request for our project. We have three parts for our ERD: Vehicles, Parts, and Maintenance.
Part One: Vehicles
Our entities for the first part of our ERD are Vehicles, Vehicle Types, and Vehicle Maintenance. Our attributes for the entity Vehicle consist of VIN, Type ID, Class Code, Put into service date, Gross Weight, Mileage, Purchase Price, Accumulated Depreciation, Taken out of service Date, and capacity. The attributes for entity Vehicle Types are Type ID, Description, and VIN. The attributes for the entity Vehicle Maintenance are listed as Vehicle Serial Number, Vehicle Part ID, Maintenance Type ID, Put in service date, Last maintenance data,