/*INSERTANDO LICENCIATURAS*/
INSERT INTO licenciatura (clave,nombre) VALUES
("101101","Ingeniería en Computacion"),
("101102","Ingeniería en Electronica"),
("101103","Ingeniería Ambiental"),
("101104","Ingeniería Química");

/*INSERTANDO UEA*/
INSERT INTO uea(clave_uea,nombre,creditos) VALUES
("115102","Nombre UEA 1",9),
("115103","Nombre UEA 2",9),
("115104","Nombre UEA 3",7),
("115105","Nombre UEA 4",12),
("115106","Nombre UEA 5",9);

/*INSERTANDO ALUMNO*/
INSERT INTO alumno(matricula,nombre,primer_apellido,segundo_apellido,licenciatura_clave) VALUES
("12345","Nombre 1","Primero 1","Segundo 1","101101"),
("23456","Nombre 2","Primero 2","Segundo 2","101102"),
("34567","Nombre 3","Primero 3","Segundo 3","101103"),
("45678","Nombre 4","Primero 4","Segundo 4","101104"),
("56789","Nombre 5","Primero 5","Segundo 5","101101"),
("67890","Nombre 6","Primero 6","Segundo 6","101102"),
("78901","Nombre 7","Primero 7","Segundo 7","101103"),
("89012","Nombre 8","Primero 8","Segundo 8","101104"),
("90123","Nombre 9","Primero 9","Segundo 9","101101");


/*INSERTANDO RELACION UEA - ALUMNO*/
INSERT INTO alumno_uea(trimestre,calificacion,calificacion_numerica,alumno_matricula,uea_clave_uea) VALUES
("16P","MB",8.5,"12345","115102"),
("16P","B",8.0,"12345","115103"),
("16P","S",6.5,"12345","115104"),
("16P","MB",9.5,"23456","115103"),
("16P","MB",9.0,"23456","115104"),
("16P","NA",4.5,"23456","115105"),
("16P","S",7.5,"34567","115104"),
("16P","S",6.5,"34567","115105"),
("16P","B",8.2,"34567","115106");

