Enter option ( dlmcaurx ) d ************************************************************ Total number of cars in database: 390 Total number of automakers: 34 Average MPG of American cars: 20.03 Average MPG of European cars: 27.60 Average MPG of Japanese cars: 30.48 ************************************************************ Enter option ( dlmcaurx ) l Usage: l makerName Enter option ( dlmcaurx ) l ford ************************************************************ Torino Galaxie 500 Maverick F250 Torino 500 Galaxie 500 Country Squire (sw) Mustang Pinto Runabout Galaxie 500 Gran Torino (sw) Pinto (sw) Gran Torino Ltd Maverick Country Pinto Pinto Gran Torino Gran Torino (sw) Maverick Ltd Mustang Ii Pinto Pinto Gran Torino Maverick Granada Ghia Pinto F108 Granada Thunderbird Mustang Ii 2+2 Fiesta Fairmont (auto) Fairmont (man) Futura Fairmont 4 Ltd Landau Country Squire (sw) Fairmont Escort 4w Escort 2h Granada Gl Fairmont Futura Granada L Mustang Gl Ranger ************************************************************ Enter option ( dlmcaurx ) m ************************************************************ List of all the makers in the database: Chevrolet Buick Plymouth Amc Ford Pontiac Dodge Toyota Datsun Volkswagen Peugeot Audi Saab Bmw Hi Mercury Opel Fiat Oldsmobile Chrysler Mazda Volvo Renault Toyouta Maxda Honda Chevroelt Capri Mercedes-benz Cadillac Subaru Mercedes Triumph Nissan ************************************************************ Enter option ( dlmcaurx ) c mpg,f,40 Usage: c field,relation,value Enter option ( dlmcaurx ) c mpg,g,a Usage: c field,relation,value Enter option ( dlmcaurx ) c mileage,g,40 Usage: c field,relation,value Enter option ( dlmcaurx ) c,mpg,g,40 Usage: c field,relation,value Enter option ( dlmcaurx ) c mpg,g,40 ************************************************************ Volkswagen Rabbit Custom Diesel 78, MPG: 43.1 Volkswagen Rabbit 80, MPG: 41.5 Mazda Glc 80, MPG: 46.6 Datsun 210 80, MPG: 40.8 Volkswagen Rabbit C (diesel) 80, MPG: 44.3 Volkswagen Dasher (diesel) 80, MPG: 43.4 Honda Civic 1500 Gl 80, MPG: 44.6 Volkswagen Pickup 82, MPG: 44.0 ************************************************************ Enter option ( dlmcaurx ) c power,l,60 ************************************************************ Volkswagen 1131 Deluxe Sedan 70, Power: 46 Volkswagen Type 3 72, Power: 54 Volkswagen Super Beetle 73, Power: 46 Fiat 128 73, Power: 49 Toyota Corona 74, Power: 52 Honda Civic Cvcc 75, Power: 53 Chevrolet Chevette 76, Power: 52 Honda Civic 76, Power: 53 Renault 5 Gtl 77, Power: 58 Volkswagen Rabbit Custom Diesel 78, Power: 48 Mazda Glc Deluxe 78, Power: 52 Volkswagen Rabbit C (diesel) 80, Power: 48 Volkswagen Dasher (diesel) 80, Power: 48 Toyota Starlet 81, Power: 58 Volkswagen Pickup 82, Power: 52 ************************************************************ Enter option ( dlmcaurx ) c year,e,82 ************************************************************ Chevrolet Cavalier 82, Year: 82 Chevrolet Cavalier Wagon 82, Year: 82 Chevrolet Cavalier 2-door 82, Year: 82 Pontiac J2000 Se Hatchback 82, Year: 82 Dodge Aries Se 82, Year: 82 Pontiac Phoenix 82, Year: 82 Ford Fairmont Futura 82, Year: 82 Volkswagen Rabbit L 82, Year: 82 Mazda Glc Custom L 82, Year: 82 Mazda Glc Custom 82, Year: 82 Plymouth Horizon Miser 82, Year: 82 Mercury Lynx L 82, Year: 82 Nissan Stanza Xe 82, Year: 82 Honda Accord 82, Year: 82 Toyota Corolla 82, Year: 82 Honda Civic 82, Year: 82 Honda Civic (auto) 82, Year: 82 Datsun 310 Gx 82, Year: 82 Buick Century Limited 82, Year: 82 Oldsmobile Cutlass Ciera (diesel) 82, Year: 82 Chrysler Lebaron Medallion 82, Year: 82 Ford Granada L 82, Year: 82 Toyota Celica Gt 82, Year: 82 Dodge Charger 2.2 82, Year: 82 Chevrolet Camaro 82, Year: 82 Ford Mustang Gl 82, Year: 82 Volkswagen Pickup 82, Year: 82 Dodge Rampage 82, Year: 82 Ford Ranger 82, Year: 82 Chevrolet S-10 82, Year: 82 ************************************************************ Enter option ( dlmcaurx ) c region,e,3 ************************************************************ Toyota Corona Mark Ii 70, From: Japan Datsun Pl510 70, From: Japan Datsun Pl510 71, From: Japan Toyota Corona 71, From: Japan Toyota Corolla 1200 71, From: Japan Datsun 1200 71, From: Japan Toyota Corona Hardtop 72, From: Japan Mazda Rx2 Coupe 72, From: Japan Datsun 510 (sw) 72, From: Japan Toyouta Corona Mark Ii (sw) 72, From: Japan Toyota Corolla 1600 (sw) 72, From: Japan Toyota Carina 73, From: Japan Datsun 610 73, From: Japan Maxda Rx3 73, From: Japan Toyota Mark Ii 73, From: Japan Datsun B210 74, From: Japan Toyota Corolla 1200 74, From: Japan Toyota Corona 74, From: Japan Datsun 710 74, From: Japan Honda Civic 74, From: Japan Toyota Corolla 75, From: Japan Toyota Corona 75, From: Japan Datsun 710 75, From: Japan Honda Civic Cvcc 75, From: Japan Honda Civic 76, From: Japan Datsun B-210 76, From: Japan Toyota Corolla 76, From: Japan Toyota Mark Ii 76, From: Japan Honda Accord Cvcc 77, From: Japan Datsun F-10 Hatchback 77, From: Japan Toyota Corolla Liftback 77, From: Japan Subaru Dl 77, From: Japan Datsun 810 77, From: Japan Mazda Rx-4 77, From: Japan Mazda Glc Deluxe 78, From: Japan Datsun B210 Gx 78, From: Japan Honda Civic Cvcc 78, From: Japan Toyota Corona 78, From: Japan Datsun 510 78, From: Japan Toyota Celica Gt Liftback 78, From: Japan Datsun 200-sx 78, From: Japan Honda Accord Lx 78, From: Japan Mazda Glc Deluxe 79, From: Japan Datsun 210 79, From: Japan Toyota Corolla Tercel 80, From: Japan Datsun 310 80, From: Japan Toyota Corona Liftback 80, From: Japan Mazda 626 80, From: Japan Datsun 510 Hatchback 80, From: Japan Toyota Corolla 80, From: Japan Mazda Glc 80, From: Japan Datsun 210 80, From: Japan Honda Civic 1500 Gl 80, From: Japan Subaru Dl 80, From: Japan Datsun 280-zx 80, From: Japan Mazda Rx-7 Gs 80, From: Japan Honda Accord 80, From: Japan Toyota Starlet 81, From: Japan Honda Civic 1300 81, From: Japan Datsun 210 Mpg 81, From: Japan Toyota Tercel 81, From: Japan Mazda Glc 4 81, From: Japan Honda Prelude 81, From: Japan Toyota Corolla 81, From: Japan Datsun 200sx 81, From: Japan Mazda 626 81, From: Japan Toyota Cressida 81, From: Japan Datsun 810 Maxima 81, From: Japan Mazda Glc Custom L 82, From: Japan Mazda Glc Custom 82, From: Japan Nissan Stanza Xe 82, From: Japan Honda Accord 82, From: Japan Toyota Corolla 82, From: Japan Honda Civic 82, From: Japan Honda Civic (auto) 82, From: Japan Datsun 310 Gx 82, From: Japan Toyota Celica Gt 82, From: Japan ************************************************************ Enter option ( dlmcaurx ) c cylinders,l,4 ************************************************************ Mazda Rx2 Coupe 72, # of Cylinders: 3 Maxda Rx3 73, # of Cylinders: 3 Mazda Rx-4 77, # of Cylinders: 3 Mazda Rx-7 Gs 80, # of Cylinders: 3 ************************************************************ Enter option ( dlmcaurx ) a Usage: a makerName,carName,mpg,cylinders,power,year,region Enter option ( dlmcaurx ) a Batman,Batmobile,high,16,900,14,1 java.lang.IllegalArgumentException at CarDBMain.main(CarDBMain.java:137) Enter option ( dlmcaurx ) a Batman,Batmobile,20,a,900,14,1 java.lang.IllegalArgumentException at CarDBMain.main(CarDBMain.java:137) Enter option ( dlmcaurx ) a Batman,Batmobile,20,16,900,14,1 ************************************************************ Added successfully ************************************************************ Enter option ( dlmcaurx ) u Usage: u name,year,field,newValue Enter option ( dlmcaurx ) u batmobile,14,horsepower,999 Usage: u name,year,field,newValue Enter option ( dlmcaurx ) u batmobile,14,power,abcd Usage: u name,year,field,newValue Enter option ( dlmcaurx ) u batmobile,14,power,999 ************************************************************ Successfully updated ************************************************************ Enter option ( dlmcaurx ) r Usage: r name,year Enter option ( dlmcaurx ) r batmobile,year java.lang.IllegalArgumentException at CarDBMain.main(CarDBMain.java:72) Enter option ( dlmcaurx ) r batmobile,14 ************************************************************ Car removed ************************************************************ Enter option ( dlmcaurx ) x Exit