Question: You are tasked with developing a relational database model for a Fleet Management System. Refer to your reading assignment for a sample relational database model.

You are tasked with developing a relational database model for a Fleet Management System. Refer to your reading assignment for a sample relational database model. The purpose of this system is to produce an asset listing of all trucks in the companys fleet including information on the truck, acquisition cost and depreciation. In addition, the system must provide a history of operational costs and maintenance costs categorized by the type of cost, e.g. gas, oil, and types of repairs.
The deliverable for this assignment must include:
A list of the tables in this model for use in the Fleet Management System. Each table must contain the top three attributes.
A list of application areas such as Purchasing and Accounts Payable which will be the source of the transactions necessary to update the Fleet Management System.
A system diagram of the Fleet Management System including databases and source data applications.
Brief narratives explaining your rationale behind the list of attributes and the contents of the system diagram, and list of source applications.
Use the System Proposal Template Download System Proposal Templateto complete this assignment. The proposal should be single spaced with double-spacing between paragraphs. Your submission should be a minimum of four pages not including the title page or references page, if used. Label all figures according to APA format and if citations and references are used, these must be formatted in APA7 format as well. Visit the Writing Center for more information on APA7 format. The CSU Global Library and Writing Center links can be found in the course navigation panel.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!