· 8 years ago · Apr 16, 2018, 06:44 AM
1Enunciado:
2
3fabrica de coches
4necesitamos conocer la composicion de los vehiculos que produce nuestra fabrica,
5cada vehiculo usará una serie determinada de piezas,
6a su vez las piezas pueden ser usadas en varios modelos
7cada vehiculo tendrá un número de serie,
8igualmente para algunas piezas
9relacionar los vehiculos con las piezas montadas mediante sus numeros de serie
10(que si, son cuatro lineas pero chiquicientas tablas -_-)
11
12
13----
14
15Diccionario de datos:
16
17MODELO(idModelo, gama);
18COLOR(idColor, nombreColor);
19VEHICULO(numSerie, fechaFabricacion);
20RUEDAS(nsRueda, numSerie, marca, nombre, dimension, fechaMontaje);
21MOTOR(nsMotor, nsVehiculo, cv, cilindrada, fechaMontaje);
22ASIENTO(nsAsiento, numSerie, nombre, tapiceria, fechaMontaje);
23PIEZASGENERALES(idPieza, nombre);
24VEPO(nsVehiculo, idPieza, cantidad, fechaMontaje)
25
26---------o----------
27
28
29 DROP DATABASE IF EXISTS fabrica;
30
31CREATE DATABASE fabrica;
32
33USE fabrica;
34
35CREATE TABLE modelo(
36idModelo int(5) AUTO_INCREMENT not null,
37gama varchar(45) not null,
38nombreModelo varchar(45) not null,
39CONSTRAINT PK_modelo PRIMARY KEY(idModelo)
40);
41
42CREATE TABLE color(
43idColor int(5) AUTO_INCREMENT not null,
44nombreColor varchar(45) not null,
45CONSTRAINT PK_color PRIMARY KEY(idColor)
46);
47
48CREATE TABLE vehiculo(
49 numSerie int(5) AUTO_INCREMENT not null,
50 fechaFabricacion datetime not null,
51 idModelo int(5) not null,
52 idColor int(5) not null,
53 CONSTRAINT PK_vehiculo PRIMARY KEY(numSerie),
54 CONSTRAINT FK_modelo FOREIGN KEY(idModelo) REFERENCES modelo(idModelo),
55 CONSTRAINT FK_color FOREIGN KEY(idColor) REFERENCES color(idColor)
56 );
57
58CREATE TABLE rueda(
59 nsRueda int(5) AUTO_INCREMENT not null,
60 numSerie int(5) not null,
61 marca varchar(45) not null,
62 nombre varchar(45) not null,
63 dimension varchar(45) not null,
64 fechaFabricacion datetime not null,
65 fechaMontaje datetime not null,
66 CONSTRAINT PK_rueda PRIMARY KEY(nsRueda),
67 CONSTRAINT FK_rueda_x_vehiculo FOREIGN KEY(numSerie) REFERENCES vehiculo(numSerie)
68);
69
70CREATE TABLE motor(
71 nsMotor int(5) AUTO_INCREMENT not null,
72 numSerie int(5) not null,
73 cv int(4) not null,
74 cilindrada int(5) not null,
75 fechaFabricacion datetime not null,
76 fechaMontaje datetime not null,
77 CONSTRAINT PK_motor PRIMARY KEY(nsMotor),
78 CONSTRAINT FK_motor_x_vehiculo FOREIGN KEY(numSerie) REFERENCES vehiculo(numSerie)
79);
80
81CREATE TABLE asiento(
82 nsAsiento int(5) AUTO_INCREMENT not null,
83 numSerie int(5) not null,
84 posicion varchar(45) not null,
85 tapiceria varchar(45) not null,
86 fechaMontaje datetime not null,
87CONSTRAINT PK_asiento PRIMARY KEY(nsAsiento),
88 CONSTRAINT FK_asiento_x_vehiculo FOREIGN KEY(numSerie) REFERENCES vehiculo(numSerie)
89);
90
91CREATE TABLE piezasgenerales(
92 idPiezaGeneral int(5) AUTO_INCREMENT not null,
93 nombre varchar(45),
94 CONSTRAINT PK_piezasgenerales PRIMARY KEY(idPiezaGeneral)
95 );
96
97CREATE TABLE VEPG(
98 nsVehiculo int(5) not null,
99 idPiezaGeneral int(5) not null,
100 cantidad int(5) not null,
101 fechaMontaje datetime,
102 CONSTRAINT PK_vepg PRIMARY KEY(nsVehiculo, idPiezaGeneral),
103 CONSTRAINT FK_vepg_x_vehiculo FOREIGN KEY(nsVehiculo) REFERENCES vehiculo(numSerie),
104 CONSTRAINT FK_vepg_x_piezasgenerales FOREIGN KEY(idPiezaGeneral) REFERENCES piezasgenerales(idPiezaGeneral)
105);
106
107
108INSERT INTO modelo (gama, nombreModelo) VALUES ('media', 'A3'),
109('baja', 'A4'),
110('media', 'A6'),
111('alta', 'TT'),
112('alta', 'Q7');
113
114INSERT INTO color (nombreColor) VALUES ('Azul Scuba metalizado');
115INSERT INTO color (nombreColor) VALUES ('Blanco glaciar metalizado');
116INSERT INTO color (nombreColor) VALUES ('Negro Phantom efecto perla');
117INSERT INTO color (nombreColor) VALUES ('Rojo volcán metalizado');
118INSERT INTO color (nombreColor) VALUES ('Gris Daytona efecto perla');
119INSERT INTO color (nombreColor) VALUES ('Negro brillante');
120INSERT INTO color (nombreColor) VALUES ('Blanco Ibis');
121INSERT INTO color (nombreColor) VALUES ('Azul Aviator metalizado');
122
123INSERT INTO vehiculo (fechaFabricacion, idModelo, idColor) VALUES ('2007-7-12 21:59:36', 1, 1),
124('2007-7-13 9:23:58', 2, 3),
125('2007-7-13 12:11:32', 3, 8),
126('2007-7-13 16:15:12', 4, 4),
127('2007-7-13 19:48:23', 5, 2),
128('2008-7-12 21:59:36', 1, 6),
129('2008-7-13 9:23:58', 2, 5),
130('2008-7-13 12:11:32', 3, 7),
131('2008-7-13 16:15:12', 4, 5),
132('2008-7-13 19:48:23', 5, 3),
133('2009-7-12 21:59:36', 1, 3),
134('2009-7-13 9:23:58', 2, 4),
135('2009-7-13 12:11:32', 3, 7),
136('2009-7-13 16:15:12', 4, 8),
137('2009-7-13 19:48:23', 5, 2),
138('2010-7-12 21:59:36', 1, 4),
139('2010-7-13 9:23:58', 2, 2),
140('2010-7-13 12:11:32', 3, 4),
141('2010-7-13 16:15:12', 4, 6),
142('2010-7-13 19:48:23', 5, 1),
143('2011-7-12 21:59:36', 1, 4),
144('2011-7-13 9:23:58', 2, 5),
145('2011-7-13 12:11:32', 3, 2),
146('2011-7-13 16:15:12', 4, 8),
147('2011-7-13 19:48:23', 5, 4);
148
149INSERT INTO rueda (numSerie, marca, nombre, dimension, fechaFabricacion, fechaMontaje) VALUES
150(1, 'Pirelli', 'P6000 Powergy', '225/45 R17', '2001-2-23 18:50:11', '2007-1-10 07:15:59'),
151(1, 'Pirelli', 'P6000 Powergy', '225/45 R17', '2001-2-23 18:52:39', '2007-1-10 07:15:59'),
152(1, 'Pirelli', 'P6000 Powergy', '225/45 R17', '2001-2-23 18:54:56', '2007-1-10 07:15:59'),
153(1, 'Pirelli', 'P6000 Powergy', '225/45 R17', '2001-2-23 18:57:14', '2007-1-10 07:15:59'),
154(1, 'Pirelli', 'P6000 Powergy', '225/45 R17', '2001-2-23 18:57:14', '2007-1-10 07:15:59'),
155(2, 'Bridgestone', 'Potenza S001', '225/45 R17', '2007-10-17 08:40:23', '2007-11-17 10:54:23'),
156(2, 'Bridgestone', 'Potenza S001', '225/45 R17', '2007-10-17 08:40:23', '2007-11-17 10:54:23'),
157(2, 'Bridgestone', 'Potenza S001', '225/45 R17', '2007-10-17 08:40:23', '2007-11-17 10:54:23'),
158(2, 'Bridgestone', 'Potenza S001', '225/45 R17', '2007-10-17 08:40:23', '2007-11-17 10:54:23'),
159(2, 'Bridgestone', 'Potenza S001', '225/45 R17', '2007-10-17 08:40:23', '2007-11-17 10:54:23'),
160(3, 'Continental', 'ContiSportContact 3', '225/45 R17', '2008-5-12 07:45:16', '2008-1-1 13:02:43'),
161(3, 'Continental', 'ContiSportContact 3', '225/45 R17', '2008-5-12 07:45:16', '2008-1-1 13:02:43'),
162(3, 'Continental', 'ContiSportContact 3', '225/45 R17', '2008-5-12 07:45:16', '2008-1-1 13:02:43'),
163(3, 'Continental', 'ContiSportContact 3', '225/45 R17', '2008-5-12 07:45:16', '2008-1-1 13:02:43'),
164(3, 'Continental', 'ContiSportContact 3', '225/45 R17', '2008-5-12 07:45:16', '2008-1-1 13:02:43'),
165(4, 'Dunlop', 'SPORT MAXX TT', '225/45 R17', '2008-05-13 08:02:10', '2008-01-03 10:10:10'),
166(4, 'Dunlop', 'SPORT MAXX TT', '225/45 R17', '2008-05-13 08:02:10', '2008-01-03 10:10:10'),
167(4, 'Dunlop', 'SPORT MAXX TT', '225/45 R17', '2008-05-13 08:02:10', '2008-01-03 10:10:10'),
168(4, 'Dunlop', 'SPORT MAXX TT', '225/45 R17', '2008-05-13 08:02:10', '2008-01-03 10:10:10'),
169(4, 'Dunlop', 'SPORT MAXX TT', '225/45 R17', '2008-05-13 08:02:10', '2008-01-03 10:10:10'),
170(5, 'Goodyear', 'OptiGrid', '225/45 R17', '2008-06-06 10:09:17', '2008-06-04 10:58:12'),
171(5, 'Goodyear', 'OptiGrid', '225/45 R17', '2008-06-06 10:09:17', '2008-06-04 10:58:12'),
172(5, 'Goodyear', 'OptiGrid', '225/45 R17', '2008-06-06 10:09:17', '2008-06-04 10:58:12'),
173(5, 'Goodyear', 'OptiGrid', '225/45 R17', '2008-06-06 10:09:17', '2008-06-04 10:58:12'),
174(5, 'Goodyear', 'OptiGrid', '225/45 R17', '2008-06-06 10:09:17', '2008-06-04 10:58:12'),
175(6, 'Minerva', 'Stud winter', '225/45 R17', '2008-06-06 10:12:16', '2008-06-05 11:00:12'),
176(6, 'Minerva', 'Stud winter', '225/45 R17', '2008-06-06 10:12:16', '2008-06-05 11:00:12'),
177(6, 'Minerva', 'Stud winter', '225/45 R17', '2008-06-06 10:12:16', '2008-06-05 11:00:12'),
178(6, 'Minerva', 'Stud winter', '225/45 R17', '2008-06-06 10:12:16', '2008-06-05 11:00:12'),
179(6, 'Minerva', 'Stud winter', '225/45 R17', '2008-06-06 10:12:16', '2008-06-05 11:00:12'),
180(7, 'Michelin', 'Primacy HP3000', '225/45 R17', '2008-10-10 10:10:01', '2008-10-10 12:00:04'),
181(7, 'Michelin', 'Primacy HP3000', '225/45 R17', '2008-10-10 10:10:01', '2008-10-10 12:00:04'),
182(7, 'Michelin', 'Primacy HP3000', '225/45 R17', '2008-10-10 10:10:01', '2008-10-10 12:00:04'),
183(7, 'Michelin', 'Primacy HP3000', '225/45 R17', '2008-10-10 10:10:01', '2008-10-10 12:00:04'),
184(7, 'Michelin', 'Primacy HP3000', '225/45 R17', '2008-10-10 10:10:01', '2008-10-10 12:00:04'),
185(8, 'Sava', 'Exact', '225/45 R17', '2008-10-10 10:10:01', '2008-10-10 12:00:04'),
186(8, 'Sava', 'Exact', '225/45 R17', '2008-10-10 10:10:01', '2008-10-10 12:00:04'),
187(8, 'Sava', 'Exact', '225/45 R17', '2008-10-10 10:10:01', '2008-10-10 12:00:04'),
188(8, 'Sava', 'Exact', '225/45 R17', '2008-10-10 10:10:01', '2008-10-10 12:00:04'),
189(8, 'Sava', 'Exact', '225/45 R17', '2008-10-10 10:10:01', '2008-10-10 12:00:04'),
190(9, 'Sumitomo', 'Modelo 1su', '225/45 R17', '2008-11-20 09:01:34', '2008-11-20 11:00:04'),
191(9, 'Sumitomo', 'Modelo 1su', '225/45 R17', '2008-11-20 09:01:34', '2008-11-20 11:00:04'),
192(9, 'Sumitomo', 'Modelo 1su', '225/45 R17', '2008-11-20 09:01:34', '2008-11-20 11:00:04'),
193(9, 'Sumitomo', 'Modelo 1su', '225/45 R17', '2008-11-20 09:01:34', '2008-11-20 11:00:04'),
194(9, 'Sumitomo', 'Modelo 1su', '225/45 R17', '2008-11-20 09:01:34', '2008-11-20 11:00:04'),
195(10, 'Toyo Tires', 'Proxes ST', '225/45 R17', '2009-01-7 08:02:14', '2009-01-07 13:36:40'),
196(10, 'Toyo Tires', 'Proxes ST', '225/45 R17', '2009-01-7 08:02:14', '2009-01-07 13:36:40'),
197(10, 'Toyo Tires', 'Proxes ST', '225/45 R17', '2009-01-7 08:02:14', '2009-01-07 13:36:40'),
198(10, 'Toyo Tires', 'Proxes ST', '225/45 R17', '2009-01-7 08:02:14', '2009-01-07 13:36:40'),
199(10, 'Toyo Tires', 'Proxes ST', '225/45 R17', '2009-01-7 08:02:14', '2009-01-07 13:36:40'),
200(11, 'Yokohama', 'Geolandar plus II', '225/45 R17', '2009-01-08 19:49:09', '2009-01-08 21:00:50'),
201(11, 'Yokohama', 'Geolandar plus II', '225/45 R17', '2009-01-08 19:49:09', '2009-01-08 21:00:50'),
202(11, 'Yokohama', 'Geolandar plus II', '225/45 R17', '2009-01-08 19:49:09', '2009-01-08 21:00:50'),
203(11, 'Yokohama', 'Geolandar plus II', '225/45 R17', '2009-01-08 19:49:09', '2009-01-08 21:00:50'),
204(11, 'Yokohama', 'Geolandar plus II', '225/45 R17', '2009-01-08 19:49:09', '2009-01-08 21:00:50'),
205(12, 'Wanli', 'S1086 winter challenge environ', '225/45 R17', '2009-02-14 10:32:47', '2009-03-02 3:42:27'),
206(12, 'Wanli', 'S1086 winter challenge environ', '225/45 R17', '2009-02-14 10:32:47', '2009-03-02 3:42:27'),
207(12, 'Wanli', 'S1086 winter challenge environ', '225/45 R17', '2009-02-14 10:32:47', '2009-03-02 3:42:27'),
208(12, 'Wanli', 'S1086 winter challenge environ', '225/45 R17', '2009-02-14 10:32:47', '2009-03-02 3:42:27'),
209(12, 'Wanli', 'S1086 winter challenge environ', '225/45 R17', '2009-02-14 10:32:47', '2009-03-02 3:42:27'),
210(13, 'Nokian', 'Hakkapeliitta C Cargo', '225/45 R17', '2009-03-01 10:09:25', '2009-03-05 08:06:57'),
211(13, 'Nokian', 'Hakkapeliitta C Cargo', '225/45 R17', '2009-03-01 10:09:25', '2009-03-05 08:06:57'),
212(13, 'Nokian', 'Hakkapeliitta C Cargo', '225/45 R17', '2009-03-01 10:09:25', '2009-03-05 08:06:57'),
213(13, 'Nokian', 'Hakkapeliitta C Cargo', '225/45 R17', '2009-03-01 10:09:25', '2009-03-05 08:06:57'),
214(13, 'Nokian', 'Hakkapeliitta C Cargo', '225/45 R17', '2009-03-01 10:09:25', '2009-03-05 08:06:57'),
215(14, 'Pirelli', 'P7000 Powergy', '225/45 R17', '2009-03-10 09:17:29', '2009-03-10 15:40:31'),
216(14, 'Pirelli', 'P7000 Powergy', '225/45 R17', '2009-03-10 09:17:29', '2009-03-10 15:40:31'),
217(14, 'Pirelli', 'P7000 Powergy', '225/45 R17', '2009-03-10 09:17:29', '2009-03-10 15:40:31'),
218(14, 'Pirelli', 'P7000 Powergy', '225/45 R17', '2009-03-10 09:17:29', '2009-03-10 15:40:31'),
219(14, 'Pirelli', 'P7000 Powergy', '225/45 R17', '2009-03-10 09:17:29', '2009-03-10 15:40:31'),
220(15, 'Bridgestone', 'Potenza S002', '225/45 R17', '2009-04-01 09:29:19', '2009-04-01 13:49:10'),
221(15, 'Bridgestone', 'Potenza S002', '225/45 R17', '2009-04-01 09:29:19', '2009-04-01 13:49:10'),
222(15, 'Bridgestone', 'Potenza S002', '225/45 R17', '2009-04-01 09:29:19', '2009-04-01 13:49:10'),
223(15, 'Bridgestone', 'Potenza S002', '225/45 R17', '2009-04-01 09:29:19', '2009-04-01 13:49:10'),
224(15, 'Bridgestone', 'Potenza S002', '225/45 R17', '2009-04-01 09:29:19', '2009-04-01 13:49:10'),
225(16, 'Continental', 'ContiSportContact 4', '225/45 R17', '2009-04-15 11:37:21', '2009-05-01 9:24:32'),
226(16, 'Continental', 'ContiSportContact 4', '225/45 R17', '2009-04-15 11:37:21', '2009-05-01 9:24:32'),
227(16, 'Continental', 'ContiSportContact 4', '225/45 R17', '2009-04-15 11:37:21', '2009-05-01 9:24:32'),
228(16, 'Continental', 'ContiSportContact 4', '225/45 R17', '2009-04-15 11:37:21', '2009-05-01 9:24:32'),
229(16, 'Continental', 'ContiSportContact 4', '225/45 R17', '2009-04-15 11:37:21', '2009-05-01 9:24:32'),
230(17, 'Dunlop', 'SPORT MAXX TX', '225/45 R17', '2009-05-01 10:23:12', '2009-05-10 13:02:25'),
231(17, 'Dunlop', 'SPORT MAXX TX', '225/45 R17', '2009-05-01 10:23:12', '2009-05-10 13:02:25'),
232(17, 'Dunlop', 'SPORT MAXX TX', '225/45 R17', '2009-05-01 10:23:12', '2009-05-10 13:02:25'),
233(17, 'Dunlop', 'SPORT MAXX TX', '225/45 R17', '2009-05-01 10:23:12', '2009-05-10 13:02:25'),
234(17, 'Dunlop', 'SPORT MAXX TX', '225/45 R17', '2009-05-01 10:23:12', '2009-05-10 13:02:25'),
235(18, 'Goodyear', 'OptiGrid2', '225/45 R17', '2009-06-01 13:59:22', '2009-06-1 5:39:12'),
236(18, 'Goodyear', 'OptiGrid2', '225/45 R17', '2009-06-01 13:59:22', '2009-06-1 5:39:12'),
237(18, 'Goodyear', 'OptiGrid2', '225/45 R17', '2009-06-01 13:59:22', '2009-06-1 5:39:12'),
238(18, 'Goodyear', 'OptiGrid2', '225/45 R17', '2009-06-01 13:59:22', '2009-06-1 5:39:12'),
239(18, 'Goodyear', 'OptiGrid2', '225/45 R17', '2009-06-01 13:59:22', '2009-06-1 5:39:12'),
240(19, 'Minerva', 'Stud Summer', '225/45 R17', '2009-06-10 09:11:02', '2009-06-10 10:23:40'),
241(19, 'Minerva', 'Stud Summer', '225/45 R17', '2009-06-10 09:11:02', '2009-06-10 10:23:40'),
242(19, 'Minerva', 'Stud Summer', '225/45 R17', '2009-06-10 09:11:02', '2009-06-10 10:23:40'),
243(19, 'Minerva', 'Stud Summer', '225/45 R17', '2009-06-10 09:11:02', '2009-06-10 10:23:40'),
244(19, 'Minerva', 'Stud Summer', '225/45 R17', '2009-06-10 09:11:02', '2009-06-10 10:23:40'),
245(20, 'Michelin', 'Primacy HP3500', '225/45 R17', '2009-06-11 14:23:09', '2009-06-11 17:01:37'),
246(20, 'Michelin', 'Primacy HP3500', '225/45 R17', '2009-06-11 14:23:09', '2009-06-11 17:01:37'),
247(20, 'Michelin', 'Primacy HP3500', '225/45 R17', '2009-06-11 14:23:09', '2009-06-11 17:01:37'),
248(20, 'Michelin', 'Primacy HP3500', '225/45 R17', '2009-06-11 14:23:09', '2009-06-11 17:01:37'),
249(20, 'Michelin', 'Primacy HP3500', '225/45 R17', '2009-06-11 14:23:09', '2009-06-11 17:01:37'),
250(21, 'Sava', 'Inexact', '225/45 R17', '2009-06-23 09:10:08', '2009-06-23 10:12:08'),
251(21, 'Sava', 'Inexact', '225/45 R17', '2009-06-23 09:10:08', '2009-06-23 10:12:08'),
252(21, 'Sava', 'Inexact', '225/45 R17', '2009-06-23 09:10:08', '2009-06-23 10:12:08'),
253(21, 'Sava', 'Inexact', '225/45 R17', '2009-06-23 09:10:08', '2009-06-23 10:12:08'),
254(21, 'Sava', 'Inexact', '225/45 R17', '2009-06-23 09:10:08', '2009-06-23 10:12:08'),
255(22, 'Sumitomo', 'Modelo 2su', '225/45 R17', '2009-08-30 18:43:33', '2010-3-23 17:33:24'),
256(22, 'Sumitomo', 'Modelo 2su', '225/45 R17', '2009-08-30 18:43:33', '2010-3-23 17:33:24'),
257(22, 'Sumitomo', 'Modelo 2su', '225/45 R17', '2009-08-30 18:43:33', '2010-3-23 17:33:24'),
258(22, 'Sumitomo', 'Modelo 2su', '225/45 R17', '2009-08-30 18:43:33', '2010-3-23 17:33:24'),
259(22, 'Sumitomo', 'Modelo 2su', '225/45 R17', '2009-08-30 18:43:33', '2010-3-23 17:33:24'),
260(23, 'Toyo Tires', 'Proxes II', '225/45 R17', '2009-06-10 11:09:23', '2009-06-12 12:09:30'),
261(23, 'Toyo Tires', 'Proxes II', '225/45 R17', '2009-06-10 11:09:23', '2009-06-12 12:09:30'),
262(23, 'Toyo Tires', 'Proxes II', '225/45 R17', '2009-06-10 11:09:23', '2009-06-12 12:09:30'),
263(23, 'Toyo Tires', 'Proxes II', '225/45 R17', '2009-06-10 11:09:23', '2009-06-12 12:09:30'),
264(23, 'Toyo Tires', 'Proxes II', '225/45 R17', '2009-06-10 11:09:23', '2009-06-12 12:09:30'),
265(24, 'Yokohama', 'Geolandar plus III', '225/45 R17', '2009-06-11 11:09:23', '2009-06-11 12:05:20'),
266(24, 'Yokohama', 'Geolandar plus III', '225/45 R17', '2009-06-11 11:09:23', '2009-06-11 12:05:20'),
267(24, 'Yokohama', 'Geolandar plus III', '225/45 R17', '2009-06-11 11:09:23', '2009-06-11 12:05:20'),
268(24, 'Yokohama', 'Geolandar plus III', '225/45 R17', '2009-06-11 11:09:23', '2009-06-11 12:05:20'),
269(24, 'Yokohama', 'Geolandar plus III', '225/45 R17', '2009-06-11 11:09:23', '2009-06-11 12:05:20'),
270(25, 'Wanli', 'S1086 Summer Challenge environ', '225/45 R17', '2009-07-01 10:08:38', '2009-07-01 16:15:16'),
271(25, 'Wanli', 'S1086 Summer Challenge environ', '225/45 R17', '2009-07-01 10:08:38', '2009-07-01 16:15:16'),
272(25, 'Wanli', 'S1086 Summer Challenge environ', '225/45 R17', '2009-07-01 10:08:38', '2009-07-01 16:15:16'),
273(25, 'Wanli', 'S1086 Summer Challenge environ', '225/45 R17', '2009-07-01 10:08:38', '2009-07-01 16:15:16'),
274(25, 'Wanli', 'S1086 Summer Challenge environ', '225/45 R17', '2009-07-01 10:08:38', '2009-07-01 16:15:16');
275
276INSERT INTO motor (numSerie, cv, cilindrada, fechaFabricacion, fechaMontaje) VALUES
277(1, 160, 1100, '2009-06-10 11:09:23', '2009-06-12 12:09:30'),
278(2, 160, 1400, '2009-06-10 09:11:02', '2009-06-10 10:23:40'),
279(3, 211, 1800, '2009-07-01 10:08:38', '2009-07-01 16:15:16'),
280(4, 211, 1850, '2009-06-01 13:59:22', '2009-06-1 5:39:12'),
281(5, 211, 2000, '2009-03-10 09:17:29', '2009-03-10 15:40:31'),
282(6, 170, 1500, '2007-7-13 9:23:58', ‘2007-7-14 10:23:58’),
283(7, 170, 2100, '2001-2-23 18:57:14', '2007-1-10 07:15:59'),
284(8, 204, 2500, '2009-03-10 09:17:29', '2009-03-10 15:40:31'),
285(9, 245, 3000, '2009-08-30 18:43:33', '2010-3-23 17:33:24'),
286(10, 245, 3100, '2009-05-01 10:23:12', '2009-05-10 13:02:25'),
287(11, 204, 2800, '2009-06-11 14:23:09', '2009-06-11 17:01:37'),
288(12, 204, 2750, '2009-06-11 11:09:23', '2009-06-11 12:05:20'),
289(13, 245, , '2009-07-01 10:08:38', '2009-07-01 16:15:16'),
290(14, 245, , '2009-02-14 10:32:47', '2009-03-02 3:42:27'),
291(15, 204, , '2001-2-23 18:57:14', '2007-1-10 07:15:59'),
292(16, 340, 6000, '2008-5-12 07:45:16', '2008-1-1 13:02:43'),
293(17, 340, 5500, '2008-10-10 10:10:01', '2008-10-10 12:00:04'),
294(18, 245, , '2009-06-23 09:10:08', '2009-06-23 10:12:08'),
295(19, 245, , '2009-06-01 13:52:22', '2009-06-1 7:39:12'),
296(20, 245, , '2001-2-02 18:57:14', '2007-2-10 07:15:59'),
297(21, 105, , '2008-7-12 07:45:16', '2008-9-9 13:02:43'),
298(22, 105, , '2009-10-10 09:17:29', '2009-10-10 15:40:31'),
299(23, 140, , '2009-03-24 09:17:37', '2009-03-24 15:54:31'),
300(24, 170, , '2008-7-12 21:59:36', '2008-7-12 22:15:16'),
301(25, 200, , '2008-9-02 11:52:10', '2008-9-02 09:12:16');
302
303INSERT INTO asiento (numSerie, posicion, tapiceria, fechaMontaje) VALUES
304(1, 'delante izquierda', 'Piel', '2007-01-12 23:15:09'),
305(1, 'delante derecha', 'Piel', ‘2007-02-21 15:15:15’),
306(1, 'detras', 'Piel', '2007-01-12 19:30:14'),
307(2, 'delante izquierda', 'Nappa', '2007-7-7 7:7:7'),
308(2, 'delante derecha', 'Nappa', '2007-02-23 20:48:11'),
309(2, 'detras', 'Nappa', '2007-02-23 21:28:14'),
310(3, 'delante izquierda', 'Polipiel', '2008-01-12 12:24:09'),
311(3, 'delante derecha', 'Polipiel', '2008-01-24 13:12:05'),
312(3, 'detras', 'Polipiel', '2008-02-01 08-7-01'),
313(4, 'delante izquierda', 'Bipiel', '2008-02-09 14:32:19'2007-6-),
314(4, 'delante derecha', 'Bipiel', '2008-02-13 20:25:29'),
315(4, 'detras', 'Bipiel', '2008-02-28 14:25:36'),
316(5, 'delante izquierda', 'Cuero', ''),
317(5, 'delante derecha', 'Cuero', ''),
318(5, 'detras', 'Cuero', ''),
319(6, 'delante izquierda', 'Tela', ''),
320(6, 'delante derecha', 'Tela', ''),
321(6, 'detras', 'Tela', ''),
322(7, 'delante izquierda', 'Piel', ''),
323(7, 'delante derecha', 'Piel', ''),
324(7, 'detras', 'Piel', ''),
325(8, 'delante izquierda', 'Piel', ''),
326(8, 'delante derecha', 'Piel', ''),
327(8, 'detras', 'Piel', ''),
328(9, 'delante izquierda', 'Nappa', ''),
329(9, 'delante derecha', 'Nappa', ''),
330(9, 'detras', 'Nappa', ''),
331(10, 'delante izquierda', 'Tela', ''),
332(10, 'delante derecha', 'Tela', ''),
333(10, 'detras', 'Tela', ''),
334(11, 'delante izquierda', 'Bipiel', ''),
335(11, 'delante derecha', 'Bipiel', ''),
336(11, 'detras', 'Bipiel', ''),
337(12, 'delante izquierda', 'Polipiel', ''),
338(12, 'delante derecha', 'Polipiel', ''),
339(12, 'detras', 'Polipiel', ''),
340(13, 'delante izquierda', 'Cuero', ''),
341(13, 'delante derecha', 'Cuero', ''),
342(13, 'detras', 'Cuero', ''),
343(14, 'delante izquierda', 'Cuero', ''),
344(14, 'delante derecha', 'Cuero', ''),
345(14, 'detras', 'Cuero', ''),
346(15, 'delante izquierda', 'Nappa', ''),
347(15, 'delante derecha', 'Nappa', ''),
348(15, 'detras', 'Nappa', ''),
349(16, 'delante izquierda', 'Piel', ''),
350(16, 'delante derecha', 'Piel', ''),
351(16, 'detras', 'Piel', ''),
352(17, 'delante izquierda', 'Polipiel', ''),
353(17, 'delante derecha', 'Polipiel', ''),
354(17, 'detras', 'Polipiel', ''),
355(18, 'delante izquierda', 'Bipiel', ''),
356(18, 'delante derecha', 'Bipiel', ''),
357(18, 'detras', 'Bipiel', ''),
358(19, 'delante izquierda', 'Piel', ''),
359(19, 'delante derecha', 'Piel', ''),
360(19, 'detras', 'Piel', ''),
361(20, 'delante izquierda', 'Cuero', ''),
362(20, 'delante derecha', 'Cuero', ''),
363(20, 'detras', 'Cuero', ''),
364(21, 'delante izquierda', 'Tela', ''),
365(21, 'delante derecha', 'Tela', ''),
366(21, 'detras', 'Tela', ''),
367(22, 'delante izquierda', 'Tela', ''),
368(22, 'delante derecha', 'Tela', ''),
369(22, 'detras', 'Tela', ''),
370(23, 'delante izquierda', 'Nappa', ''),
371(23, 'delante derecha', 'Nappa', ''),
372(23, 'detras', 'Nappa', ''),
373(24, 'delante izquierda', 'Piel', ''),
374(24, 'delante derecha', 'Piel', ''),
375(24, 'detras', 'Piel', ''),
376(25, 'delante izquierda', 'Bipiel', ''),
377(25, 'delante derecha', 'Bipiel', ''),
378(25, 'detras', 'Bipiel', '');
379
380INSERT INTO piezasgenerales (nombre) VALUES ('tornillos'),
381('volante'),
382(‘tiradores’);
383
384
385
386INSERT INTO vepg (nsVehiculo, idPiezaGeneral, cantidad, fechaMontaje) VALUES (1, 1, 2000, '2007-03-14'),
387(1, 2, 1, '2007-04-08'),
388(1, 3, 4, '2007-02-12'),
389(2, 1, 2300, '2007-01-17'),
390(2, 2, 1, ''),
391(2, 3, 5, ''),
392(3, 1, 3000, ''),
393(3, 2, 1, ''),
394(3, 3, 4, ''),
395(4 , 1, , ‘’),
396(4 , 2, , ‘’),
397(4, 3, , ‘’),
398(5 , 1, , ‘’),
399(5 , 2, , ‘’),
400(5 , 3, , ‘’),
401(6 , 1, , ‘’),
402(6 , 2, , ‘’),
403(6 , 3, , ‘’),
404(7 , 1, , ‘’),
405(7 , 2, , ‘’),
406(7 , , , ‘’),
407(8 , , , ‘’),
408(8 , , , ‘’),
409(8 , , , ‘’),
410(9 , , , ‘’),
411(9 , , , ‘’),
412(9 , , , ‘’),
413(10 , , , ‘’),
414(10 , , , ‘’),
415(10 , , , ‘’),
416(11 , , , ‘’),
417(11 , , , ‘’),
418(11 , , , ‘’),
419(12 , , , ‘’),
420(12 , , , ‘’),
421(12 , , , ‘’),
422(13 , , , ‘’),
423(13 , , , ‘’),
424(13 , , , ‘’),