Develop a database that shall allow eci

Assignment Help Database Management System
Reference no: EM13810504

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.

Reference no: EM13810504

Show the count of the class after deleting

Will insert any first name, last name, ID, GPA, and phone number, in the proper location in the list sorted alphabetically by last name.  After insertion, you should show th

Find the start and end dates of cruise number

Write SQL SELECT commands to answer the following queries. Find the start and end dates of cruise number 35218. List the names and ship numbers of the ships built by the Ace S

Create a new database in which to store all the objects

Problem: BoarDome is in the business of producing skate, surf and snow boards. They run a small museum and gift shop, located in airports in cities where the extrem

Erp systems based on size

ERP systems or Enterprise Resource Planning consists of many processes working in unison to aid the business in function and profitability. The system is designed to streaml

Design an er diagram to capture the given requirements

Design an ER diagram to capture the requirements. State any assumptions you have that affects your design and three-level schema architecture for the Gyan Gurukul Company that

Identify any referential integrity violations, if any

Given the following data types of some table fields and the simple schema of the relational database they are a part of, inspect its relationships for any referential integr

Explain the average length of stay per room type

What is the average length of stay per room type. What is the average number of visitor per room type. What is the base income per room (i.e., length of visit multiplied by th

Optimize the query in the select script using alter table

optimize the query in the select script using Alter Table to add appropriate indexes. Also use Optimize and Explain to show how the performance of this query has improved.

Reviews

Write a Review

 
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd