Create the database using the data model in mysql write a


Assignment

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. Create the database using the data model in mySQL

Add data for at least two minivan models for each manufacturer (Toyota, Honda).

2. Write a 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.

Accomplish steps for question 2 within the Java program.

Promp the user to enter an amount they want to spend on accessories, and your program recommends the package/accessories.

Attachment:- Java-Assignment.rar

Solution Preview :

Prepared by a verified Expert
JAVA Programming: Create the database using the data model in mysql write a
Reference No:- TGS02390430

Now Priced at $60 (50% Discount)

Recommended (98%)

Rated (4.3/5)