Language: Java

(This program can be done in any language I prefer Java, but it doesn't matter just let me know which language it is please)

(Let me know if any confusing)

1 Project Timeline The project has three deliverables; ER Diagram: each group should develop an ER Model for the application ("Automobile Sales Database") The ER Diagram can be included in the report as any type of image file. e Relational Schema: the second deliverable is a translation of the ER Model into a relational schema implemented as an SQL script. The script should use Oracle's SQL dialect and should execute without errors on the fourier.cs.it.edu Oracle accounts. Besides from defining tables and constraints, this script may include views or indexes where appropriate. Please upload the script as a simple text file. . Application: the last deliverable is an Automobile Sales Application that uses the relational schema defined in the first two deliverables. This application can be either a web or desktop application. Please feel free to use GitHub or BitBucket to manage/exchange the source codes with your teammates. Submission (Deadline 12/05/2018): a report (including the ER Diagram, the screen shots of the ap- plication, each student's contributions, and necessary description), source codes, and an SQL script file. Demo (12/02/2018-12/05/2018): demo can be done via a face-to-face meeting ( slot with the instructor and TA) or video (taping a video for your application and sharing the link to the instructor and TA). a 10-min time 2 Overview The application is an automobile company, such as General Motors, Ford, Toyota, or Volkswagen. In our hypothetical company, it has been decided to redesign a major part of the database that underlies company operations. Unfortunately, the manager assigned to solicit database design proposals is not very computer literate and is unable to provide a very detailed specification at the technical level. Fortunately, you are able to do that. The company needs to keep quite a bit of data, but we shall focus on the following aspects of corporate operations. . Vehicles Each vehicle as a vehicle identification number (VIN). Brands: Each company may have several brands (for example, GM has Chevrolet, Pontiac, Buick, Cadillac, GMC, Saturn, Hummer, Saab, Daewoo, Holden, Vauxhall; Opel and Volkswagen has Volk swagen, Audi, Lamborghini, Bentley, Bugatti, Skoda, and SEAT