Need to have a SQL DB PROJECT COMEPETED WITH SQL DB FILES Summary Your goal is to develop a…

Need to have a SQL DB PROJECT COMEPETED WITH SQL DB FILES

 

Summary

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):

Course Project: ERD

Course Project: Normalized Data Model

Course Project: SQL code used to create your DB Schema

Course Project: Contents of the DB Tables

Course Project: Forms

Course Project: Reports Posted: 4 years agoDue: 27/02/2016Budget: $50

Looking for a similar assignment? Get 15% discount on your first order with us
Our experts will take care of your task no matter the deadline!
Use the following coupon
"SAVE15"

Order Now