Question

Final Project: Part I

For Part I of your final project, you will design your plan for the scenario provided below. Your project plan should include the entity relationship diagram (ERD).

Scenario

Imagine that you just started a new job at ABC Car Sales. You’ve been given the task of adding all the new and used car inventory to a new database management system (DBMS). You would like to manage the new and used car sales in the new DBMS.

Listed below are the categories of information that you will need to input in the new database for each type of inventory:

New Vehicle Inventory	Used Vehicle Inventory
VIN Number	VIN Number
Price	Price
Make	Make
Model	Model
Year	Year
Exterior Color	Exterior Color
Interior Color	Interior Color
Transmission (Manual/Automatic)	Transmission (Manual/Automatic)
Engine (# of cylinders)	Engine (# of cylinders)
Mileage	Mileage
Fully loaded (Yes/No)	Fully loaded (Yes/No)
	Carfax Report (Yes/No)

You will also want to track the following types of information for new and used car sales, including specific customer data.

New Car Sales	Used Car Sales
Sales ID Number	Sales ID Number
VIN Number	VIN Number
Customer ID	Customer ID
Advertised Price	Advertised Price
Purchase Price	Purchase Price
Financed (Yes/No)	Financed (Yes/No)
Date sold	Date sold

Customer

Customer ID

First Name

Last Name

Address

Phone Number

Sales ID Number

Instructions

For Part I of the project, complete the following steps. Your normalized entity relationship diagram can be created by hand, or in PowerPoint. If you decide to hand-write your ERD, please scan and submit it as a PDF fie. If you create your ERD in PowerPoint, please submit as a PowerPoint file.

1. Identify which entities should be normalized.
2. Create a normalized entity relationship diagram. In your diagram,
   • show the relationship between the tables
   • include notations and symbols as needed

Drawing your ERD

To draw your ERD, you can use either of the following methods:

1. Your ERDs can be handwritten, scanned, and submitted as a PDF.
2. You can use PowerPoint to draw your ERD and submit as a PPT or PPTX file.

Answer 1

ntce Matae eod 忙.tdレ1 ume 心11 set.t..heLD veke,bofLpd ini