Microsoft Windows [Versión 10.0.26100.3775] (c) Microsoft Corporation. Todos los derechos reservados. C:\Users\Usuario>cd/xampp/mysql/bin C:\xampp\mysql\bin>mysql -uroot -p} C:\xampp\mysql\bin>mysql -uroot -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 9 Server version: 10.4.32-MariaDB mariadb.org binary distribution Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> create database parcial2; Query OK, 1 row affected (0.003 sec) MariaDB [(none)]> use parcial2; Database changed MariaDB [parcial2]> CREATE TABLE Estudiantes ( -> codigo_estudiante CHAR(8) PRIMARY KEY, -> apellidos_nombres VARCHAR(100) -> ); Query OK, 0 rows affected (0.020 sec) MariaDB [parcial2]> describe estudiantes; +-------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+-------+ | codigo_estudiante | char(8) | NO | PRI | NULL | | | apellidos_nombres | varchar(100) | YES | | NULL | | +-------------------+--------------+------+-----+---------+-------+ 2 rows in set (0.029 sec) MariaDB [parcial2]> CREATE TABLE Asignaturas ( -> codigo_asignatura CHAR(6) PRIMARY KEY, -> nombre_asignatura VARCHAR(100), -> creditos INT, -> nivel_academico VARCHAR(50) -> ); Query OK, 0 rows affected (0.015 sec) MariaDB [parcial2]> describe asignaturas; +-------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+-------+ | codigo_asignatura | char(6) | NO | PRI | NULL | | | nombre_asignatura | varchar(100) | YES | | NULL | | | creditos | int(11) | YES | | NULL | | | nivel_academico | varchar(50) | YES | | NULL | | +-------------------+--------------+------+-----+---------+-------+ 4 rows in set (0.021 sec) MariaDB [parcial2]> CREATE TABLE Asignaturas_Docentes ( -> codigo_asignatura CHAR(6), -> codigo_docente CHAR(8), -> PRIMARY KEY (codigo_asignatura, codigo_docente), -> FOREIGN KEY (codigo_asignatura) REFERENCES Asignaturas(codigo_asignatura), -> FOREIGN KEY (codigo_docente) REFERENCES Docentes(codigo_docente) -> ); MariaDB [parcial2]> CREATE TABLE Docentes ( -> codigo_docente CHAR(8) PRIMARY KEY, -> apellidos_nombres VARCHAR(100), -> especialidad VARCHAR(100), -> telefono VARCHAR(20), -> correo VARCHAR(100) -> ); Query OK, 0 rows affected (0.014 sec) MariaDB [parcial2]> CREATE TABLE Asignaturas_Docentes ( -> codigo_asignatura CHAR(6), -> codigo_docente CHAR(8), -> PRIMARY KEY (codigo_asignatura, codigo_docente), -> FOREIGN KEY (codigo_asignatura) REFERENCES Asignaturas(codigo_asignatura), -> FOREIGN KEY (codigo_docente) REFERENCES Docentes(codigo_docente) -> ); Query OK, 0 rows affected (0.026 sec) MariaDB [parcial2]> describe docentes; +-------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+--------------+------+-----+---------+-------+ | codigo_docente | char(8) | NO | PRI | NULL | | | apellidos_nombres | varchar(100) | YES | | NULL | | | especialidad | varchar(100) | YES | | NULL | | | telefono | varchar(20) | YES | | NULL | | | correo | varchar(100) | YES | | NULL | | +-------------------+--------------+------+-----+---------+-------+ 5 rows in set (0.027 sec) MariaDB [parcial2]> describe asignaturas_docentes; +-------------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------+------+-----+---------+-------+ | codigo_asignatura | char(6) | NO | PRI | NULL | | | codigo_docente | char(8) | NO | PRI | NULL | | +-------------------+---------+------+-----+---------+-------+ 2 rows in set (0.029 sec) MariaDB [parcial2]> CREATE TABLE Notas ( -> codigo_estudiante CHAR(8), -> codigo_asignatura CHAR(6), -> pa1 INT, -> pa2 INT, -> parcial INT, -> pa3 INT, -> pa4 INT, -> final INT, -> PRIMARY KEY (codigo_estudiante, codigo_asignatura), -> FOREIGN KEY (codigo_estudiante) REFERENCES Estudiantes(codigo_estudiante), -> FOREIGN KEY (codigo_asignatura) REFERENCES Asignaturas(codigo_asignatura) -> ); Query OK, 0 rows affected (0.032 sec) MariaDB [parcial2]> describe notas; +-------------------+---------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------+---------+------+-----+---------+-------+ | codigo_estudiante | char(8) | NO | PRI | NULL | | | codigo_asignatura | char(6) | NO | PRI | NULL | | | pa1 | int(11) | YES | | NULL | | | pa2 | int(11) | YES | | NULL | | | parcial | int(11) | YES | | NULL | | | pa3 | int(11) | YES | | NULL | | | pa4 | int(11) | YES | | NULL | | | final | int(11) | YES | | NULL | | +-------------------+---------+------+-----+---------+-------+ 8 rows in set (0.023 sec) MariaDB [parcial2]> INSERT INTO Estudiantes (codigo_estudiante, apellidos_nombres) VALUES ('45896325', 'CARLOS ROMERO, José'), ('72659852', 'VILCHEZ MANSILLA, Rosa María'), ('74321526', 'BENAVIDES PAUCAR, Marco Antonio'), ('81924567', 'RIVERA SALAZAR, Lucía'), ('63254128', 'MORALES GÓMEZ, Juan'), ('78451236', 'MENDOZA HUAMÁN, Carla'), ('64587213', 'SANDOVAL TORRES, Enrique'), ('79321548', 'REYES RAMÍREZ, Diana'), ('75483621', 'CARRILLO VÁSQUEZ, Pedro'), ('78645231', 'GONZÁLEZ LÓPEZ, Mariana'); Query OK, 10 rows affected (0.036 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [parcial2]> select * from estudiantes; +-------------------+---------------------------------+ | codigo_estudiante | apellidos_nombres | +-------------------+---------------------------------+ 12345678 GUTIÉRREZ LÓPEZ, Ana 23456789 RODRÍGUEZ PÉREZ, Luis 34567890 FERNÁNDEZ GARCÍA, Marta 45678901 MARTÍNEZ SÁNCHEZ, Juan 56789012 LÓPEZ GÓMEZ, Elena 67890123 DÍAZ RUIZ, Carlos 78901234 SÁNCHEZ MARTÍN, Laura 89012345 PÉREZ GONZÁLEZ, David 90123456 GÓMEZ FERNÁNDEZ, Sofía 01234567 RUIZ DÍAZ, Pablo | +-------------------+---------------------------------+ 10 rows in set (0.002 sec) MariaDB [parcial2]> INSERT INTO Asignaturas (codigo_asignatura, nombre_asignatura, creditos, nivel_academico) VALUES ('MAT201', 'Matemáticas Avanzadas', 4, 'Intermedio'), ('FIS202', 'Física Moderna', 3, 'Básico'), ('QUIM203', 'Química Orgánica', 4, 'Intermedio'), ('LIT204', 'Literatura Contemporánea', 3, 'Básico'), ('BIO205', 'Biología Celular', 4, 'Avanzado'), ('HIS206', 'Historia del Arte', 3, 'Intermedio'), ('PSI207', 'Psicología Educativa', 4, 'Básico'), ('ECO208', 'Economía Internacional', 3, 'Intermedio'), ('FIL209', 'Filosofía Antigua', 4, 'Avanzado'), ('ING210', 'Ingeniería de Sistemas', 4, 'Básico'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [parcial2]> select * from asignaturas;; +-------------------+-------------------------------+----------+-----------------+ | codigo_asignatura | nombre_asignatura | creditos | nivel_academico | +-------------------+-------------------------------+----------+-----------------+ codigo_asignatura nombre_asignatura creditos nivel_academico MAT201 Matemáticas Avanzadas 4 Intermedio FIS202 Física Moderna 3 Básico QUIM203 Química Orgánica 4 Intermedio LIT204 Literatura Contemporánea 3 Básico BIO205 Biología Celular 4 Avanzado HIS206 Historia del Arte 3 Intermedio PSI207 Psicología Educativa 4 Básico ECO208 Economía Internacional 3 Intermedio FIL209 Filosofía Antigua 4 Avanzado ING210 Ingeniería de Sistemas 4 Básico +-------------------+-------------------------------+----------+-----------------+ 10 rows in set (0.001 sec) MariaDB [parcial2]> INSERT INTO Docentes (codigo_docente, apellidos_nombres, especialidad, telefono, correo) VALUES -> ('45678912', 'Estrada Sanchez, Amarico', 'Base de Datos', '987654321', 'amarico.estrada@mail.com'), -> ('47812596', 'Ríos Quispe, Carolina', 'Comunicación', '981234567', 'carolina.rios@mail.com'), -> ('42135698', 'Torres Gamarra, Julio', 'Ciencias Sociales', '983456789', 'julio.torres@mail.com'), -> ('43217895', 'Delgado Pérez, Susana', 'Educación Física', '985678912', 'susana.delgado@mail.com'), -> ('48965321', 'Guzmán León, Fernando', 'Historia', '987890123', 'fernando.guzman@mail.com'), -> ('41236985', 'Castañeda Vela, Patricia', 'Química', '980123456', 'patricia.castaneda@mail.com'), -> ('48751236', 'Ramos Ayala, Jorge', 'Lenguaje', '986543210', 'jorge.ramos@mail.com'), -> ('47896521', 'Chávez Romero, Natalia', 'Biología', '982345678', 'natalia.chavez@mail.com'), -> ('42369874', 'Paredes Vargas, Luis', 'Informática', '984567321', 'luis.paredes@mail.com'), -> ('41986532', 'Valdivia Torres, Lucero', 'Física', '989876543', 'lucero.valdivia@mail.com'); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [parcial2]> select * from docentes; +----------------+--------------------------+-------------------+-----------+-----------------------------+ | codigo_docente | apellidos_nombres | especialidad | telefono | correo | +----------------+--------------------------+-------------------+-----------+-----------------------------+ | 41236985 | Castañeda Vela, Patricia | Química | 980123456 | patricia.castaneda@mail.com | | 41986532 | Valdivia Torres, Lucero | Física | 989876543 | lucero.valdivia@mail.com | | 42135698 | Torres Gamarra, Julio | Ciencias Sociales | 983456789 | julio.torres@mail.com | | 42369874 | Paredes Vargas, Luis | Informática | 984567321 | luis.paredes@mail.com | | 43217895 | Delgado Pérez, Susana | Educación Física | 985678912 | susana.delgado@mail.com | | 45678912 | Estrada Sanchez, Amarico | Base de Datos | 987654321 | amarico.estrada@mail.com | | 47812596 | Ríos Quispe, Carolina | Comunicación | 981234567 | carolina.rios@mail.com | | 47896521 | Chávez Romero, Natalia | Biología | 982345678 | natalia.chavez@mail.com | | 48751236 | Ramos Ayala, Jorge | Lenguaje | 986543210 | jorge.ramos@mail.com | | 48965321 | Guzmán León, Fernando | Historia | 987890123 | fernando.guzman@mail.com | +----------------+--------------------------+-------------------+-----------+-----------------------------+ 10 rows in set (0.001 sec) MariaDB [parcial2]> INSERT INTO Asignaturas_Docentes (codigo_asignatura, codigo_docente) VALUES -> ('BD101', '45678912'), -> ('MD102', '47812596'), -> ('PRG103', '42135698'), -> ('POO104', '43217895'), -> ('ARQ105', '48965321'), -> ('SO106', '41236985'), -> ('RED107', '48751236'), -> ('ISW108', '47896521'), -> ('AES109', '42369874'), -> ('ETP110', '41986532'); Query OK, 10 rows affected (0.011 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [parcial2]> select * from Asignaturas_Docentes; +-------------------+----------------+ | codigo_asignatura | codigo_docente | +-------------------+----------------+ | AES109 | 42369874 | | ARQ105 | 48965321 | | BD101 | 45678912 | | ETP110 | 41986532 | | ISW108 | 47896521 | | MD102 | 47812596 | | POO104 | 43217895 | | PRG103 | 42135698 | | RED107 | 48751236 | | SO106 | 41236985 | +-------------------+----------------+ 10 rows in set (0.001 sec) MariaDB [parcial2]> INSERT INTO Notas (codigo_estudiante, codigo_asignatura, pa1, pa2, parcial, pa3, pa4, final) VALUES -> ('45896325', 'BD101', 19, 11, 18, 20, 18, 13), -> ('72659852', 'MD102', 17, 20, 9, 8, 9, 18), -> ('74321526', 'PRG103', 9, 17, 13, 15, 9, 13), -> ('81924567', 'POO104', 14, 13, 15, 19, 18, 16), -> ('63254128', 'ARQ105', 16, 18, 10, 14, 13, 15), -> ('78451236', 'SO106', 20, 19, 18, 20, 19, 20), -> ('64587213', 'RED107', 12, 14, 9, 10, 11, 12), -> ('79321548', 'ISW108', 18, 16, 17, 18, 20, 19), -> ('75483621', 'AES109', 15, 12, 14, 13, 14, 15), -> ('78645231', 'ETP110', 13, 15, 12, 16, 17, 14); Query OK, 10 rows affected (0.004 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [parcial2]> select * from notas; +-------------------+-------------------+------+------+---------+------+------+-------+ | codigo_estudiante | codigo_asignatura | pa1 | pa2 | parcial | pa3 | pa4 | final | +-------------------+-------------------+------+------+---------+------+------+-------+ | 45896325 | BD101 | 19 | 11 | 18 | 20 | 18 | 13 | | 63254128 | ARQ105 | 16 | 18 | 10 | 14 | 13 | 15 | | 64587213 | RED107 | 12 | 14 | 9 | 10 | 11 | 12 | | 72659852 | MD102 | 17 | 20 | 9 | 8 | 9 | 18 | | 74321526 | PRG103 | 9 | 17 | 13 | 15 | 9 | 13 | | 75483621 | AES109 | 15 | 12 | 14 | 13 | 14 | 15 | | 78451236 | SO106 | 20 | 19 | 18 | 20 | 19 | 20 | | 78645231 | ETP110 | 13 | 15 | 12 | 16 | 17 | 14 | | 79321548 | ISW108 | 18 | 16 | 17 | 18 | 20 | 19 | | 81924567 | POO104 | 14 | 13 | 15 | 19 | 18 | 16 | +-------------------+-------------------+------+------+---------+------+------+-------+ 10 rows in set (0.001 sec) MariaDB [parcial2]>