better-cars.txt

group: auto_dealer_schema 

Model = {
	model_id:number, model_name:string, first_production_year:string
  	1,'XJS','1987'
	2,'XK120','1948'
	3,'Camaro','1966'
	4,'GT','2005'
	5,'Boss 302 Mustang','1969'
	6,'P1800','1961'
	7,'360 Modena','1987'
	8,'GT-R','2009'
	9,'Corvette','1953'
	10,'Spider','1966'
	11,'Carrera GT','2004'
}

Make = {
  make_id:number, make_name:string, country:string
  1,'Jaguar','China'
  2,'Chevrolet','USA'
  3,'Ford','USA'
  4,'Volvo','England'
  5,'Ferrari','Italy'
  6,'Nissan','Japan'
  7,'Alfa Romeo','France'
  8,'Porsche','England'
}

Color = {
  color_id:number, name:string, code:string
	1,'Sky Blue','#1869c5'
	2,'Bold Red','#b00007'
	3,'Fusion Fuchsia','#FF00FF'
	4,'Yodeling Yellow','#ffff00'
	5,'Gangrene Green','#008000'
}

Vehicle = {
  vehicle_id:number, fk_make_id:number, fk_model_id:number, year:string
	1,1,1, '1981'
	2,1,1, '1985'
	3,1,1, '1996'
	4,1,2, '1948'
	5,2,3, '1969'
	6,3,4, '2005'
	7,3,4, '2006'
	8,3,5, '1969'
	9,3,5, '1970'
	10,4,6,'1962'
	11,5,7,'1999'
	12,6,8,'2013'
	13,6,8,'2015'
	14,6,8,'2017'
	15,6,8,'2018'
	16,2,9,'1955'
	17,2,9,'1961'
	18,7,10,'1967'
	19,8,11,'2005'
	20,8,11,'2007'
}

Inventory = {
 inventory_id:number, fk_vehicle_id:number, fk_color_id:number, price:number
 1,1,1,9000
 2,2,2,8000
 3,2,1,9000
 4,3,1,10500
 5,3,2,8790
 6,3,4,8690
 7,4,1,9740
 8,4,2,8850
 9,5,3,9930
 10,6,4,8760
 11,7,1,9870
 12,7,2,8630
 13,8,3,9550
 14,9,2,10640
 15,10,4,11760
 16,11,5,8470
 17,12,2,7380
 18,12,3,8520
 19,13,4,9640
 20,14,2,7860
 21,15,5,8240
 22,16,4,9370
 23,16,2,8580
 24,17,3,7410
 25,18,4,8630
 26,18,2,7750
 27,19,5,8630
 28,20,1,9560
 29,20,2,10880
 30,20,4,11510
}

Incentive = {
 incentive_id:number, type:string, amount:number, conditions:string
 1,'dealer',600,'only if credit score > 700'
 2,'company',500,'only if credit score > 600'
}

Vehicle_Incentive = {
 fk_vehicle_id:number, fk_incentive_id:number, valid_till:string
 1,1,'2018-03-21'
 2,1,'2018-03-21'
 3,2,'2018-03-21'
 4,2,'2018-03-21'
 5,1,'2018-03-21'
 6,1,'2018-03-21'
 7,2,'2018-03-21'
 8,2,'2018-03-21'
 9,2,'2018-03-21'
 10,1,'2018-03-21'
 11,1,'2018-03-21'
 12,1,'2018-03-21'
 13,1,'2018-03-21'
 14,1,'2018-03-21'
 15,1,'2018-03-21'
 16,1,'2018-03-21'
 17,2,'2018-03-21'
 18,1,'2018-03-21'
 19,2,'2018-03-21'
 20,1,'2018-03-21'

}