Already have an account? Get multiple benefits of using own account!
Login in your account..!
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
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 DescriptionYour 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 ManagementComplete information about ECI employees, especially salesmen and techniciansInventory ManagementComplete information on the number and types of the cars currently kept in stockComplete information on the number and types of the cars obtained from each source (factory, private collector, trade-in, etc.)Maintenance Service ManagementComplete 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 ManagementComplete information on every customer including information regarding their:Total spending on carsTotal spending on service maintenanceAccountingComplete information on spending of every customerComplete information regarding what was paid to each vendorComplete information regarding what was received by ECI from the sales of carsComplete information regarding what was received by ECI from the maintenance service.
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
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
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 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 requirements. State any assumptions you have that affects your design and three-level schema architecture for the Gyan Gurukul Company that
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
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 to add appropriate indexes. Also use Optimize and Explain to show how the performance of this query has improved.
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