Develop a database that shall allow ES to keep track of its business and provide the management with the following information regarding the performance of the business:

Your goal is to develop a database that shall allow ES 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 ES 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 ES from the sales of cars
•   Complete information regarding what was received by ES 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: RED
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