MariaDB [(none)]> create database Resgistro_Notas_DB; Query OK, 1 row affected (0,003 sec) MariaDB [(none)]> use Registro_Notas_DB; ERROR 1049 (42000): Unknown database 'Registro_Notas_DB' MariaDB [(none)]> drop database Resgistro_Notas_DB; Query OK, 0 rows affected, 2 warnings (0,004 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | Fechas | | Tienda_peliculas | | adrian_lopez | | aplicacion_cadena | | app_login | | biblioteca | | cadena | | createinsert | | cumple | | fechas_cadenas | | hospital_db | | information_schema | | inventario_prueba | | mysql | | parcial1 | | performance_schema | | phpmyadmin | | prueba | | simulacro | | subconsultas | | test | | tipodatos | | veterinaria | +--------------------+ 23 rows in set (0,011 sec) MariaDB [(none)]> create database Registro_NDB; Query OK, 1 row affected (0,001 sec) MariaDB [(none)]> use Registro_NDB; Database changed MariaDB [Registro_NDB]> CREATE TABLE Estudiante ( -> nombre1 VARCHAR(255) NOT NULL, -> nombre2 VARCHAR(255) NOT NULL, -> apellido1 VARCHAR(255) NOT NULL, -> apellido2 VARCHAR(255) NOT NULL, -> Nr INT AUTO_INCREMENT NOT NULL, -> codigo_est INT NOT NULL, -> PRIMARY KEY (codigo_est) -> ); ERROR 1075 (42000): Incorrect table definition; there can be only one auto column and it must be defined as a key MariaDB [Registro_NDB]> CREATE TABLE Estudiante ( -> nombre1 VARCHAR(255) NOT NULL, -> nombre2 VARCHAR(255) NOT NULL, -> apellido1 VARCHAR(255) NOT NULL, -> apellido2 VARCHAR(255) NOT NULL, -> Nr INT NOT NULL, -> codigo_est INT NOT NULL, -> PRIMARY KEY (codigo_est) -> ); Query OK, 0 rows affected (0,010 sec) MariaDB [Registro_NDB]> CREATE TABLE Profesor ( -> nombre1 VARCHAR(255) NOT NULL, -> nombre2 VARCHAR(255) NOT NULL, -> apellido1 VARCHAR(255) NOT NULL, -> apellido2 VARCHAR(255) NOT NULL, -> Nr_p INT NOT NULL, -> codigo_p INT NOT NULL, -> PRIMARY KEY (codigo_p) -> ); Query OK, 0 rows affected (0,011 sec) MariaDB [Registro_NDB]> CREATE TABLE Materia ( -> codigo_M INT NOT NULL, -> nombre_m VARCHAR(255) NOT NULL, -> codigo_profesor INT NOT NULL, -> PRIMARY KEY (codigo_M), -> CONSTRAINT Materia_fk2 FOREIGN KEY (codigo_profesor) REFERENCES Profesor(codigo_p) -> ); Query OK, 0 rows affected (0,012 sec) MariaDB [Registro_NDB]> CREATE TABLE Registro_notas ( -> Nr INT NOT NULL, -> codigo_est INT NOT NULL, -> nombre1 VARCHAR(255) NOT NULL, -> nombre2 VARCHAR(255) NOT NULL, -> apellido1 VARCHAR(255) NOT NULL, -> apellido2 VARCHAR(255) NOT NULL, -> materia INT NOT NULL, -> PA1 FLOAT NOT NULL, -> PA2 FLOAT NOT NULL, -> parcial FLOAT NOT NULL, -> PA3 FLOAT NOT NULL, -> PA4 FLOAT NOT NULL, -> final FLOAT NOT NULL, -> PRIMARY KEY (Nr), -> CONSTRAINT Registro_notas_fk1 FOREIGN KEY (codigo_est) REFERENCES Estudiante(codigo_est), -> CONSTRAINT Registro_notas_fk6 FOREIGN KEY (materia) REFERENCES Materia(codigo_M) -> ); Query OK, 0 rows affected (0,014 sec) MariaDB [Registro_NDB]> show tables -> ; +------------------------+ | Tables_in_Registro_NDB | +------------------------+ | Estudiante | | Materia | | Profesor | | Registro_notas | +------------------------+ 4 rows in set (0,001 sec) MariaDB [Registro_NDB]> DELIMITER // MariaDB [Registro_NDB]> CREATE TRIGGER calcular_final -> BEFORE INSERT ON Registro_notas -> FOR EACH ROW -> BEGIN -> SET NEW.final = ((NEW.PA1 * 0.4) + (NEW.PA2 * 0.6) + NEW.parcial + (NEW.PA3 * 0.7) + (NEW.PA4 * 0.3)) / 3; -> END; -> // Query OK, 0 rows affected (0,008 sec) MariaDB [Registro_NDB]> DELIMITER ; MariaDB [Registro_NDB]> DELIMITER // MariaDB [Registro_NDB]> CREATE TRIGGER recalcular_final -> BEFORE UPDATE ON Registro_notas -> FOR EACH ROW -> BEGIN -> SET NEW.final = ((NEW.PA1 * 0.4) + (NEW.PA2 * 0.6) + NEW.parcial + (NEW.PA3 * 0.7) + (NEW.PA4 * 0.3)) / 3; -> END; -> // Query OK, 0 rows affected (0,012 sec) MariaDB [Registro_NDB]> DELIMITER ; MariaDB [Registro_NDB]> show triggers; +------------------+--------+----------------+--------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | Trigger | Event | Table | Statement | Timing | Created | sql_mode | Definer | character_set_client | collation_connection | Database Collation | +------------------+--------+----------------+--------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ | calcular_final | INSERT | Registro_notas | BEGIN SET NEW.final = ((NEW.PA1 * 0.4) + (NEW.PA2 * 0.6) + NEW.parcial + (NEW.PA3 * 0.7) + (NEW.PA4 * 0.3)) / 3; END | BEFORE | 2025-10-07 10:00:40.17 | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | | recalcular_final | UPDATE | Registro_notas | BEGIN SET NEW.final = ((NEW.PA1 * 0.4) + (NEW.PA2 * 0.6) + NEW.parcial + (NEW.PA3 * 0.7) + (NEW.PA4 * 0.3)) / 3; END | BEFORE | 2025-10-07 10:01:27.73 | STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | root@localhost | utf8mb4 | utf8mb4_general_ci | utf8mb4_general_ci | +------------------+--------+----------------+--------------------------------------------------------------------------------------------------------------------------+--------+------------------------+-------------------------------------------------------------------------------------------+----------------+----------------------+----------------------+--------------------+ 2 rows in set (0,004 sec) MariaDB [Registro_NDB]> INSERT INTO Estudiante (nombre1, nombre2, apellido1, apellido2, Nr, codigo_est) VALUES -> ('Juan', 'David', 'Pérez', 'López', 1, 1001), -> ('María', 'Fernanda', 'Gómez', 'Rodríguez', 2, 1002), -> ('Carlos', 'Andrés', 'Martínez', 'Torres', 3, 1003), -> ('Laura', 'Isabel', 'Ramírez', 'García', 4, 1004), -> ('Andrés', 'Felipe', 'Moreno', 'Castro', 5, 1005), -> ('Sofía', 'Alejandra', 'Ruiz', 'Mendoza', 6, 1006), -> ('Daniel', 'Esteban', 'Suárez', 'Cortés', 7, 1007), -> ('Valentina', 'María', 'Ortiz', 'Salazar', 8, 1008), -> ('Felipe', 'Alexander', 'Hernández', 'Jiménez', 9, 1009), -> ('Camila', 'Juliana', 'Vargas', 'Ríos', 10, 1010); Query OK, 10 rows affected (0,005 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Registro_NDB]> INSERT INTO Profesor (nombre1, nombre2, apellido1, apellido2, Nr_p, codigo_p) VALUES -> ('Ricardo', 'Andrés', 'Santos', 'Muñoz', 1, 2001), -> ('Paula', 'Marcela', 'López', 'García', 2, 2002); Query OK, 2 rows affected (0,009 sec) Records: 2 Duplicates: 0 Warnings: 0 MariaDB [Registro_NDB]> select * from Estudiantes; ERROR 1146 (42S02): Table 'Registro_NDB.Estudiantes' doesn't exist MariaDB [Registro_NDB]> select * from Estudiante; +-----------+-----------+------------+------------+----+------------+ | nombre1 | nombre2 | apellido1 | apellido2 | Nr | codigo_est | +-----------+-----------+------------+------------+----+------------+ | Juan | David | Pérez | López | 1 | 1001 | | María | Fernanda | Gómez | Rodríguez | 2 | 1002 | | Carlos | Andrés | Martínez | Torres | 3 | 1003 | | Laura | Isabel | Ramírez | García | 4 | 1004 | | Andrés | Felipe | Moreno | Castro | 5 | 1005 | | Sofía | Alejandra | Ruiz | Mendoza | 6 | 1006 | | Daniel | Esteban | Suárez | Cortés | 7 | 1007 | | Valentina | María | Ortiz | Salazar | 8 | 1008 | | Felipe | Alexander | Hernández | Jiménez | 9 | 1009 | | Camila | Juliana | Vargas | Ríos | 10 | 1010 | +-----------+-----------+------------+------------+----+------------+ 10 rows in set (0,001 sec) MariaDB [Registro_NDB]> select * from Profesor; +---------+---------+-----------+-----------+------+----------+ | nombre1 | nombre2 | apellido1 | apellido2 | Nr_p | codigo_p | +---------+---------+-----------+-----------+------+----------+ | Ricardo | Andrés | Santos | Muñoz | 1 | 2001 | | Paula | Marcela | López | García | 2 | 2002 | +---------+---------+-----------+-----------+------+----------+ 2 rows in set (0,001 sec) MariaDB [Registro_NDB]> INSERT INTO Materia (codigo_M, nombre_m, codigo_profesor) VALUES -> (3001, 'Programación I', 2001), -> (3002, 'Bases de Datos', 2002); Query OK, 2 rows affected (0,008 sec) Records: 2 Duplicates: 0 Warnings: 0 MariaDB [Registro_NDB]> INSERT INTO Registro_notas (Nr, codigo_est, nombre1, nombre2, apellido1, apellido2, materia, PA1, PA2, parcial, PA3, PA4, final) VALUES -> (1, 1001, 'Juan', 'David', 'Pérez', 'López', 3001, 3.5, 4.0, 4.2, 3.8, 4.0, NULL), -> (2, 1002, 'María', 'Fernanda', 'Gómez', 'Rodríguez', 3002, 4.5, 3.9, 4.1, 4.2, 3.8, NULL), -> (3, 1003, 'Carlos', 'Andrés', 'Martínez', 'Torres', 3001, 3.2, 3.8, 4.0, 3.9, 3.5, NULL), -> (4, 1004, 'Laura', 'Isabel', 'Ramírez', 'García', 3002, 4.7, 4.5, 4.3, 4.6, 4.4, NULL), -> (5, 1005, 'Andrés', 'Felipe', 'Moreno', 'Castro', 3001, 3.0, 3.6, 3.8, 3.7, 3.9, NULL), -> (6, 1006, 'Sofía', 'Alejandra', 'Ruiz', 'Mendoza', 3002, 4.0, 4.3, 4.5, 4.2, 4.1, NULL), -> (7, 1007, 'Daniel', 'Esteban', 'Suárez', 'Cortés', 3001, 3.8, 3.9, 4.0, 3.7, 3.6, NULL), -> (8, 1008, 'Valentina', 'María', 'Ortiz', 'Salazar', 3002, 4.6, 4.2, 4.4, 4.3, 4.0, NULL), -> (9, 1009, 'Felipe', 'Alexander', 'Hernández', 'Jiménez', 3001, 3.5, 3.7, 3.9, 3.8, 3.6, NULL), -> (10, 1010, 'Camila', 'Juliana', 'Vargas', 'Ríos', 3002, 4.8, 4.6, 4.5, 4.7, 4.3, NULL); Query OK, 10 rows affected (0,012 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [Registro_NDB]> select * from Registro_notas; +----+------------+-----------+-----------+------------+------------+---------+-----+-----+---------+-----+-----+---------+ | Nr | codigo_est | nombre1 | nombre2 | apellido1 | apellido2 | materia | PA1 | PA2 | parcial | PA3 | PA4 | final | +----+------------+-----------+-----------+------------+------------+---------+-----+-----+---------+-----+-----+---------+ | 1 | 1001 | Juan | David | Pérez | López | 3001 | 3.5 | 4 | 4.2 | 3.8 | 4 | 3.95333 | | 2 | 1002 | María | Fernanda | Gómez | Rodríguez | 3002 | 4.5 | 3.9 | 4.1 | 4.2 | 3.8 | 4.10667 | | 3 | 1003 | Carlos | Andrés | Martínez | Torres | 3001 | 3.2 | 3.8 | 4 | 3.9 | 3.5 | 3.78 | | 4 | 1004 | Laura | Isabel | Ramírez | García | 3002 | 4.7 | 4.5 | 4.3 | 4.6 | 4.4 | 4.47333 | | 5 | 1005 | Andrés | Felipe | Moreno | Castro | 3001 | 3 | 3.6 | 3.8 | 3.7 | 3.9 | 3.64 | | 6 | 1006 | Sofía | Alejandra | Ruiz | Mendoza | 3002 | 4 | 4.3 | 4.5 | 4.2 | 4.1 | 4.28333 | | 7 | 1007 | Daniel | Esteban | Suárez | Cortés | 3001 | 3.8 | 3.9 | 4 | 3.7 | 3.6 | 3.84333 | | 8 | 1008 | Valentina | María | Ortiz | Salazar | 3002 | 4.6 | 4.2 | 4.4 | 4.3 | 4 | 4.32333 | | 9 | 1009 | Felipe | Alexander | Hernández | Jiménez | 3001 | 3.5 | 3.7 | 3.9 | 3.8 | 3.6 | 3.75333 | | 10 | 1010 | Camila | Juliana | Vargas | Ríos | 3002 | 4.8 | 4.6 | 4.5 | 4.7 | 4.3 | 4.58667 | +----+------------+-----------+-----------+------------+------------+---------+-----+-----+---------+-----+-----+---------+ 10 rows in set (0,001 sec) MariaDB [Registro_NDB]> note -> ; 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 'note' at line 1 MariaDB [Registro_NDB]> notee