-
Notifications
You must be signed in to change notification settings - Fork 11
/
BBDDUniversidad.sql
2128 lines (2091 loc) · 118 KB
/
BBDDUniversidad.sql
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
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
-- CREACIÓN DE LA BASE DE DATOS
-- Eliminamos base de datos 'Facultad' si existe
DROP DATABASE IF EXISTS Facultad;
-- Creamos base de datos 'Facultad'
CREATE DATABASE Facultad;
-- Designamos 'Facultad' como base de datos actual, a la que se hará referencia en el resto del código
USE Facultad;
-- CREACIÓN DE LAS TABLAS
/* Borramos las tablas si existen.
Esto no es totalmente necesario ya que anteriormente se eliminó y creó de nuevo la base de datos.
Por lo tanto, las tablas también quedaron eliminadas*/
DROP TABLE IF EXISTS curso;
DROP TABLE IF EXISTS profesor;
DROP TABLE IF EXISTS tlfContactoProf;
DROP TABLE IF EXISTS asignatura;
DROP TABLE IF EXISTS alumno;
DROP TABLE IF EXISTS matricula;
DROP TABLE IF EXISTS impartir;
-- Creación de tablas
CREATE TABLE curso(
idCurso numeric(2),
nombreDescriptivo text(10) not null,
nAsignaturas numeric(3) not null,
PRIMARY KEY(idCurso)
);
CREATE TABLE profesor(
idProfesor char(5),
NIF char(9) unique,
nombre varchar(50) not null,
apellido1 varchar(50) not null,
apellido2 varchar(50),
email varchar (50) unique,
direccion varchar(100) not null,
codigoPostal numeric(5) not null,
municipio text(50) not null,
provincia text(50) not null,
categoria enum('Catedráticos de Universidad', 'Titulares Universidad', 'Catedráticos de Escuela Universitaria',
'Titulares de Escuela Universitaria', 'Eméritos', 'Contratados Doctores', 'Contratados Doctores Interinos',
'Asociados', 'Asociado Interino', 'Ayudantes Doctores', 'Otros Investigadores Doctores', 'PDI predoctoral'),
PRIMARY KEY(idProfesor)
);
CREATE TABLE tlfContactoProf(
idProfesor char(5) not null,
telefono numeric(9) not null,
FOREIGN KEY(idProfesor) REFERENCES profesor(idProfesor)
ON DELETE cascade -- Eliminando un profesor se eliminarán automáticamente sus teléfonos de contacto
);
CREATE TABLE asignatura(
curso numeric(2) not null,
idAsignatura char(5) not null,
nombre varchar(150) unique,
cuatrimestre enum('1', '2'),
creditos real not null,
caracter enum('obligatoria', 'optativa') not null,
coordinador char(5) not null,
PRIMARY KEY(idAsignatura),
FOREIGN KEY(curso) REFERENCES curso(idCurso),
FOREIGN KEY(coordinador) REFERENCES profesor(idProfesor)
);
CREATE TABLE alumno(
idAlumno char(5) not null,
NIF char(9)unique, -- NIF es una cadena de caracteres de longitud fija de 9 y un valor único
nombre text(50) not null,
apellido1 text(50) not null,
apellido2 text(50),
email varchar(50) unique,
direccion varchar(100) not null,
codigoPostal numeric(5) not null,
municipio text(50) not null,
provincia text(50) not null,
PRIMARY KEY(idAlumno)
);
CREATE TABLE matricula(
idAlumno char(5) not null,
idAsignatura char(5) not null,
nota real not null,
FOREIGN KEY(idAlumno) REFERENCES alumno(idAlumno),
FOREIGN KEY(idAsignatura) REFERENCES asignatura(idAsignatura),
CHECK (nota > 0)
);
CREATE TABLE impartir(
idProfesor char(5) not null,
idAsignatura char(5) not null,
FOREIGN KEY(idProfesor) REFERENCES profesor(idProfesor),
FOREIGN KEY(idAsignatura) REFERENCES asignatura(idAsignatura)
);
-- Olvidé incluir el campo beca en alumno. Lo incluiremos con alter table
ALTER TABLE alumno
ADD beca char(2) not null;
-- CARGA DE DATOS
/*Carga con inserción manual datos curso. Únicamente introduciremos los datos de idCurso y nombreDescriptivo
ya que nASignaturas depende del sumatorio de las asignaturas pertenecientes a otra tabla */
INSERT INTO curso VALUES(1, 'Primero', 10);
INSERT INTO curso VALUES(2, 'Segundo', 10);
INSERT INTO curso VALUES(3, 'Terceo', 10);
INSERT INTO curso VALUES(4, 'Cuarto', 53);
INSERT INTO curso VALUES(5, 'Master', 11);
INSERT INTO curso VALUES(6, 'Doctorado', 6);
-- Solicitamos el directorio donde donde alojar los archivos que querramos importar
SELECT @@GLOBAL.secure_file_priv;
/*Importamos el archivo alumnos.txt en la tabla alumno estableciendo ";" como separador
entre campos y "\n", significa salto de linea, para definir que cada
registro acaba al haber salto de linea*/
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/alumnos.txt'
INTO TABLE alumno
FIELDS TERMINATED BY ';'
LINES terminated by '\n'
ignore 1 rows;
-- Carga con inserción manual de datos profesor
INSERT INTO profesor VALUES('PR001','34417139B','Juan','Infante','Fraidias','[email protected]','Calle de los Almendros , 86',28070,'Las Rozas','Madrid','Asociados');
INSERT INTO profesor VALUES('PR002','52479077P','David','Serna','Balmori','[email protected]','Calle Abarejo , 44',28017,'Brea de Tajo','Madrid','Titulares Universidad');
INSERT INTO profesor VALUES('PR003','84277383X','Josefa','Pedraza','Travez','[email protected]','Calle Abogados de Atocha , 145',28035,'El Molar','Madrid','Contratados Doctores');
INSERT INTO profesor VALUES('PR004','72702217A','Jose Antonio','Belda','Leno','[email protected]','Calle de Ayamonte , 186',28080,'Pezuela de las Torres','Madrid','Titulares Universidad');
INSERT INTO profesor VALUES('PR005','75239553F','Jose Luis','Barragan','Usategui','[email protected]','Travesia del Almendro , 97',28038,'Robledillo de la Jara','Madrid','Catedráticos de Escuela Universitaria');
INSERT INTO profesor VALUES('PR006','81953461Y','Francisco Javier','Reig','Amills','[email protected]','Calle de la Albericia , 134',28071,'Colmenarejo','Madrid','Contratados Doctores Interinos');
INSERT INTO profesor VALUES('PR007','18598553N','Ana Maria','De Diego','Bocigas','[email protected]','Avenida de los Andes , 188',28030,'Prádena del Rincón','Madrid','PDI predoctoral');
INSERT INTO profesor VALUES('PR008','72252271H','Carlos','Fuertes','Carulla','[email protected]','Calle Águeda , 26',28046,'Velilla de San Antonio','Madrid','Catedráticos de Escuela Universitaria');
INSERT INTO profesor VALUES('PR009','70631063C','Daniel','Aguado','Pastrana','[email protected]','Calle de Antoñita Jiménez , 122',28041,'Talamanca de Jarama','Madrid','Catedráticos de Universidad');
INSERT INTO profesor VALUES('PR010','15794042W','Maria Dolores','Espino','Zamudio','[email protected]','Calle del Arroyo de la Elipa , 189',28034,'San Martín de la Vega','Madrid','Titulares Universidad');
INSERT INTO profesor VALUES('PR011','86245635W','Maria Pilar','Valderrama','Urquiaga','[email protected]','Calle Alisios , 150',28006,'Chapinería','Madrid','Catedráticos de Escuela Universitaria');
INSERT INTO profesor VALUES('PR012','83153833C','Miguel','Fuentes','Andreu','[email protected]','Calle de la Alcoholera , 12',28080,'Pozuelo del Rey','Madrid','Contratados Doctores Interinos');
INSERT INTO profesor VALUES('PR013','55710808P','Maria Teresa','Pico','Zoyo','[email protected]','Calle de Arenas de Iguña , 17',28080,'Algete','Madrid','Ayudantes Doctores');
INSERT INTO profesor VALUES('PR014','52041463T','Ana','Andujar','Popovici','[email protected]','Calle de las Aguas , 61',28035,'Cabanillas de la Sierra','Madrid','Otros Investigadores Doctores');
INSERT INTO profesor VALUES('PR015','81703794T','Rafael','Murcia','Petrov','[email protected]','Calle Almendro , 53',28012,'Tielmes','Madrid','PDI predoctoral');
INSERT INTO profesor VALUES('PR016','36742399V','Jose Manuel','Antolin','Diranzo','[email protected]','Calle Azabache , 190',28012,'Piñuécar-Gandullas','Madrid','Catedráticos de Universidad');
INSERT INTO profesor VALUES('PR017','33150418J','Pedro','Calderon','Domenech','[email protected]','Carretera de Alpedrete , 104',28008,'Ciempozuelos','Madrid','Contratados Doctores');
INSERT INTO profesor VALUES('PR018','82285639Q','Laura','Bueno','Sobreira','[email protected]','Calle de los Árboles , 198',28039,'Cabanillas de la Sierra','Madrid','Catedráticos de Escuela Universitaria');
INSERT INTO profesor VALUES('PR019','37497894I','Francisca','Smith','Mafla','[email protected]','Calle del Arco , 149',28029,'Moralzarzal','Madrid','Otros Investigadores Doctores');
INSERT INTO profesor VALUES('PR020','34744580Y','Antonia','Vara','Esarte','[email protected]','Calle de Alba de Tormes , 123',28030,'Valdemoro','Madrid','Contratados Doctores');
INSERT INTO profesor VALUES('PR021','25542059S','Alejandro','Piã‘A','Ivars','alejandro.piã‘[email protected]','Calle Alfonso X El Sabio , 199',28008,'Colmenar de Oreja','Madrid','Catedráticos de Escuela Universitaria');
INSERT INTO profesor VALUES('PR022','71976482V','Dolores','Amoros','Cases','[email protected]','Calle de las Acacias , 109',28048,'Manzanares el Real','Madrid','Catedráticos de Universidad');
INSERT INTO profesor VALUES('PR023','76471428I','Antonio','Quero','Atienza','[email protected]','Vereda de las Arboledas , 89',28015,'Sevilla la Nueva','Madrid','Catedráticos de Universidad');
INSERT INTO profesor VALUES('PR024','57354131X','Jose','Valera','Bardal','[email protected]','Calle de la Alegría , 82',28034,'Villa del Prado','Madrid','Titulares Universidad');
INSERT INTO profesor VALUES('PR025','21841380T','Maria Carmen','Palacios','Cholvi','[email protected]','Calle Apolo , 32',28083,'Meco','Madrid','Otros Investigadores Doctores');
INSERT INTO profesor VALUES('PR026','86751787V','Maria','Lucena','Nebra','[email protected]','Calle Arroyo de los Berros , 31',28046,'Moraleja de Enmedio','Madrid','Catedráticos de Escuela Universitaria');
INSERT INTO profesor VALUES('PR027','35634129C','Manuel','Falcon','Zendoia','[email protected]','Calle de Aguileñas , 65',28041,'Mejorada del Campo','Madrid','Titulares de Escuela Universitaria');
INSERT INTO profesor VALUES('PR028','67157773L','Francisco','Cid','Lubiano','[email protected]','Travesia Antón , 55',28045,'Madrid','Madrid','Asociado Interino');
INSERT INTO profesor VALUES('PR029','34163047Q','Carmen','Pino','Holgueras','[email protected]','Calle de Alcalá de Guadaira , 170',28048,'Rozas de Puerto Real','Madrid','Titulares de Escuela Universitaria');
INSERT INTO profesor VALUES('PR030','78969666B','Juan','Perera','Chao','[email protected]','Calle del Arroyo , 34',28009,'Pinilla del Valle','Madrid','Asociados');
INSERT INTO profesor VALUES('PR031','15480959Q','David','Galindo','Chirila','[email protected]','Calle de Asunción Cuestablanca , 40',28040,'La Cabrera','Madrid','Asociado Interino');
INSERT INTO profesor VALUES('PR032','76367475V','Josefa','Villena','Hombrados','[email protected]','Calle de Alonso de Mendoza , 161',28043,'Boadilla del Monte','Madrid','PDI predoctoral');
INSERT INTO profesor VALUES('PR033','64389449W','Jose Antonio','Bonilla','Abello','[email protected]','Calle de Albalate del Arzobispo , 51',28016,'Navalafuente','Madrid','Ayudantes Doctores');
INSERT INTO profesor VALUES('PR034','47783567D','Jose Luis','Yague','Liern','[email protected]','Calle Atocha , 133',28023,'Puebla de la Sierra','Madrid','Ayudantes Doctores');
INSERT INTO profesor VALUES('PR035','13616538V','Javier','Exposito','Orejuela','[email protected]','Calle los Acebos , 138',28086,'Valdemaqueda','Madrid','Titulares Universidad');
INSERT INTO profesor VALUES('PR036','78722469N','Isabel','Chaves','Cantisano','[email protected]','Calle de Alcudia , 14',28006,'San Fernando de Henares','Madrid','Catedráticos de Escuela Universitaria');
INSERT INTO profesor VALUES('PR037','45405804R','Jesus','Cerezo','Esquer','[email protected]','Calle Armonía , 61',28087,'Robledo de Chavela','Madrid','Contratados Doctores');
INSERT INTO profesor VALUES('PR038','25187565W','Francisco Javier','Aguilera','Pavlova','[email protected]','Calle Acacia , 53',28014,'Boadilla del Monte','Madrid','Catedráticos de Universidad');
INSERT INTO profesor VALUES('PR039','19655057F','Ana Maria','Guillen','Bembibre','[email protected]','Pasaje Almendro del Paular , 167',28071,'Puentes Viejas','Madrid','Catedráticos de Universidad');
INSERT INTO profesor VALUES('PR040','29987297T','Carlos','De Las Heras','Orrego','[email protected]','Calle del Alcalde Ramón del Yerro Ordóñez , 135',28011,'El Molar','Madrid','Eméritos');
INSERT INTO profesor VALUES('PR041','22835810F','Daniel','De La Rosa','Gaudes','[email protected]','Calle del Alcalde Pablo Durán y Pérez de Castro , 2',28050,'Fuentidueña de Tajo','Madrid','Ayudantes Doctores');
INSERT INTO profesor VALUES('PR042','63215069W','Maria Dolores','Casanova','Ocasar','[email protected]','Calle de las Arenas , 161',28083,'Braojos de la Sierra','Madrid','Contratados Doctores Interinos');
INSERT INTO profesor VALUES('PR043','83480230A','Maria Pilar','Bejarano','De La Piedad','[email protected]','Calle Aldea del Fresno , 105',28071,'Coslada','Madrid','Contratados Doctores Interinos');
INSERT INTO profesor VALUES('PR044','19206079I','Miguel','Silva','Rose','[email protected]','Calle de Asunción , 173',28049,'Bustarviejo','Madrid','Asociado Interino');
INSERT INTO profesor VALUES('PR045','66989687K','Maria Teresa','Valderrama','Ruperez','[email protected]','Plaza de Antonio Chenel Antoñete , 152',28014,'Lozoyuela-Navas-Sieteiglesias','Madrid','Titulares Universidad');
INSERT INTO profesor VALUES('PR046','47970524A','Ana','Padron','Balada','[email protected]','Calle de Argentona , 179',28002,'Boadilla del Monte','Madrid','Titulares Universidad');
INSERT INTO profesor VALUES('PR047','76965754O','Rafael','Figueroa','Casal','[email protected]','Calle de la Aeronave , 37',28004,'Colmenarejo','Madrid','PDI predoctoral');
INSERT INTO profesor VALUES('PR048','48034341Q','Jose Manuel','Nevado','Veras','[email protected]','Calle Arlanza , 170',28001,'Ajalvir','Madrid','Catedráticos de Universidad');
-- Importamos los teléfonos de contacto de profesores como archivo .CSV
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/telefonosContacto.csv'
INTO TABLE tlfContactoProf
FIELDS TERMINATED BY ';'
LINES terminated by '\n'
ignore 1 rows;
-- Carga con inserción manual de datos asignatura
INSERT INTO asignatura VALUES (1,'AS001','Algebra lineal','2',6,'obligatoria','PR001');
INSERT INTO asignatura VALUES (1,'AS002','Análisis exploratorio de datos','1',6,'obligatoria','PR002');
INSERT INTO asignatura VALUES (1,'AS003','Análisis matemático','1',6,'obligatoria','PR003');
INSERT INTO asignatura VALUES (1,'AS004','Fundamentos de computadores y sistemas operativos','2',6,'obligatoria','PR004');
INSERT INTO asignatura VALUES (1,'AS005','Fundamentos de organización de empresas','1',6,'obligatoria','PR005');
INSERT INTO asignatura VALUES (1,'AS006','Fundamentos de programación','1',6,'obligatoria','PR004');
INSERT INTO asignatura VALUES (1,'AS007','Matemáticas discretas','1',6,'obligatoria','PR003');
INSERT INTO asignatura VALUES (1,'AS008','Modelos estadísticos para la toma de decisiones I','2',6,'obligatoria','PR008');
INSERT INTO asignatura VALUES (1,'AS009','Programación','2',6,'obligatoria','PR004');
INSERT INTO asignatura VALUES (1,'AS010','Proyecto I. Comprensión de datos','2',6,'obligatoria','PR002');
INSERT INTO asignatura VALUES (2,'AS011','Adquisición y transmisión de datos','1',6,'obligatoria','PR004');
INSERT INTO asignatura VALUES (2,'AS012','Bases de datos','1',6,'obligatoria','PR002');
INSERT INTO asignatura VALUES (2,'AS013','Comportamiento económico y social','1',6,'obligatoria','PR006');
INSERT INTO asignatura VALUES (2,'AS014','Estructuras de datos','1',6,'obligatoria','PR002');
INSERT INTO asignatura VALUES (2,'AS015','Gestión de datos','2',6,'obligatoria','PR002');
INSERT INTO asignatura VALUES (2,'AS016','Modelado discreto y teoría de la información','2',6,'obligatoria','PR007');
INSERT INTO asignatura VALUES (2,'AS017','Modelos descriptivos y predictivos I','2',6,'obligatoria','PR008');
INSERT INTO asignatura VALUES (2,'AS018','Modelos estadísticos para la toma de decisiones II','1',6,'obligatoria','PR008');
INSERT INTO asignatura VALUES (2,'AS019','Proyecto II. Integración y preparación de datos','2',6,'obligatoria','PR009');
INSERT INTO asignatura VALUES (2,'AS020','Seguridad de los datos','2',6,'obligatoria','PR004');
INSERT INTO asignatura VALUES (3,'AS021','Algorítmica','2',6,'obligatoria','PR001');
INSERT INTO asignatura VALUES (3,'AS022','Economía digital','1',6,'obligatoria','PR006');
INSERT INTO asignatura VALUES (3,'AS023','Evaluación','2',6,'obligatoria','PR007');
INSERT INTO asignatura VALUES (3,'AS024','Infraestrutura para el procesamiento de datos','1',6,'obligatoria','PR009');
INSERT INTO asignatura VALUES (3,'AS025','Lenguaje natural y recuperación de la información','2',6,'obligatoria','PR009');
INSERT INTO asignatura VALUES (3,'AS026','Modelado y simulación continuos','2',6,'obligatoria','PR010');
INSERT INTO asignatura VALUES (3,'AS027','Modelos descriptivos y predictivos II','1',6,'obligatoria','PR008');
INSERT INTO asignatura VALUES (3,'AS028','Proyecto III. Analisis de datos','2',6,'obligatoria','PR010');
INSERT INTO asignatura VALUES (3,'AS029','Representación del conocimiento y razonamiento','1',6,'obligatoria','PR011');
INSERT INTO asignatura VALUES (3,'AS030','Visualización','1',6,'obligatoria','PR010');
INSERT INTO asignatura VALUES (4,'AS031','Gestión de proyectos','1',5,'obligatoria','PR005');
INSERT INTO asignatura VALUES (4,'AS032','Marco profesional','1',5,'obligatoria','PR006');
INSERT INTO asignatura VALUES (4,'AS033','Optimización','1',6,'obligatoria','PR015');
INSERT INTO asignatura VALUES (4,'AS034','Técnicas escalables en aprendizaje automático','1',6,'obligatoria','PR024');
INSERT INTO asignatura VALUES (4,'AS035','Trabajo Fin de Grado','2',12,'obligatoria','PR036');
INSERT INTO asignatura VALUES (4,'AS036','Alemán académico y profesional A1','1',5,'optativa','PR020');
INSERT INTO asignatura VALUES (4,'AS037','Alemán académico y profesional A2','2',5,'optativa','PR020');
INSERT INTO asignatura VALUES (4,'AS038','Alemán académico y profesional B1','1',5,'optativa','PR020');
INSERT INTO asignatura VALUES (4,'AS039','Alemán académico y profesional B2','2',5,'optativa','PR020');
INSERT INTO asignatura VALUES (4,'AS040','Análisis de datos en entornos industriales','1',5,'optativa','PR002');
INSERT INTO asignatura VALUES (4,'AS041','Análisis de imágenes y vídeos','1',5,'optativa','PR021');
INSERT INTO asignatura VALUES (4,'AS042','Análisis de mercados y aplicaciones financieras','1',5,'optativa','PR005');
INSERT INTO asignatura VALUES (4,'AS043','Análisis de redes sociales','1',5,'optativa','PR002');
INSERT INTO asignatura VALUES (4,'AS044','Analítica de datos en educació','1',5,'optativa','PR002');
INSERT INTO asignatura VALUES (4,'AS045','Analítica de datos en seguridad','1',5,'optativa','PR002');
INSERT INTO asignatura VALUES (4,'AS046','Bases de datos avanzadas y distribuidas','1',5,'optativa','PR016');
INSERT INTO asignatura VALUES (4,'AS047','Biomedical data science','1',5,'optativa','PR026');
INSERT INTO asignatura VALUES (4,'AS048','Business Analytics','2',5,'optativa','PR005');
INSERT INTO asignatura VALUES (4,'AS049','Cibermetría','2',5,'optativa','PR004');
INSERT INTO asignatura VALUES (4,'AS050','Estructuas de datos y algoritmos escalables','2',5,'optativa','PR002');
INSERT INTO asignatura VALUES (4,'AS051','Français scientifique et technique - B1','1',5,'optativa','PR027');
INSERT INTO asignatura VALUES (4,'AS052','Francés académico y profesional A1','1',5,'optativa','PR027');
INSERT INTO asignatura VALUES (4,'AS053','Francés académico y profesional A2','2',5,'optativa','PR027');
INSERT INTO asignatura VALUES (4,'AS054','Frances académico y profesional B1','1',5,'optativa','PR027');
INSERT INTO asignatura VALUES (4,'AS055','Frances académico y profesional B2','2',5,'optativa','PR027');
INSERT INTO asignatura VALUES (4,'AS056','Gestion clínica y de servicios de salud','2',5,'optativa','PR011');
INSERT INTO asignatura VALUES (4,'AS057','Gestión de datos científicos en salud','2',5,'optativa','PR015');
INSERT INTO asignatura VALUES (4,'AS058','Gestión de datos en logística y cadenas de suministro','2',5,'optativa','PR002');
INSERT INTO asignatura VALUES (4,'AS059','Inglés B2','1',5,'optativa','PR030');
INSERT INTO asignatura VALUES (4,'AS060','Intercambio Académico I','1',3,'optativa','PR031');
INSERT INTO asignatura VALUES (4,'AS061','Intercambio Académico II','1',3,'optativa','PR031');
INSERT INTO asignatura VALUES (4,'AS062','Intercambio Académico III','2',3,'optativa','PR031');
INSERT INTO asignatura VALUES (4,'AS063','Intercambio Académico IV','2',3,'optativa','PR031');
INSERT INTO asignatura VALUES (4,'AS064','Intercambio Académico V','2',3,'optativa','PR031');
INSERT INTO asignatura VALUES (4,'AS065','Intercambio Académico VI','1',5,'optativa','PR031');
INSERT INTO asignatura VALUES (4,'AS066','Intercambio Académico VII','1',5,'optativa','PR031');
INSERT INTO asignatura VALUES (4,'AS067','Intercambio Académico VIII','2',5,'optativa','PR031');
INSERT INTO asignatura VALUES (4,'AS068','Intercambio Académico IX','2',5,'optativa','PR031');
INSERT INTO asignatura VALUES (4,'AS069','Intercambio Académico X','1',6,'optativa','PR031');
INSERT INTO asignatura VALUES (4,'AS070','Intercambio Académico XI','2',6,'optativa','PR031');
INSERT INTO asignatura VALUES (4,'AS071','Italiano académico y profesional A1','1',5,'optativa','PR029');
INSERT INTO asignatura VALUES (4,'AS072','Marketing','2',5,'optativa','PR005');
INSERT INTO asignatura VALUES (4,'AS073','Modelos de programación para computación de datos','2',5,'optativa','PR004');
INSERT INTO asignatura VALUES (4,'AS074','Procesamiento y análisis de biosecuencias','2',5,'optativa','PR025');
INSERT INTO asignatura VALUES (4,'AS075','Programación para Internet de las Cosas (IoT)','2',5,'optativa','PR004');
INSERT INTO asignatura VALUES (4,'AS076','Sistemas de información empresarial','2',5,'optativa','PR005');
INSERT INTO asignatura VALUES (4,'AS077','Sistemas inteligentes de transporte','2',5,'optativa','PR006');
INSERT INTO asignatura VALUES (4,'AS078','Técnicas de previsión','2',5,'optativa','PR006');
INSERT INTO asignatura VALUES (4,'AS079','Tratamiento de datos geoespaciales','2',5,'optativa','PR002');
INSERT INTO asignatura VALUES (4,'AS080','Tratamiento de la infromación en IoT','2',5,'optativa','PR033');
INSERT INTO asignatura VALUES (4,'AS081','Visualización interactiva','2',5,'optativa','PR015');
INSERT INTO asignatura VALUES (4,'AS082','Inglés C1','1',5,'optativa','PR034');
INSERT INTO asignatura VALUES (4,'AS083','Inglés C2','2',5,'optativa','PR034');
INSERT INTO asignatura VALUES (5,'AS084','Fundamentos de tratamiento de datos para Data Science','1',6,'obligatoria','PR002');
INSERT INTO asignatura VALUES (5,'AS085','Modelos y aprendizaje estadístico','1',6,'obligatoria','PR008');
INSERT INTO asignatura VALUES (5,'AS086','Aprendizaje automático aplicado (Machine Learning)','1',6,'obligatoria','PR036');
INSERT INTO asignatura VALUES (5,'AS087','Minería de texto y procesamiento del lenguaje natural (PNL)','1',6,'obligatoria','PR036');
INSERT INTO asignatura VALUES (5,'AS088','Inteligencia de negocio y visualización','1',6,'obligatoria','PR036');
INSERT INTO asignatura VALUES (5,'AS089','Infraestructura Big Data','2',6,'obligatoria','PR036');
INSERT INTO asignatura VALUES (5,'AS090','Almacenamiento e integración de datos','2',6,'obligatoria','PR022');
INSERT INTO asignatura VALUES (5,'AS091','Valor y contexto de la analítica big data','2',6,'obligatoria','PR022');
INSERT INTO asignatura VALUES (5,'AS092','Aplicaciones analíticas. Casos Practicos','2',6,'obligatoria','PR022');
INSERT INTO asignatura VALUES (5,'AS093','Trabajo Fin de Master','2',6,'obligatoria','PR010');
INSERT INTO asignatura VALUES (5,'AS094','Curso de metodologías ágiles','2',6,'optativa','PR010');
INSERT INTO asignatura VALUES (6,'AS095','Técnicas y metodología de la minería de datos (SEMMA)','1',0,'optativa','PR002');
INSERT INTO asignatura VALUES (6,'AS096','Gestión y explotación de almacenes de datos','1',0,'optativa','PR002');
INSERT INTO asignatura VALUES (6,'AS097','Redes neuronales y algoritmos genéticos','1',0,'optativa','PR037');
INSERT INTO asignatura VALUES (6,'AS098','Gestión de relaciones con el cliente CRM','2',0,'optativa','PR005');
INSERT INTO asignatura VALUES (6,'AS099','Inteligencia de negocio y cuadro de mando integral','2',0,'optativa','PR005');
INSERT INTO asignatura VALUES (6,'AS100','Modelos de decisión en marketing','2',0,'optativa','PR005');
/* Importamos impartir.csv en la tabla 'impartir'. En este caso los campos del csv está separado por tabulaciones.
Por eso, usaremos la secuencia de escape '\t' para indicar a SQL como separar los datos*/
LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/impartir.txt'
INTO TABLE impartir
FIELDS TERMINATED BY '\t'
LINES terminated by '\n'
ignore 1 rows;
-- Carga con inserción manual de datos matricula (idAlumno, idAsignatura, Nota).
INSERT INTO matricula VALUES('AL003','AS001',6.99);
INSERT INTO matricula VALUES('AL003','AS002',9.71);
INSERT INTO matricula VALUES('AL003','AS003',10);
INSERT INTO matricula VALUES('AL003','AS004',8.89);
INSERT INTO matricula VALUES('AL003','AS005',8.49);
INSERT INTO matricula VALUES('AL003','AS006',8.74);
INSERT INTO matricula VALUES('AL003','AS007',5.69);
INSERT INTO matricula VALUES('AL003','AS008',6.91);
INSERT INTO matricula VALUES('AL003','AS009',2.31);
INSERT INTO matricula VALUES('AL003','AS010',9.47);
INSERT INTO matricula VALUES('AL017','AS001',2.97);
INSERT INTO matricula VALUES('AL017','AS002',4.28);
INSERT INTO matricula VALUES('AL017','AS003',7.69);
INSERT INTO matricula VALUES('AL017','AS004',7.23);
INSERT INTO matricula VALUES('AL017','AS005',5.07);
INSERT INTO matricula VALUES('AL017','AS006',6.82);
INSERT INTO matricula VALUES('AL017','AS007',1.22);
INSERT INTO matricula VALUES('AL017','AS008',2.32);
INSERT INTO matricula VALUES('AL017','AS009',5.82);
INSERT INTO matricula VALUES('AL017','AS010',3.39);
INSERT INTO matricula VALUES('AL019','AS001',2.93);
INSERT INTO matricula VALUES('AL019','AS002',9.49);
INSERT INTO matricula VALUES('AL019','AS003',8.77);
INSERT INTO matricula VALUES('AL019','AS004',5.11);
INSERT INTO matricula VALUES('AL019','AS005',4.97);
INSERT INTO matricula VALUES('AL019','AS006',9.82);
INSERT INTO matricula VALUES('AL019','AS007',1.14);
INSERT INTO matricula VALUES('AL019','AS008',1.12);
INSERT INTO matricula VALUES('AL019','AS009',4.73);
INSERT INTO matricula VALUES('AL019','AS010',1.48);
INSERT INTO matricula VALUES('AL045','AS001',5.84);
INSERT INTO matricula VALUES('AL045','AS002',2.24);
INSERT INTO matricula VALUES('AL045','AS003',7.42);
INSERT INTO matricula VALUES('AL045','AS004',3.76);
INSERT INTO matricula VALUES('AL045','AS005',6.41);
INSERT INTO matricula VALUES('AL045','AS006',8.43);
INSERT INTO matricula VALUES('AL045','AS007',10);
INSERT INTO matricula VALUES('AL045','AS008',10);
INSERT INTO matricula VALUES('AL045','AS009',1.22);
INSERT INTO matricula VALUES('AL045','AS010',7.47);
INSERT INTO matricula VALUES('AL052','AS001',3.56);
INSERT INTO matricula VALUES('AL052','AS002',7.23);
INSERT INTO matricula VALUES('AL052','AS003',3.83);
INSERT INTO matricula VALUES('AL052','AS004',2.43);
INSERT INTO matricula VALUES('AL052','AS005',7.68);
INSERT INTO matricula VALUES('AL052','AS006',1.01);
INSERT INTO matricula VALUES('AL052','AS007',3.63);
INSERT INTO matricula VALUES('AL052','AS008',6.26);
INSERT INTO matricula VALUES('AL052','AS009',10);
INSERT INTO matricula VALUES('AL052','AS010',7.67);
INSERT INTO matricula VALUES('AL058','AS001',8.84);
INSERT INTO matricula VALUES('AL058','AS002',1.66);
INSERT INTO matricula VALUES('AL058','AS003',7.07);
INSERT INTO matricula VALUES('AL058','AS004',10);
INSERT INTO matricula VALUES('AL058','AS005',8.71);
INSERT INTO matricula VALUES('AL058','AS006',5.32);
INSERT INTO matricula VALUES('AL058','AS007',1.46);
INSERT INTO matricula VALUES('AL058','AS008',7.02);
INSERT INTO matricula VALUES('AL058','AS009',3.75);
INSERT INTO matricula VALUES('AL058','AS010',5.83);
INSERT INTO matricula VALUES('AL069','AS001',10);
INSERT INTO matricula VALUES('AL069','AS002',6.95);
INSERT INTO matricula VALUES('AL069','AS003',9.83);
INSERT INTO matricula VALUES('AL069','AS004',9.35);
INSERT INTO matricula VALUES('AL069','AS005',8.93);
INSERT INTO matricula VALUES('AL069','AS006',1.59);
INSERT INTO matricula VALUES('AL069','AS007',7.99);
INSERT INTO matricula VALUES('AL069','AS008',6.51);
INSERT INTO matricula VALUES('AL069','AS009',2.58);
INSERT INTO matricula VALUES('AL069','AS010',2.78);
INSERT INTO matricula VALUES('AL076','AS001',7.56);
INSERT INTO matricula VALUES('AL076','AS002',7.51);
INSERT INTO matricula VALUES('AL076','AS003',8.63);
INSERT INTO matricula VALUES('AL076','AS004',8.88);
INSERT INTO matricula VALUES('AL076','AS005',6.78);
INSERT INTO matricula VALUES('AL076','AS006',5.01);
INSERT INTO matricula VALUES('AL076','AS007',9.19);
INSERT INTO matricula VALUES('AL076','AS008',3.53);
INSERT INTO matricula VALUES('AL076','AS009',10);
INSERT INTO matricula VALUES('AL076','AS010',8.99);
INSERT INTO matricula VALUES('AL081','AS001',7.21);
INSERT INTO matricula VALUES('AL081','AS002',3.09);
INSERT INTO matricula VALUES('AL081','AS003',9.84);
INSERT INTO matricula VALUES('AL081','AS004',5.52);
INSERT INTO matricula VALUES('AL081','AS005',1.46);
INSERT INTO matricula VALUES('AL081','AS006',4.09);
INSERT INTO matricula VALUES('AL081','AS007',9.87);
INSERT INTO matricula VALUES('AL081','AS008',10);
INSERT INTO matricula VALUES('AL081','AS009',6.24);
INSERT INTO matricula VALUES('AL081','AS010',8.89);
INSERT INTO matricula VALUES('AL090','AS001',8.12);
INSERT INTO matricula VALUES('AL090','AS002',6.86);
INSERT INTO matricula VALUES('AL090','AS003',1.85);
INSERT INTO matricula VALUES('AL090','AS004',4.43);
INSERT INTO matricula VALUES('AL090','AS005',1.44);
INSERT INTO matricula VALUES('AL090','AS006',1.49);
INSERT INTO matricula VALUES('AL090','AS007',6.58);
INSERT INTO matricula VALUES('AL090','AS008',3.36);
INSERT INTO matricula VALUES('AL090','AS009',7.52);
INSERT INTO matricula VALUES('AL090','AS010',2.32);
INSERT INTO matricula VALUES('AL092','AS001',7.99);
INSERT INTO matricula VALUES('AL092','AS002',2.12);
INSERT INTO matricula VALUES('AL092','AS003',6.15);
INSERT INTO matricula VALUES('AL092','AS004',9.99);
INSERT INTO matricula VALUES('AL092','AS005',3.54);
INSERT INTO matricula VALUES('AL092','AS006',4.83);
INSERT INTO matricula VALUES('AL092','AS007',1.46);
INSERT INTO matricula VALUES('AL092','AS008',6.88);
INSERT INTO matricula VALUES('AL092','AS009',6.22);
INSERT INTO matricula VALUES('AL092','AS010',2.29);
INSERT INTO matricula VALUES('AL103','AS001',7.88);
INSERT INTO matricula VALUES('AL103','AS002',5.39);
INSERT INTO matricula VALUES('AL103','AS003',7.17);
INSERT INTO matricula VALUES('AL103','AS004',7.62);
INSERT INTO matricula VALUES('AL103','AS005',3.25);
INSERT INTO matricula VALUES('AL103','AS006',7.91);
INSERT INTO matricula VALUES('AL103','AS007',3.72);
INSERT INTO matricula VALUES('AL103','AS008',2.22);
INSERT INTO matricula VALUES('AL103','AS009',6.77);
INSERT INTO matricula VALUES('AL103','AS010',8.06);
INSERT INTO matricula VALUES('AL104','AS001',7.28);
INSERT INTO matricula VALUES('AL104','AS002',1.76);
INSERT INTO matricula VALUES('AL104','AS003',8.54);
INSERT INTO matricula VALUES('AL104','AS004',6.74);
INSERT INTO matricula VALUES('AL104','AS005',6.76);
INSERT INTO matricula VALUES('AL104','AS006',4.18);
INSERT INTO matricula VALUES('AL104','AS007',1.46);
INSERT INTO matricula VALUES('AL104','AS008',4.13);
INSERT INTO matricula VALUES('AL104','AS009',2.95);
INSERT INTO matricula VALUES('AL104','AS010',10);
INSERT INTO matricula VALUES('AL108','AS001',1.02);
INSERT INTO matricula VALUES('AL108','AS002',3.47);
INSERT INTO matricula VALUES('AL108','AS003',2.83);
INSERT INTO matricula VALUES('AL108','AS004',5.09);
INSERT INTO matricula VALUES('AL108','AS005',1.94);
INSERT INTO matricula VALUES('AL108','AS006',2.28);
INSERT INTO matricula VALUES('AL108','AS007',7.63);
INSERT INTO matricula VALUES('AL108','AS008',6.25);
INSERT INTO matricula VALUES('AL108','AS009',1.47);
INSERT INTO matricula VALUES('AL108','AS010',10);
INSERT INTO matricula VALUES('AL118','AS001',5.45);
INSERT INTO matricula VALUES('AL118','AS002',5.91);
INSERT INTO matricula VALUES('AL118','AS003',3.29);
INSERT INTO matricula VALUES('AL118','AS004',8.89);
INSERT INTO matricula VALUES('AL118','AS005',8.03);
INSERT INTO matricula VALUES('AL118','AS006',2.45);
INSERT INTO matricula VALUES('AL118','AS007',10);
INSERT INTO matricula VALUES('AL118','AS008',9.37);
INSERT INTO matricula VALUES('AL118','AS009',7.63);
INSERT INTO matricula VALUES('AL118','AS010',7.08);
INSERT INTO matricula VALUES('AL132','AS001',6.93);
INSERT INTO matricula VALUES('AL132','AS002',8.83);
INSERT INTO matricula VALUES('AL132','AS003',6.51);
INSERT INTO matricula VALUES('AL132','AS004',8.31);
INSERT INTO matricula VALUES('AL132','AS005',3.37);
INSERT INTO matricula VALUES('AL132','AS006',6.65);
INSERT INTO matricula VALUES('AL132','AS007',6.25);
INSERT INTO matricula VALUES('AL132','AS008',4.54);
INSERT INTO matricula VALUES('AL132','AS009',8.88);
INSERT INTO matricula VALUES('AL132','AS010',2.29);
INSERT INTO matricula VALUES('AL138','AS001',1.78);
INSERT INTO matricula VALUES('AL138','AS002',6.12);
INSERT INTO matricula VALUES('AL138','AS003',6.95);
INSERT INTO matricula VALUES('AL138','AS004',8.63);
INSERT INTO matricula VALUES('AL138','AS005',1.38);
INSERT INTO matricula VALUES('AL138','AS006',4.67);
INSERT INTO matricula VALUES('AL138','AS007',10);
INSERT INTO matricula VALUES('AL138','AS008',7.01);
INSERT INTO matricula VALUES('AL138','AS009',8.86);
INSERT INTO matricula VALUES('AL138','AS010',5.75);
INSERT INTO matricula VALUES('AL142','AS001',3.65);
INSERT INTO matricula VALUES('AL142','AS002',9.84);
INSERT INTO matricula VALUES('AL142','AS003',10);
INSERT INTO matricula VALUES('AL142','AS004',1.46);
INSERT INTO matricula VALUES('AL142','AS005',7.31);
INSERT INTO matricula VALUES('AL142','AS006',3.72);
INSERT INTO matricula VALUES('AL142','AS007',1.71);
INSERT INTO matricula VALUES('AL142','AS008',2.96);
INSERT INTO matricula VALUES('AL142','AS009',2.01);
INSERT INTO matricula VALUES('AL142','AS010',5.49);
INSERT INTO matricula VALUES('AL147','AS001',1.28);
INSERT INTO matricula VALUES('AL147','AS002',3.81);
INSERT INTO matricula VALUES('AL147','AS003',7.32);
INSERT INTO matricula VALUES('AL147','AS004',10);
INSERT INTO matricula VALUES('AL147','AS005',2.56);
INSERT INTO matricula VALUES('AL147','AS006',4.52);
INSERT INTO matricula VALUES('AL147','AS007',9.48);
INSERT INTO matricula VALUES('AL147','AS008',2.87);
INSERT INTO matricula VALUES('AL147','AS009',3.47);
INSERT INTO matricula VALUES('AL147','AS010',5.99);
INSERT INTO matricula VALUES('AL165','AS001',3.89);
INSERT INTO matricula VALUES('AL165','AS002',2.14);
INSERT INTO matricula VALUES('AL165','AS003',1.76);
INSERT INTO matricula VALUES('AL165','AS004',1.79);
INSERT INTO matricula VALUES('AL165','AS005',10);
INSERT INTO matricula VALUES('AL165','AS006',4.95);
INSERT INTO matricula VALUES('AL165','AS007',4.81);
INSERT INTO matricula VALUES('AL165','AS008',8.36);
INSERT INTO matricula VALUES('AL165','AS009',3.62);
INSERT INTO matricula VALUES('AL165','AS010',3.24);
INSERT INTO matricula VALUES('AL187','AS001',8.49);
INSERT INTO matricula VALUES('AL187','AS002',5.53);
INSERT INTO matricula VALUES('AL187','AS003',2.32);
INSERT INTO matricula VALUES('AL187','AS004',6.19);
INSERT INTO matricula VALUES('AL187','AS005',7.19);
INSERT INTO matricula VALUES('AL187','AS006',8.71);
INSERT INTO matricula VALUES('AL187','AS007',1.18);
INSERT INTO matricula VALUES('AL187','AS008',5.37);
INSERT INTO matricula VALUES('AL187','AS009',3.33);
INSERT INTO matricula VALUES('AL187','AS010',3.51);
INSERT INTO matricula VALUES('AL189','AS001',6.54);
INSERT INTO matricula VALUES('AL189','AS002',7.06);
INSERT INTO matricula VALUES('AL189','AS003',7.67);
INSERT INTO matricula VALUES('AL189','AS004',4.41);
INSERT INTO matricula VALUES('AL189','AS005',1.27);
INSERT INTO matricula VALUES('AL189','AS006',9.19);
INSERT INTO matricula VALUES('AL189','AS007',2.88);
INSERT INTO matricula VALUES('AL189','AS008',3.07);
INSERT INTO matricula VALUES('AL189','AS009',2.99);
INSERT INTO matricula VALUES('AL189','AS010',6.38);
INSERT INTO matricula VALUES('AL194','AS001',3.27);
INSERT INTO matricula VALUES('AL194','AS002',4.34);
INSERT INTO matricula VALUES('AL194','AS003',1.26);
INSERT INTO matricula VALUES('AL194','AS004',3.42);
INSERT INTO matricula VALUES('AL194','AS005',1.72);
INSERT INTO matricula VALUES('AL194','AS006',1.46);
INSERT INTO matricula VALUES('AL194','AS007',2.94);
INSERT INTO matricula VALUES('AL194','AS008',9.34);
INSERT INTO matricula VALUES('AL194','AS009',8.87);
INSERT INTO matricula VALUES('AL194','AS010',5.98);
INSERT INTO matricula VALUES('AL007','AS011',2.16);
INSERT INTO matricula VALUES('AL007','AS012',4.21);
INSERT INTO matricula VALUES('AL007','AS013',9.42);
INSERT INTO matricula VALUES('AL007','AS014',10);
INSERT INTO matricula VALUES('AL007','AS015',9.11);
INSERT INTO matricula VALUES('AL007','AS016',9.83);
INSERT INTO matricula VALUES('AL007','AS017',6.95);
INSERT INTO matricula VALUES('AL007','AS018',9.67);
INSERT INTO matricula VALUES('AL007','AS019',8.42);
INSERT INTO matricula VALUES('AL007','AS020',9.15);
INSERT INTO matricula VALUES('AL010','AS011',9.68);
INSERT INTO matricula VALUES('AL010','AS012',5.57);
INSERT INTO matricula VALUES('AL010','AS013',3.31);
INSERT INTO matricula VALUES('AL010','AS014',1.86);
INSERT INTO matricula VALUES('AL010','AS015',3.47);
INSERT INTO matricula VALUES('AL010','AS016',8.38);
INSERT INTO matricula VALUES('AL010','AS017',10);
INSERT INTO matricula VALUES('AL010','AS018',5.67);
INSERT INTO matricula VALUES('AL010','AS019',6.02);
INSERT INTO matricula VALUES('AL010','AS020',2.07);
INSERT INTO matricula VALUES('AL011','AS011',9.81);
INSERT INTO matricula VALUES('AL011','AS012',1.54);
INSERT INTO matricula VALUES('AL011','AS013',9.76);
INSERT INTO matricula VALUES('AL011','AS014',6.32);
INSERT INTO matricula VALUES('AL011','AS015',5.64);
INSERT INTO matricula VALUES('AL011','AS016',1.07);
INSERT INTO matricula VALUES('AL011','AS017',3.63);
INSERT INTO matricula VALUES('AL011','AS018',9.08);
INSERT INTO matricula VALUES('AL011','AS019',5.45);
INSERT INTO matricula VALUES('AL011','AS020',8.06);
INSERT INTO matricula VALUES('AL025','AS011',2.26);
INSERT INTO matricula VALUES('AL025','AS012',3.69);
INSERT INTO matricula VALUES('AL025','AS013',7.39);
INSERT INTO matricula VALUES('AL025','AS014',2.45);
INSERT INTO matricula VALUES('AL025','AS015',2.34);
INSERT INTO matricula VALUES('AL025','AS016',8.68);
INSERT INTO matricula VALUES('AL025','AS017',1.81);
INSERT INTO matricula VALUES('AL025','AS018',5.31);
INSERT INTO matricula VALUES('AL025','AS019',7.62);
INSERT INTO matricula VALUES('AL025','AS020',6.67);
INSERT INTO matricula VALUES('AL027','AS011',1.39);
INSERT INTO matricula VALUES('AL027','AS012',4.26);
INSERT INTO matricula VALUES('AL027','AS013',8.43);
INSERT INTO matricula VALUES('AL027','AS014',9.12);
INSERT INTO matricula VALUES('AL027','AS015',2.07);
INSERT INTO matricula VALUES('AL027','AS016',6.57);
INSERT INTO matricula VALUES('AL027','AS017',3.02);
INSERT INTO matricula VALUES('AL027','AS018',7.38);
INSERT INTO matricula VALUES('AL027','AS019',10);
INSERT INTO matricula VALUES('AL027','AS020',10);
INSERT INTO matricula VALUES('AL030','AS011',7.97);
INSERT INTO matricula VALUES('AL030','AS012',7.51);
INSERT INTO matricula VALUES('AL030','AS013',3.49);
INSERT INTO matricula VALUES('AL030','AS014',1.52);
INSERT INTO matricula VALUES('AL030','AS015',6.47);
INSERT INTO matricula VALUES('AL030','AS016',2.18);
INSERT INTO matricula VALUES('AL030','AS017',8.23);
INSERT INTO matricula VALUES('AL030','AS018',5.86);
INSERT INTO matricula VALUES('AL030','AS019',9.22);
INSERT INTO matricula VALUES('AL030','AS020',3.74);
INSERT INTO matricula VALUES('AL051','AS011',10);
INSERT INTO matricula VALUES('AL051','AS012',3.24);
INSERT INTO matricula VALUES('AL051','AS013',6.96);
INSERT INTO matricula VALUES('AL051','AS014',3.23);
INSERT INTO matricula VALUES('AL051','AS015',10);
INSERT INTO matricula VALUES('AL051','AS016',10);
INSERT INTO matricula VALUES('AL051','AS017',6.01);
INSERT INTO matricula VALUES('AL051','AS018',10);
INSERT INTO matricula VALUES('AL051','AS019',8.18);
INSERT INTO matricula VALUES('AL051','AS020',9.65);
INSERT INTO matricula VALUES('AL054','AS011',5.43);
INSERT INTO matricula VALUES('AL054','AS012',5.59);
INSERT INTO matricula VALUES('AL054','AS013',10);
INSERT INTO matricula VALUES('AL054','AS014',7.57);
INSERT INTO matricula VALUES('AL054','AS015',5.07);
INSERT INTO matricula VALUES('AL054','AS016',8.32);
INSERT INTO matricula VALUES('AL054','AS017',3.55);
INSERT INTO matricula VALUES('AL054','AS018',5.06);
INSERT INTO matricula VALUES('AL054','AS019',1.58);
INSERT INTO matricula VALUES('AL054','AS020',2.21);
INSERT INTO matricula VALUES('AL064','AS011',10);
INSERT INTO matricula VALUES('AL064','AS012',6.72);
INSERT INTO matricula VALUES('AL064','AS013',1.19);
INSERT INTO matricula VALUES('AL064','AS014',3.06);
INSERT INTO matricula VALUES('AL064','AS015',6.52);
INSERT INTO matricula VALUES('AL064','AS016',1.72);
INSERT INTO matricula VALUES('AL064','AS017',8.14);
INSERT INTO matricula VALUES('AL064','AS018',10);
INSERT INTO matricula VALUES('AL064','AS019',10);
INSERT INTO matricula VALUES('AL064','AS020',8.66);
INSERT INTO matricula VALUES('AL079','AS011',9.64);
INSERT INTO matricula VALUES('AL079','AS012',4.03);
INSERT INTO matricula VALUES('AL079','AS013',9.06);
INSERT INTO matricula VALUES('AL079','AS014',9.83);
INSERT INTO matricula VALUES('AL079','AS015',9.51);
INSERT INTO matricula VALUES('AL079','AS016',1.39);
INSERT INTO matricula VALUES('AL079','AS017',2.87);
INSERT INTO matricula VALUES('AL079','AS018',4.88);
INSERT INTO matricula VALUES('AL079','AS019',5.31);
INSERT INTO matricula VALUES('AL079','AS020',6.57);
INSERT INTO matricula VALUES('AL099','AS011',6.12);
INSERT INTO matricula VALUES('AL099','AS012',10);
INSERT INTO matricula VALUES('AL099','AS013',6.07);
INSERT INTO matricula VALUES('AL099','AS014',10);
INSERT INTO matricula VALUES('AL099','AS015',8.53);
INSERT INTO matricula VALUES('AL099','AS016',2.46);
INSERT INTO matricula VALUES('AL099','AS017',6.84);
INSERT INTO matricula VALUES('AL099','AS018',5.31);
INSERT INTO matricula VALUES('AL099','AS019',4.35);
INSERT INTO matricula VALUES('AL099','AS020',7.77);
INSERT INTO matricula VALUES('AL100','AS011',1.48);
INSERT INTO matricula VALUES('AL100','AS012',7.41);
INSERT INTO matricula VALUES('AL100','AS013',3.16);
INSERT INTO matricula VALUES('AL100','AS014',7.65);
INSERT INTO matricula VALUES('AL100','AS015',2.15);
INSERT INTO matricula VALUES('AL100','AS016',1.91);
INSERT INTO matricula VALUES('AL100','AS017',7.05);
INSERT INTO matricula VALUES('AL100','AS018',2.05);
INSERT INTO matricula VALUES('AL100','AS019',1.11);
INSERT INTO matricula VALUES('AL100','AS020',4.76);
INSERT INTO matricula VALUES('AL101','AS011',7.21);
INSERT INTO matricula VALUES('AL101','AS012',6.14);
INSERT INTO matricula VALUES('AL101','AS013',4.09);
INSERT INTO matricula VALUES('AL101','AS014',8.85);
INSERT INTO matricula VALUES('AL101','AS015',9.82);
INSERT INTO matricula VALUES('AL101','AS016',5.87);
INSERT INTO matricula VALUES('AL101','AS017',3.63);
INSERT INTO matricula VALUES('AL101','AS018',1.67);
INSERT INTO matricula VALUES('AL101','AS019',4.99);
INSERT INTO matricula VALUES('AL101','AS020',5.89);
INSERT INTO matricula VALUES('AL102','AS011',8.75);
INSERT INTO matricula VALUES('AL102','AS012',4.32);
INSERT INTO matricula VALUES('AL102','AS013',5.44);
INSERT INTO matricula VALUES('AL102','AS014',9.06);
INSERT INTO matricula VALUES('AL102','AS015',4.32);
INSERT INTO matricula VALUES('AL102','AS016',5.58);
INSERT INTO matricula VALUES('AL102','AS017',3.38);
INSERT INTO matricula VALUES('AL102','AS018',4.67);
INSERT INTO matricula VALUES('AL102','AS019',3.54);
INSERT INTO matricula VALUES('AL102','AS020',4.32);
INSERT INTO matricula VALUES('AL106','AS011',5.09);
INSERT INTO matricula VALUES('AL106','AS012',2.13);
INSERT INTO matricula VALUES('AL106','AS013',9.86);
INSERT INTO matricula VALUES('AL106','AS014',4.73);
INSERT INTO matricula VALUES('AL106','AS015',1.25);
INSERT INTO matricula VALUES('AL106','AS016',3.05);
INSERT INTO matricula VALUES('AL106','AS017',4.85);
INSERT INTO matricula VALUES('AL106','AS018',9.61);
INSERT INTO matricula VALUES('AL106','AS019',4.95);
INSERT INTO matricula VALUES('AL106','AS020',8.53);
INSERT INTO matricula VALUES('AL112','AS011',4.22);
INSERT INTO matricula VALUES('AL112','AS012',2.26);
INSERT INTO matricula VALUES('AL112','AS013',4.75);
INSERT INTO matricula VALUES('AL112','AS014',9.89);
INSERT INTO matricula VALUES('AL112','AS015',5.25);
INSERT INTO matricula VALUES('AL112','AS016',1.39);
INSERT INTO matricula VALUES('AL112','AS017',8.07);
INSERT INTO matricula VALUES('AL112','AS018',10);
INSERT INTO matricula VALUES('AL112','AS019',5.37);
INSERT INTO matricula VALUES('AL112','AS020',6.74);
INSERT INTO matricula VALUES('AL113','AS011',6.93);
INSERT INTO matricula VALUES('AL113','AS012',4.81);
INSERT INTO matricula VALUES('AL113','AS013',2.25);
INSERT INTO matricula VALUES('AL113','AS014',1.65);
INSERT INTO matricula VALUES('AL113','AS015',4.42);
INSERT INTO matricula VALUES('AL113','AS016',1.81);
INSERT INTO matricula VALUES('AL113','AS017',8.76);
INSERT INTO matricula VALUES('AL113','AS018',2.08);
INSERT INTO matricula VALUES('AL113','AS019',3.95);
INSERT INTO matricula VALUES('AL113','AS020',6.14);
INSERT INTO matricula VALUES('AL119','AS011',10);
INSERT INTO matricula VALUES('AL119','AS012',4.85);
INSERT INTO matricula VALUES('AL119','AS013',10);
INSERT INTO matricula VALUES('AL119','AS014',1.84);
INSERT INTO matricula VALUES('AL119','AS015',4.11);
INSERT INTO matricula VALUES('AL119','AS016',5.68);
INSERT INTO matricula VALUES('AL119','AS017',3.53);
INSERT INTO matricula VALUES('AL119','AS018',2.17);
INSERT INTO matricula VALUES('AL119','AS019',8.75);
INSERT INTO matricula VALUES('AL119','AS020',9.61);
INSERT INTO matricula VALUES('AL123','AS011',5.16);
INSERT INTO matricula VALUES('AL123','AS012',6.29);
INSERT INTO matricula VALUES('AL123','AS013',2.92);
INSERT INTO matricula VALUES('AL123','AS014',9.07);
INSERT INTO matricula VALUES('AL123','AS015',1.81);
INSERT INTO matricula VALUES('AL123','AS016',1.09);
INSERT INTO matricula VALUES('AL123','AS017',4.82);
INSERT INTO matricula VALUES('AL123','AS018',3.92);
INSERT INTO matricula VALUES('AL123','AS019',9.38);
INSERT INTO matricula VALUES('AL123','AS020',8.21);
INSERT INTO matricula VALUES('AL131','AS011',3.77);
INSERT INTO matricula VALUES('AL131','AS012',1.82);
INSERT INTO matricula VALUES('AL131','AS013',2.38);
INSERT INTO matricula VALUES('AL131','AS014',9.03);
INSERT INTO matricula VALUES('AL131','AS015',2.03);
INSERT INTO matricula VALUES('AL131','AS016',10);
INSERT INTO matricula VALUES('AL131','AS017',1.85);
INSERT INTO matricula VALUES('AL131','AS018',8.86);
INSERT INTO matricula VALUES('AL131','AS019',6.82);
INSERT INTO matricula VALUES('AL131','AS020',4.23);
INSERT INTO matricula VALUES('AL152','AS011',3.27);
INSERT INTO matricula VALUES('AL152','AS012',7.17);
INSERT INTO matricula VALUES('AL152','AS013',6.17);
INSERT INTO matricula VALUES('AL152','AS014',9.97);
INSERT INTO matricula VALUES('AL152','AS015',1.35);
INSERT INTO matricula VALUES('AL152','AS016',6.46);
INSERT INTO matricula VALUES('AL152','AS017',10);
INSERT INTO matricula VALUES('AL152','AS018',4.05);
INSERT INTO matricula VALUES('AL152','AS019',2.79);
INSERT INTO matricula VALUES('AL152','AS020',7.02);
INSERT INTO matricula VALUES('AL154','AS011',8.41);
INSERT INTO matricula VALUES('AL154','AS012',7.78);
INSERT INTO matricula VALUES('AL154','AS013',4.25);
INSERT INTO matricula VALUES('AL154','AS014',4.36);
INSERT INTO matricula VALUES('AL154','AS015',9.79);
INSERT INTO matricula VALUES('AL154','AS016',3.08);
INSERT INTO matricula VALUES('AL154','AS017',9.52);
INSERT INTO matricula VALUES('AL154','AS018',5.38);
INSERT INTO matricula VALUES('AL154','AS019',4.14);
INSERT INTO matricula VALUES('AL154','AS020',9.21);
INSERT INTO matricula VALUES('AL160','AS011',10);
INSERT INTO matricula VALUES('AL160','AS012',7.93);
INSERT INTO matricula VALUES('AL160','AS013',1.89);
INSERT INTO matricula VALUES('AL160','AS014',2.23);
INSERT INTO matricula VALUES('AL160','AS015',8.32);
INSERT INTO matricula VALUES('AL160','AS016',3.01);
INSERT INTO matricula VALUES('AL160','AS017',4.59);
INSERT INTO matricula VALUES('AL160','AS018',10);
INSERT INTO matricula VALUES('AL160','AS019',2.82);
INSERT INTO matricula VALUES('AL160','AS020',4.21);
INSERT INTO matricula VALUES('AL161','AS011',4.85);
INSERT INTO matricula VALUES('AL161','AS012',7.11);
INSERT INTO matricula VALUES('AL161','AS013',3.37);
INSERT INTO matricula VALUES('AL161','AS014',2.26);
INSERT INTO matricula VALUES('AL161','AS015',4.99);
INSERT INTO matricula VALUES('AL161','AS016',10);
INSERT INTO matricula VALUES('AL161','AS017',9.13);
INSERT INTO matricula VALUES('AL161','AS018',4.58);
INSERT INTO matricula VALUES('AL161','AS019',7.57);
INSERT INTO matricula VALUES('AL161','AS020',6.87);
INSERT INTO matricula VALUES('AL166','AS011',5.17);
INSERT INTO matricula VALUES('AL166','AS012',1.27);
INSERT INTO matricula VALUES('AL166','AS013',6.77);
INSERT INTO matricula VALUES('AL166','AS014',7.22);
INSERT INTO matricula VALUES('AL166','AS015',1.18);
INSERT INTO matricula VALUES('AL166','AS016',10);
INSERT INTO matricula VALUES('AL166','AS017',7.94);
INSERT INTO matricula VALUES('AL166','AS018',9.51);
INSERT INTO matricula VALUES('AL166','AS019',7.45);
INSERT INTO matricula VALUES('AL166','AS020',7.21);
INSERT INTO matricula VALUES('AL167','AS011',3.92);
INSERT INTO matricula VALUES('AL167','AS012',3.25);
INSERT INTO matricula VALUES('AL167','AS013',2.12);
INSERT INTO matricula VALUES('AL167','AS014',2.96);
INSERT INTO matricula VALUES('AL167','AS015',7.06);
INSERT INTO matricula VALUES('AL167','AS016',8.39);
INSERT INTO matricula VALUES('AL167','AS017',9.39);
INSERT INTO matricula VALUES('AL167','AS018',8.02);
INSERT INTO matricula VALUES('AL167','AS019',7.84);
INSERT INTO matricula VALUES('AL167','AS020',6.27);
INSERT INTO matricula VALUES('AL170','AS011',3.69);
INSERT INTO matricula VALUES('AL170','AS012',2.15);
INSERT INTO matricula VALUES('AL170','AS013',8.15);
INSERT INTO matricula VALUES('AL170','AS014',5.69);
INSERT INTO matricula VALUES('AL170','AS015',6.31);
INSERT INTO matricula VALUES('AL170','AS016',5.18);
INSERT INTO matricula VALUES('AL170','AS017',9.61);
INSERT INTO matricula VALUES('AL170','AS018',2.79);
INSERT INTO matricula VALUES('AL170','AS019',7.01);
INSERT INTO matricula VALUES('AL170','AS020',4.44);
INSERT INTO matricula VALUES('AL177','AS011',6.03);
INSERT INTO matricula VALUES('AL177','AS012',1.88);
INSERT INTO matricula VALUES('AL177','AS013',3.38);
INSERT INTO matricula VALUES('AL177','AS014',6.22);
INSERT INTO matricula VALUES('AL177','AS015',8.16);
INSERT INTO matricula VALUES('AL177','AS016',5.16);
INSERT INTO matricula VALUES('AL177','AS017',2.45);
INSERT INTO matricula VALUES('AL177','AS018',3.63);
INSERT INTO matricula VALUES('AL177','AS019',2.37);
INSERT INTO matricula VALUES('AL177','AS020',4.59);
INSERT INTO matricula VALUES('AL185','AS011',1.02);
INSERT INTO matricula VALUES('AL185','AS012',1.48);
INSERT INTO matricula VALUES('AL185','AS013',10);
INSERT INTO matricula VALUES('AL185','AS014',9.73);
INSERT INTO matricula VALUES('AL185','AS015',10);
INSERT INTO matricula VALUES('AL185','AS016',6.73);
INSERT INTO matricula VALUES('AL185','AS017',9.31);
INSERT INTO matricula VALUES('AL185','AS018',8.77);
INSERT INTO matricula VALUES('AL185','AS019',1.26);
INSERT INTO matricula VALUES('AL185','AS020',10);
INSERT INTO matricula VALUES('AL193','AS011',4.96);
INSERT INTO matricula VALUES('AL193','AS012',7.22);
INSERT INTO matricula VALUES('AL193','AS013',2.35);
INSERT INTO matricula VALUES('AL193','AS014',10);
INSERT INTO matricula VALUES('AL193','AS015',6.79);
INSERT INTO matricula VALUES('AL193','AS016',10);
INSERT INTO matricula VALUES('AL193','AS017',10);
INSERT INTO matricula VALUES('AL193','AS018',3.95);
INSERT INTO matricula VALUES('AL193','AS019',9.58);
INSERT INTO matricula VALUES('AL193','AS020',8.64);
INSERT INTO matricula VALUES('AL197','AS011',7.59);
INSERT INTO matricula VALUES('AL197','AS012',3.07);
INSERT INTO matricula VALUES('AL197','AS013',10);
INSERT INTO matricula VALUES('AL197','AS014',6.75);
INSERT INTO matricula VALUES('AL197','AS015',8.77);
INSERT INTO matricula VALUES('AL197','AS016',5.16);
INSERT INTO matricula VALUES('AL197','AS017',1.06);
INSERT INTO matricula VALUES('AL197','AS018',6.88);
INSERT INTO matricula VALUES('AL197','AS019',7.92);
INSERT INTO matricula VALUES('AL197','AS020',1.88);
INSERT INTO matricula VALUES('AL004','AS021',4.23);
INSERT INTO matricula VALUES('AL004','AS022',9.65);
INSERT INTO matricula VALUES('AL004','AS023',7.75);
INSERT INTO matricula VALUES('AL004','AS024',5.76);
INSERT INTO matricula VALUES('AL004','AS025',3.43);
INSERT INTO matricula VALUES('AL004','AS026',6.95);
INSERT INTO matricula VALUES('AL004','AS027',6.91);
INSERT INTO matricula VALUES('AL004','AS028',9.76);
INSERT INTO matricula VALUES('AL004','AS029',10);
INSERT INTO matricula VALUES('AL004','AS030',4.44);
INSERT INTO matricula VALUES('AL008','AS021',8.29);
INSERT INTO matricula VALUES('AL008','AS022',4.43);
INSERT INTO matricula VALUES('AL008','AS023',4.37);
INSERT INTO matricula VALUES('AL008','AS024',5.02);
INSERT INTO matricula VALUES('AL008','AS025',8.84);
INSERT INTO matricula VALUES('AL008','AS026',4.24);
INSERT INTO matricula VALUES('AL008','AS027',8.02);
INSERT INTO matricula VALUES('AL008','AS028',4.22);
INSERT INTO matricula VALUES('AL008','AS029',9.28);
INSERT INTO matricula VALUES('AL008','AS030',6.18);
INSERT INTO matricula VALUES('AL028','AS021',6.86);
INSERT INTO matricula VALUES('AL028','AS022',8.27);
INSERT INTO matricula VALUES('AL028','AS023',8.17);
INSERT INTO matricula VALUES('AL028','AS024',6.23);
INSERT INTO matricula VALUES('AL028','AS025',3.09);
INSERT INTO matricula VALUES('AL028','AS026',7.93);
INSERT INTO matricula VALUES('AL028','AS027',3.48);
INSERT INTO matricula VALUES('AL028','AS028',2.78);
INSERT INTO matricula VALUES('AL028','AS029',4.48);
INSERT INTO matricula VALUES('AL028','AS030',8.44);
INSERT INTO matricula VALUES('AL031','AS021',8.81);
INSERT INTO matricula VALUES('AL031','AS022',10);
INSERT INTO matricula VALUES('AL031','AS023',9.58);
INSERT INTO matricula VALUES('AL031','AS024',9.96);
INSERT INTO matricula VALUES('AL031','AS025',8.89);
INSERT INTO matricula VALUES('AL031','AS026',3.94);
INSERT INTO matricula VALUES('AL031','AS027',5.14);
INSERT INTO matricula VALUES('AL031','AS028',7.58);
INSERT INTO matricula VALUES('AL031','AS029',9.94);
INSERT INTO matricula VALUES('AL031','AS030',5.68);
INSERT INTO matricula VALUES('AL034','AS021',2.41);
INSERT INTO matricula VALUES('AL034','AS022',4.49);
INSERT INTO matricula VALUES('AL034','AS023',4.23);
INSERT INTO matricula VALUES('AL034','AS024',4.02);
INSERT INTO matricula VALUES('AL034','AS025',4.34);
INSERT INTO matricula VALUES('AL034','AS026',4.95);
INSERT INTO matricula VALUES('AL034','AS027',4.18);
INSERT INTO matricula VALUES('AL034','AS028',7.49);
INSERT INTO matricula VALUES('AL034','AS029',1.48);
INSERT INTO matricula VALUES('AL034','AS030',4.84);
INSERT INTO matricula VALUES('AL043','AS021',7.19);
INSERT INTO matricula VALUES('AL043','AS022',3.09);
INSERT INTO matricula VALUES('AL043','AS023',4.62);
INSERT INTO matricula VALUES('AL043','AS024',2.35);
INSERT INTO matricula VALUES('AL043','AS025',10);
INSERT INTO matricula VALUES('AL043','AS026',2.28);
INSERT INTO matricula VALUES('AL043','AS027',9.61);
INSERT INTO matricula VALUES('AL043','AS028',7.61);
INSERT INTO matricula VALUES('AL043','AS029',4.15);
INSERT INTO matricula VALUES('AL043','AS030',8.44);
INSERT INTO matricula VALUES('AL044','AS021',1.54);
INSERT INTO matricula VALUES('AL044','AS022',4.24);
INSERT INTO matricula VALUES('AL044','AS023',7.81);
INSERT INTO matricula VALUES('AL044','AS024',4.46);
INSERT INTO matricula VALUES('AL044','AS025',2.63);
INSERT INTO matricula VALUES('AL044','AS026',8.25);
INSERT INTO matricula VALUES('AL044','AS027',9.17);
INSERT INTO matricula VALUES('AL044','AS028',2.28);
INSERT INTO matricula VALUES('AL044','AS029',3.54);
INSERT INTO matricula VALUES('AL044','AS030',8.23);
INSERT INTO matricula VALUES('AL047','AS021',9.52);
INSERT INTO matricula VALUES('AL047','AS022',6.64);
INSERT INTO matricula VALUES('AL047','AS023',5.29);
INSERT INTO matricula VALUES('AL047','AS024',2.38);
INSERT INTO matricula VALUES('AL047','AS025',2.89);
INSERT INTO matricula VALUES('AL047','AS026',10);
INSERT INTO matricula VALUES('AL047','AS027',7.09);
INSERT INTO matricula VALUES('AL047','AS028',6.49);
INSERT INTO matricula VALUES('AL047','AS029',10);
INSERT INTO matricula VALUES('AL047','AS030',3.77);
INSERT INTO matricula VALUES('AL050','AS021',7.38);
INSERT INTO matricula VALUES('AL050','AS022',3.84);
INSERT INTO matricula VALUES('AL050','AS023',3.52);
INSERT INTO matricula VALUES('AL050','AS024',8.51);
INSERT INTO matricula VALUES('AL050','AS025',8.61);
INSERT INTO matricula VALUES('AL050','AS026',3.29);
INSERT INTO matricula VALUES('AL050','AS027',8.92);
INSERT INTO matricula VALUES('AL050','AS028',4.82);
INSERT INTO matricula VALUES('AL050','AS029',6.23);
INSERT INTO matricula VALUES('AL050','AS030',8.41);
INSERT INTO matricula VALUES('AL055','AS021',7.06);
INSERT INTO matricula VALUES('AL055','AS022',5.11);
INSERT INTO matricula VALUES('AL055','AS023',6.52);
INSERT INTO matricula VALUES('AL055','AS024',1.57);
INSERT INTO matricula VALUES('AL055','AS025',5.11);
INSERT INTO matricula VALUES('AL055','AS026',6.01);
INSERT INTO matricula VALUES('AL055','AS027',8.09);
INSERT INTO matricula VALUES('AL055','AS028',6.87);
INSERT INTO matricula VALUES('AL055','AS029',6.58);
INSERT INTO matricula VALUES('AL055','AS030',8.19);
INSERT INTO matricula VALUES('AL059','AS021',5.32);
INSERT INTO matricula VALUES('AL059','AS022',8.42);
INSERT INTO matricula VALUES('AL059','AS023',2.42);
INSERT INTO matricula VALUES('AL059','AS024',6.73);
INSERT INTO matricula VALUES('AL059','AS025',7.85);
INSERT INTO matricula VALUES('AL059','AS026',6.41);
INSERT INTO matricula VALUES('AL059','AS027',4.38);
INSERT INTO matricula VALUES('AL059','AS028',1.55);
INSERT INTO matricula VALUES('AL059','AS029',5.98);
INSERT INTO matricula VALUES('AL059','AS030',7.12);
INSERT INTO matricula VALUES('AL071','AS021',1.09);
INSERT INTO matricula VALUES('AL071','AS022',7.36);
INSERT INTO matricula VALUES('AL071','AS023',8.77);
INSERT INTO matricula VALUES('AL071','AS024',1.16);
INSERT INTO matricula VALUES('AL071','AS025',6.57);
INSERT INTO matricula VALUES('AL071','AS026',6.69);
INSERT INTO matricula VALUES('AL071','AS027',10);
INSERT INTO matricula VALUES('AL071','AS028',5.97);
INSERT INTO matricula VALUES('AL071','AS029',8.96);
INSERT INTO matricula VALUES('AL071','AS030',10);
INSERT INTO matricula VALUES('AL072','AS021',8.73);
INSERT INTO matricula VALUES('AL072','AS022',2.77);
INSERT INTO matricula VALUES('AL072','AS023',9.48);
INSERT INTO matricula VALUES('AL072','AS024',3.73);
INSERT INTO matricula VALUES('AL072','AS025',2.78);
INSERT INTO matricula VALUES('AL072','AS026',9.39);
INSERT INTO matricula VALUES('AL072','AS027',3.79);
INSERT INTO matricula VALUES('AL072','AS028',3.91);
INSERT INTO matricula VALUES('AL072','AS029',10);
INSERT INTO matricula VALUES('AL072','AS030',7.68);
INSERT INTO matricula VALUES('AL073','AS021',6.16);
INSERT INTO matricula VALUES('AL073','AS022',1.07);
INSERT INTO matricula VALUES('AL073','AS023',6.88);
INSERT INTO matricula VALUES('AL073','AS024',6.71);
INSERT INTO matricula VALUES('AL073','AS025',5.65);
INSERT INTO matricula VALUES('AL073','AS026',1.56);
INSERT INTO matricula VALUES('AL073','AS027',7.25);
INSERT INTO matricula VALUES('AL073','AS028',6.49);
INSERT INTO matricula VALUES('AL073','AS029',10);
INSERT INTO matricula VALUES('AL073','AS030',9.96);
INSERT INTO matricula VALUES('AL078','AS021',2.55);
INSERT INTO matricula VALUES('AL078','AS022',5.26);
INSERT INTO matricula VALUES('AL078','AS023',10);
INSERT INTO matricula VALUES('AL078','AS024',8.54);
INSERT INTO matricula VALUES('AL078','AS025',10);
INSERT INTO matricula VALUES('AL078','AS026',7.33);
INSERT INTO matricula VALUES('AL078','AS027',10);
INSERT INTO matricula VALUES('AL078','AS028',8.33);
INSERT INTO matricula VALUES('AL078','AS029',9.67);
INSERT INTO matricula VALUES('AL078','AS030',9.41);
INSERT INTO matricula VALUES('AL080','AS021',10);
INSERT INTO matricula VALUES('AL080','AS022',9.79);
INSERT INTO matricula VALUES('AL080','AS023',2.66);
INSERT INTO matricula VALUES('AL080','AS024',4.31);
INSERT INTO matricula VALUES('AL080','AS025',2.06);
INSERT INTO matricula VALUES('AL080','AS026',10);
INSERT INTO matricula VALUES('AL080','AS027',9.78);
INSERT INTO matricula VALUES('AL080','AS028',1.11);
INSERT INTO matricula VALUES('AL080','AS029',9.78);
INSERT INTO matricula VALUES('AL080','AS030',6.94);
INSERT INTO matricula VALUES('AL083','AS021',7.58);
INSERT INTO matricula VALUES('AL083','AS022',8.97);
INSERT INTO matricula VALUES('AL083','AS023',4.07);
INSERT INTO matricula VALUES('AL083','AS024',10);
INSERT INTO matricula VALUES('AL083','AS025',6.61);
INSERT INTO matricula VALUES('AL083','AS026',7.43);
INSERT INTO matricula VALUES('AL083','AS027',6.51);
INSERT INTO matricula VALUES('AL083','AS028',7.78);
INSERT INTO matricula VALUES('AL083','AS029',1.68);
INSERT INTO matricula VALUES('AL083','AS030',9.43);