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

  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 

    • Posted: 4 years ago
    • Due: 27/02/2016
    • Budget: $50

    You don't know how to answer this question. We can help you find the right answer.

    We assure you an A+ quality paper that is free from plagiarism. Order now for an Amazing Discount! Use Discount Code "save15" for a 15% Discount!

    Get Started

    No need to wonder who can do my homework. You can always reach our team of professionals to do your homework at a low price.