SQL DB PROJECT

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

You are going to submit the Course Project over the following sequence of steps (a single deliverable per step):

1. Course Project: ERD

2. Course Project: Normalized Data Model

3. Course Project: SQL code used to create your DB Schema

4. Course Project: Contents of the DB Tables

5. Course Project: Forms

6. Course Project: Reports