DBM 380 Week 5 Individual Assignment

DBM 380 Complete the project work for SR-ht-003 and Change Requests 2-5.

Complete the Microsoft® PowerPoint® presentation in which you explain how the principles of database management and your recommendations were applied to the project.

Submit your team- project work and documentation to your facilitator.



Access Service Request SR-ht-003, “Develop a Design for a Fleet Truck Maintenance Database” located on the Huffman Trucking IT Service Requests site. 

Complete Service Request SR-ht-003 due in Week Five.

Include Change Requests 2-5 in addition to the base request.

Smith Systems Consulting developed entities and attributes for Fleet Truck Maintenance but did not develop the database. In an effort to better document our applications, Entity-Relationship Diagrams are needed.

Change request
2
Requestor
IT Project Manager
Description
Using Microsoft Access, create the tables for the Fleet Truck Maintenance database.


Change request
3
Requestor
IT Project Manager
Description
Using Microsoft Access, link the tables for the Fleet Truck Maintenance database. Populate the tables with ten records of fictional, but realistic, test data.
Change request
4
Requestor
IT Project Manager
Description
Using Microsoft Access, create input forms for the Fleet Truck Maintenance database.

Change request
5
Requestor
IT Project Manager
Description
Using Microsoft Access, create queries for the Fleet Truck Maintenance database.