This project is to develop and build a database application for a real-world domain. Step by step, you will design a schema, create a database, populate your database with data, maintain, query and update your data. You have to develop your database, design an entity-relationship diagram (E/R) for the database, and translate it into the relational model.
Database Requirements:
• Customer Data: The name of every customer who ever purchased goods or services from the dealership, or those have visited the dealership. This includes name, address, phone #, email address, and type such as purchase, service, or visit.
• Employee Data: The information of every employees at the dealership, including name, address, phone#, email address, etc.
• Vehicle Data: Pertinent information on every vehicle the dealership ever worked on. This includes make, model, year, vehicle identification number, price.
• Sales Data: Data on every vehicle sold through the dealership. In addition to the vehicle data above, the date sold, the customer it was sold to, the temporary tag number, any customization work done to the vehicle, a link to the billing data for that sale, ...
• Service Data: Data covering each service visit at the dealership. The vehicle and customer involved, the mechanic(s) who worked on the vehicle, the vehicle mileage when it arrived at the dealership and when it left the dealership, preliminary estimates, what was actually done to the car, and final billing information, the date