Microsoft Windows [Versión 10.0.26100.3775] (c) Microsoft Corporation. Todos los derechos reservados. C:\Users\Yeison>cd/xampp/mysql/bin C:\xampp\mysql\bin>mysql -uroot -p} ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) C:\xampp\mysql\bin> 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 datbase parcial2; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'datbase parcial2' at line 1 MariaDB [(none)]> create database parcial2; Query OK, 1 row affected (0.003 sec) MariaDB [(none)]> use parcial2: ERROR 1049 (42000): Unknown database 'parcial2:' 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]> 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 asinaturas;; ERROR 1146 (42S02): Table 'parcial2.asinaturas' doesn't exist ERROR: No query specified 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) ERROR: No query specified 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) -> ); ERROR 1005 (HY000): Can't create table `parcial2`.`asignaturas_docentes` (errno: 150 "Foreign key constraint is incorrectly formed") 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]> decribe docentes; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'decribe docentes' at line 1 MariaDB [parcial2]> decribe docente; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'decribe docente' at line 1 MariaDB [parcial2]> describe asignaturas-docentes; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '-docentes' at line 1 MariaDB [parcial2]> CREATE TABLE Docentes ( -> codigo_docente CHAR(8) PRIMARY KEY, -> apellidos_nombres VARCHAR(100), -> especialidad VARCHAR(100), -> telefono VARCHAR(20), -> correo VARCHAR(100) -> ); ERROR 1050 (42S01): Table 'docentes' already exists 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 | +-------------------+---------------------------------+ | 45896325 | CARLOS ROMERO, José | | 63254128 | MORALES GÓMEZ, Juan | | 64587213 | SANDOVAL TORRES, Enrique | | 72659852 | VILCHEZ MANSILLA, Rosa María | | 74321526 | BENAVIDES PAUCAR, Marco Antonio | | 75483621 | CARRILLO VÁSQUEZ, Pedro | | 78451236 | MENDOZA HUAMÁN, Carla | | 78645231 | GONZÁLEZ LÓPEZ, Mariana | | 79321548 | REYES RAMÍREZ, Diana | | 81924567 | RIVERA SALAZAR, Lucía | +-------------------+---------------------------------+ 10 rows in set (0.002 sec) MariaDB [parcial2]> INSERT INTO Asignaturas (codigo_asignatura, nombre_asignatura, creditos, nivel_academico) VALUES -> ('BD101', 'Base de Datos', 4, 'Intermedio'), -> ('MD102', 'Matemáticas Discretas', 3, 'Básico'), -> ('PRG103', 'Programación I', 4, 'Básico'), -> ('POO104', 'Programación Orientada a Obj.', 4, 'Intermedio'), -> ('ARQ105', 'Arquitectura de Computadoras', 3, 'Básico'), -> ('SO106', 'Sistemas Operativos', 4, 'Avanzado'), -> ('RED107', 'Redes de Computadoras', 3, 'Intermedio'), -> ('ISW108', 'Ingeniería de Software I', 4, 'Intermedio'), -> ('AES109', 'Algoritmos y Estructuras', 4, 'Básico'), -> ('ETP110', 'Ética Profesional', 2, '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 | +-------------------+-------------------------------+----------+-----------------+ | AES109 | Algoritmos y Estructuras | 4 | Básico | | ARQ105 | Arquitectura de Computadoras | 3 | Básico | | BD101 | Base de Datos | 4 | Intermedio | | ETP110 | Ética Profesional | 2 | Básico | | ISW108 | Ingeniería de Software I | 4 | Intermedio | | MD102 | Matemáticas Discretas | 3 | Básico | | POO104 | Programación Orientada a Obj. | 4 | Intermedio | | PRG103 | Programación I | 4 | Básico | | RED107 | Redes de Computadoras | 3 | Intermedio | | SO106 | Sistemas Operativos | 4 | Avanzado | +-------------------+-------------------------------+----------+-----------------+ 10 rows in set (0.001 sec) ERROR: No query specified 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]>