Nt1310 Unit 9 Assignment 1

1322 Words6 Pages
CIS 11 Information methods Assignment 2 Executive Summary Table of Contents | Page | Category 3 | 123 | | | | | | 234 | | 345 | | | Introduction * Information Gathering A database needs to be developed that will keep track of all cars the dealership has available for sale. There are two sites where vehicles are located, one being the car dealership lot and the other being an off site location. The database will ensure the dealership is able to obtain specific details of what stock is available at any given time, i.e. (Civic, 2012, blue, diesel) and where the stock is located. It will also provide details about who has purchased the vehicles, whether finance was obtained from the dealership and will…show more content…
Similarly, the relationship between Location and Vehicle has a one to one relationship, as one location is only able to store one vehicle at a particular point in time. Vehicle and Customer * The relationship between Vehicle and Customer has a one to many relationship as one vehicle has one customer. The relationship between Customer and Vehicle is one to many as one customer may have more than one vehicle. * * * Customer and Service Department * The relationship between Customer and Service Department has a many to many relationship as a customer may have purchased more than one vehicle, which requires service bookings. Similarly, the relationship between Service Department and Customer has a many to many relationship as the Service Department has many customers. Customer and Finance * The relationship between Customer and Finance has a many to many relationship as a customer may have more than one finance loan. Also, the relationship between Finance and Customer is many to many as the Finance department has many customers. * * * * * * *

More about Nt1310 Unit 9 Assignment 1

Open Document