TxVans sells minivans made by Toyota and Honda and has hired your team to develop a Java application to manage its inventory. Each manufacturer offers several models of its minivan (e.g., LX, EX-L, SE, Touring). Each model comes with a standard set of equipment (e.g., the Honda Odyssey LX comes with wheels, seats, engine, radio, air conditioning, automatic transmission, airbags, rearview camera, usb audio interface, etc.). Minivans can have a variety of additional equipment or accessories (bluetooth, 3rd-row seat, smart entry, etc.), but not all accessories are available for all minivans (e.g., not all manufacturers offer a driver's side airbag). Some sets of accessories are sold as packages (e.g., the luxury package might include stereo, six speakers, cocktail bar, and twin overhead foxtails).
1. Design a data model in mySQL that is normalized to at least 3rd Normal Form. Export the model into a pdf and submit the pdf.
2. a. Create the database using the data model in mySQL
b. Add data for at least two minivan models for each manufacturer (Toyota, Honda)
3. Create Java Application that can increase the price of each package by $250, and retrieve a list of models and total price for each model for both manufacturers
(5 bonus points will be awarded for accomplishing steps for question 2 within the Java program)
4. create a list of assumptions made while developing the model, while creating the database and while writing the code.
Create a page describing your approach towards building this solution
Write down a couple of your challenges and good experiences you had during this project.
Take care to include appropriate comments in your Java code to explain your code.