-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathDatosCompuesto.sql
More file actions
185 lines (173 loc) · 10.6 KB
/
DatosCompuesto.sql
File metadata and controls
185 lines (173 loc) · 10.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
--Insertando empleados
insert into empleado values ('101','1','Andrea','Andes','1023456789','1/06/2022','2/09/2000');
insert into empleado values ('102','1','Anuel','Ara','1234567899','2/06/2022','3/10/1984');
insert into empleado values ('103','4','Ana','Aguila','1234567900','3/06/2023','4/08/1985');
insert into empleado values ('201','1','Bruno','Baldomero','1234567900','1/06/2023','2/09/2000');
insert into empleado values ('202','1','Benito','Baez','1234567901','2/06/2023','3/10/1995');
insert into empleado values ('203','1','Brenda','Basilio','1234567901','4/06/2022','3/10/1996');
insert into empleado values ('301','4','Carla','Casto','1234567902','5/06/2022','3/10/1997');
insert into empleado values ('302','4','Carlo','Castro','1234567902','6/06/2022','3/10/1998');
insert into empleado values ('303','1','Camilo','Ciel','1234567903','7/06/2022','3/10/1999');
insert into empleado values ('304','1','Caleb','Carmelo','1234567903','8/06/2022','3/10/2000');
insert into empleado values ('305','4','Camilo','Ciro','1234567904','9/06/2022','3/10/2001');
select * from empleado;
--Darles un cargo
insert into historiacargo values ('1','1','101','1/06/2022','31/05/2024');
insert into historiacargo values ('2','1','102','2/06/2022','1/06/2024');
insert into historiacargo values ('3','1','103','3/06/2023','2/06/2025');
insert into historiacargo values ('4','2','201','1/06/2023','31/05/2025');
insert into historiacargo values ('5','2','202','2/06/2023','1/06/2025');
insert into historiacargo values ('6','2','203','4/06/2022','3/06/2024');
insert into historiacargo values ('7','3','301','5/06/2022','4/06/2024');
insert into historiacargo values ('8','3','302','6/06/2022','5/06/2024');
insert into historiacargo values ('9','3','303','7/06/2022','6/06/2024');
insert into historiacargo values ('10','3','304','8/06/2022','7/06/2024');
insert into historiacargo values ('11','3','305','9/06/2022','8/06/2024');
select * from historiacargo;
--Insertando Personas Cliente
insert into persona values ('601','1','1','Paulo','Castro','2/06/2022','60000001');
insert into persona values ('602','1','1','Pablo','Ciel','3/06/2023','60000002');
insert into persona values ('603','3','1','Paola','Carmelo','1/06/2023','60000003');
insert into persona values ('604','4','1','Pancho','Ciro','2/06/2023','60000004');
select * from persona;
--Insertando referencia elemento
insert into referenciaelemento values ('1','1','Obs: Board Asus A');
insert into referenciaelemento values ('2','1','Obs: Board AMD B');
insert into referenciaelemento values ('3','1','Obs: Board APPLE C');
insert into referenciaelemento values ('4','2','Obs: Procesador INTEL i7');
insert into referenciaelemento values ('5','2','Obs: Procesador AMD Ryzen 3500g');
insert into referenciaelemento values ('6','2','Obs: Procesador APPLE Mac');
insert into referenciaelemento values ('7','3','Obs: Ram Corsair');
insert into referenciaelemento values ('8','3','Obs: Ram Kingston');
insert into referenciaelemento values ('9','4','Obs: Disco Duro Toshiba');
insert into referenciaelemento values ('10','4','Obs: Disco Duro Samsung');
insert into referenciaelemento values ('11','5','Obs: Fuente de alimentación EVGA');
insert into referenciaelemento values ('12','5','Obs: Fuente de alimentación Seasonic');
select * from referenciaelemento;
--Insertando Caracteristicas a las referncias
insert into refcarac values ('1','1',NULL,'2','ASUS');
insert into refcarac values ('2','1','14','9','2');
insert into refcarac values ('3','2',NULL,'2','AMD');
insert into refcarac values ('4','2','14','9','3');
insert into refcarac values ('5','3',NULL,'2','APPLE');
insert into refcarac values ('6','3',14,'2','4');
insert into refcarac values ('7','4',NULL,'2','INTEL');
insert into refcarac values ('8','4','4','4','20');
insert into refcarac values ('9','4','2','6','5,3');
insert into refcarac values ('10','4','14','9','2');
insert into refcarac values ('11','4','8','8','125');
insert into refcarac values ('12','5',NULL,'2','AMD');
insert into refcarac values ('13','5','4','4','32');
insert into refcarac values ('14','5','2','6','3,8');
insert into refcarac values ('15','5','14','9','3');
insert into refcarac values ('16','5','8','8','105');
insert into refcarac values ('17','6',NULL,'2','APPLE');
insert into refcarac values ('18','6','4','4','12');
insert into refcarac values ('19','6','2','6','4,5');
insert into refcarac values ('20','6','14','9','4');
insert into refcarac values ('21','6','8','8','110');
insert into refcarac values ('22','7',NULL,'2','Corsair ');
insert into refcarac values ('23','7',NULL,'1','DDR4');
insert into refcarac values ('24','7','5','4','16');
insert into refcarac values ('25','7','1','6','3200');
insert into refcarac values ('26','7',NULL,'7','16-18-18-36');
insert into refcarac values ('27','7','7','8','1,35');
insert into refcarac values ('28','8',NULL,'2','Kingston ');
insert into refcarac values ('29','8',NULL,'1','DDR4');
insert into refcarac values ('30','8','5','4','32');
insert into refcarac values ('31','8','1','6','3600');
insert into refcarac values ('32','8',NULL,'7','16-17-17-35');
insert into refcarac values ('33','8','7','8','1,2');
insert into refcarac values ('34','9',NULL,'2','Toshiba ');
insert into refcarac values ('35','9',NULL,'1','HDD');
insert into refcarac values ('36','9','19','3','7200');
insert into refcarac values ('37','9','6','4','3');
insert into refcarac values ('38','9',NULL,'11','SATA 6 Gb/s');
insert into refcarac values ('39','10',NULL,'2','Samsung ');
insert into refcarac values ('40','10',NULL,'1','SDD');
insert into refcarac values ('41','10','21','3','2500');
insert into refcarac values ('42','10','5','4','250');
insert into refcarac values ('43','10',NULL,'11','PCIe 3.0 x4');
insert into refcarac values ('44','11',NULL,'2','EVGA ');
insert into refcarac values ('45','11',NULL,'1','Modular');
insert into refcarac values ('46','11',NULL,'5','1x 24-pin, 1x 8-pin (CPU)');
insert into refcarac values ('47','12',NULL,'2','Seasonic ');
insert into refcarac values ('48','12',NULL,'1','Semi-Modular');
insert into refcarac values ('49','12',NULL,'5','4x PCIe 8-pin');
select * from refcarac;
--Insertando inventario
insert into inventario values ('1',NULL,'1','1','10/06/2023','40');
insert into inventario values ('2',NULL,'2','1','11/06/2023','42');
insert into inventario values ('3',NULL,'4','1','12/06/2023','41');
insert into inventario values ('4',NULL,'5','1','13/06/2023','40');
insert into inventario values ('5',NULL,'6','2','14/06/2023','35');
insert into inventario values ('6',NULL,'1','2','15/06/2023','37');
insert into inventario values ('7',NULL,'2','2','16/06/2023','36');
insert into inventario values ('8',NULL,'4','2','17/06/2023','35');
insert into inventario values ('9',NULL,'5','3','18/06/2023','55');
insert into inventario values ('10',NULL,'6','3','19/06/2023','57');
insert into inventario values ('11',NULL,'1','3','20/06/2023','56');
insert into inventario values ('12',NULL,'1','3','10/7/2023','55');
insert into inventario values ('13',NULL,'2','4','11/7/2023','80');
insert into inventario values ('14',NULL,'4','4','12/7/2023','84');
insert into inventario values ('15',NULL,'5','4','13/7/2023','82');
insert into inventario values ('16',NULL,'6','4','14/7/2023','80');
insert into inventario values ('17',NULL,'1','5','15/7/2023','70');
insert into inventario values ('18',NULL,'2','5','16/7/2023','74');
insert into inventario values ('19',NULL,'4','5','17/7/2023','72');
insert into inventario values ('20',NULL,'5','5','18/7/2023','70');
insert into inventario values ('21',NULL,'6','6','19/7/2023','11');
insert into inventario values ('22',NULL,'1','6','20/7/2023','11');
insert into inventario values ('23',NULL,'1','6','10/8/2023','11');
insert into inventario values ('24',NULL,'2','6','11/8/2023','11');
insert into inventario values ('25',NULL,'4','7','12/8/2023','20');
insert into inventario values ('26',NULL,'5','7','13/8/2023','21');
insert into inventario values ('27',NULL,'6','7','14/8/2023','20');
insert into inventario values ('28',NULL,'1','7','15/8/2023','20');
insert into inventario values ('29',NULL,'2','8','16/8/2023','17');
insert into inventario values ('30',NULL,'4','8','17/8/2023','18');
insert into inventario values ('31',NULL,'5','8','18/8/2023','18');
insert into inventario values ('32',NULL,'6','8','19/8/2023','17');
insert into inventario values ('33',NULL,'1','9','20/8/2023','20');
insert into inventario values ('34',NULL,'1','9','10/9/2023','21');
insert into inventario values ('35',NULL,'2','9','11/9/2023','20');
insert into inventario values ('36',NULL,'4','9','12/9/2023','20');
insert into inventario values ('37',NULL,'5','10','13/9/2023','17');
insert into inventario values ('38',NULL,'6','10','14/9/2023','18');
insert into inventario values ('39',NULL,'1','10','15/9/2023','18');
insert into inventario values ('40',NULL,'2','10','16/9/2023','17');
insert into inventario values ('41',NULL,'4','11','17/9/2023','18');
insert into inventario values ('42',NULL,'5','11','18/9/2023','23');
insert into inventario values ('43',NULL,'6','11','19/9/2023','18');
insert into inventario values ('44',NULL,'1','11','20/9/2023','17');
insert into inventario values ('45',NULL,'1','12','10/10/2023','25');
insert into inventario values ('46',NULL,'2','12','11/10/2023','18');
insert into inventario values ('47',NULL,'4','12','12/10/2023','15');
insert into inventario values ('48',NULL,'5','12','13/10/2023','30');
select * from inventario;
--- ENSAMBLES
insert into ensamble values ('1','301','13/10/2023',true);
insert into ensamble values ('2',NULL,'14/10/2023',false);
insert into ensamble values ('3',NULL,'15/10/2023',false);
select * from ensamble;
-- DETALLE ENSAMBLE
insert into detalleensamble values ('1','1','1','1');
insert into detalleensamble values ('2','1','5','2');
insert into detalleensamble values ('3','1','9','3');
insert into detalleensamble values ('4','1','13','4');
insert into detalleensamble values ('5','1','17','5');
insert into detalleensamble values ('6','2','21','6');
insert into detalleensamble values ('7','2','25','7');
insert into detalleensamble values ('8','2','29','8');
insert into detalleensamble values ('9','2','33','9');
insert into detalleensamble values ('10','2','37','10');
insert into detalleensamble values ('11','3','41','11');
insert into detalleensamble values ('12','3','45','12');
insert into detalleensamble values ('13','3','2','1');
insert into detalleensamble values ('14','3','6','2');
insert into detalleensamble values ('15','3','10','3');
select * from detalleensamble;
--- Querys importantes
select E.nomempleado, E.apeempleado, H.codempleado, H.codempleado
from historiacargo H, empleado E
where E.codempleado = H.codempleado;