Details of this Paper

Course Project Scenario

Description

solution


Question

Course Project Scenario;Exotic Cars Inc. (ECI) is a company specializing in sales and maintenance of the exotic (hence the name) cars.;The cars that ECI sells come from multiple sources: some are shipped directly from the factories, other purchased from the private collectors, and yet some other cars are traded-in by the customers of ECI.;ECI also provides a regular maintenance service of the exotic cars, such as engine tune-up, tire rotation, oil change, etc. You do not have to buy a car from ECI to use its maintenance service, consequently, some owners of the exotic cars purchased elsewhere also use ECI maintenance service.;ECI appreciates continuing business of its patrons, consequently, the company wants to maintain as much information about each valuable customer as it possibly can.;As a result, ECI diligently records how much money each customer spends on buying cars (more than a half have purchased two cars and about third bought three or more), on maintenance service (how much customer spends overall, and per car), and whether or not a customer ever traded a car in.;Course Project Description;Your goal is to develop a database that shall allow ECI to keep track of its business and provide the management with the following information regarding the performance of the business;HR Management;Complete information about ECI employees, especially salesmen and technicians;Inventory Management;Complete information on the number and types of the cars currently kept in stock;Complete information on the number and types of the cars obtained from each source (factory, private collector, trade-in, etc.);Maintenance Service Management;Complete information on the number and types of the cars that were serviced.;Complete information on maintenance record of each serviced car (car information, type of problem, owner, mechanic who performed the maintenance, and cost of maintenance);Customer Service Management;Complete information on every customer including information regarding their;Total spending on cars;Total spending on service maintenance;Accounting;Complete information on spending of every customer;Complete information regarding what was paid to each vendor;Complete information regarding what was received by ECI from the sales of cars;Complete information regarding what was received by ECI from the maintenance service;NOTE: You don?t have to implement all of the required functionality- use the description above to determine entities and attributes that you data model must include.;Submission of the Project;You are going to submit the Course Project over the following sequence of steps (a single deliverable per step);Course Project: SQL code used to create your DB Schema and populate your DB Tables;Course Project: Reports

 

Paper#67701 | Written in 18-Jul-2015

Price : $32
SiteLock