MariaDB [(none)]> create database MatriculaEscuela; Query OK, 1 row affected (0.001 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | bingo | | information_schema | | libreria | | matriculaescuela | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 8 rows in set (0.001 sec) MariaDB [(none)]> use matriculaescuela; Database changed MariaDB [matriculaescuela]> create table Acudiente -> (Cod_Acudiente varchar(3) not null primary key, -> Nombre varchar(50) not null, -> Direccion varchar(50) not null, -> Telefono varchar(7) not null, -> E_mail varchar(50) not null); Query OK, 0 rows affected (0.020 sec) MariaDB [matriculaescuela]> describe acudiente; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | Cod_Acudiente | varchar(3) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(50) | NO | | NULL | | | Telefono | varchar(7) | NO | | NULL | | | E_mail | varchar(50) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 5 rows in set (0.022 sec) MariaDB [matriculaescuela]> create table Estudiante -> (Cod_Estudiante varchar(5) not null primary key, -> Nombre varchar(50) not null, -> Direccion varchar(50) not null, -> Telefono varchar(7) not null, -> E_mail varchar(50) not null); Query OK, 0 rows affected (0.025 sec) MariaDB [matriculaescuela]> create table Profesor -> (Cod_Profesor varchar(3) not null primary key, -> Nombre varchar(50) not null, -> Direccion varchar(50) not null, -> Telefono varchar(7) not null, -> E_mail varchar(50) not null); Query OK, 0 rows affected (0.032 sec) MariaDB [matriculaescuela]> create table Materia -> (Cod_Materia varchar(2) not null primary key, -> Nombre varchar(50) not null); Query OK, 0 rows affected (0.032 sec) MariaDB [matriculaescuela]> describe estudiante; +----------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+-------------+------+-----+---------+-------+ | Cod_Estudiante | varchar(5) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(50) | NO | | NULL | | | Telefono | varchar(7) | NO | | NULL | | | E_mail | varchar(50) | NO | | NULL | | +----------------+-------------+------+-----+---------+-------+ 5 rows in set (0.020 sec) MariaDB [matriculaescuela]> describe materia; +-------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------+------+-----+---------+-------+ | Cod_Materia | varchar(2) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | +-------------+-------------+------+-----+---------+-------+ 2 rows in set (0.020 sec) MariaDB [matriculaescuela]> describe profesor; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | Cod_Profesor | varchar(3) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(50) | NO | | NULL | | | Telefono | varchar(7) | NO | | NULL | | | E_mail | varchar(50) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 5 rows in set (0.019 sec) MariaDB [matriculaescuela]> create table Estudiante_Acudiente -> (Cod_Acudiente varchar(3) not null, -> Cod_Materia varchar(2) not null, -> foreign key(Cod_Acudiente) references Acudiente(Cod_Acudiente) on delete cascade on update cascade, -> foreign key(Cod_Materia) references Materia(Cod_Materia) on delete cascade on update cascade); Query OK, 0 rows affected (0.045 sec) MariaDB [matriculaescuela]> describe estudiante_acudiente; +---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | Cod_Acudiente | varchar(3) | NO | MUL | NULL | | | Cod_Materia | varchar(2) | NO | MUL | NULL | | +---------------+------------+------+-----+---------+-------+ 2 rows in set (0.019 sec) MariaDB [matriculaescuela]> drop table estudiante_acudiente; Query OK, 0 rows affected (0.069 sec) MariaDB [matriculaescuela]> create table Estudiante_Acudiente -> (Cod_Acudiente varchar(3) not null, -> Cod_Estudiante varchar(5) not null, -> foreign key(Cod_Acudiente) references Acudiente(Cod_Acudiente) on delete cascade on update cascade, -> foreign key(Cod_Estudiante) references Estudiante(Cod_Estudiante) on delete cascade on update cascade); Query OK, 0 rows affected (0.035 sec) MariaDB [matriculaescuela]> describe estudiante_acudiente; +----------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------+------+-----+---------+-------+ | Cod_Acudiente | varchar(3) | NO | MUL | NULL | | | Cod_Estudiante | varchar(5) | NO | MUL | NULL | | +----------------+------------+------+-----+---------+-------+ 2 rows in set (0.019 sec) MariaDB [matriculaescuela]> create table Estudiante_Materia -> Cod_Estudiante varchar(5) not null, -> Cod_Materia varchar(2) not null, -> foreign key(Cod_Materia) references Materia(Cod_Materia) on delete cascade on update cascade, -> foreign key(Cod_Estudiante) references Estudiante(Cod_Estudiante) on delete cascade on update cascade); 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 'varchar(5) not null, Cod_Materia varchar(2) not null, foreign key(Cod_Materia...' at line 2 MariaDB [matriculaescuela]> create table Estudiante_Materia -> Cod_Estudiante varchar(5) not null, -> Cod_Materia varchar(2) not null, -> foreign key(Cod_Estudiante) references Estudiante(Cod_Estudiante) on delete cascade on update cascade, -> foreign key(Cod_Materia) references Materia(Cod_Materia) on delete cascade on update cascade); 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 'varchar(5) not null, Cod_Materia varchar(2) not null, foreign key(Cod_Estudia...' at line 2 MariaDB [matriculaescuela]> create table Materia_Profesor -> (Codigo_Materia varchar(2) not null, -> Co -> -> ; 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 '' at line 3 MariaDB [matriculaescuela]> create table Estudiante_Materia -> (Cod_Estudiante varchar(5) not null, -> Cod_Materia varchar(2) not null, -> foreign key(Cod_Estudiante) references Estudiante(Cod_Estudiante) on delete cascade on update cascade, -> foreign key(Cod_Materia) references Materia(Cod_Materia) on delete cascade on update cascade); Query OK, 0 rows affected (0.020 sec) MariaDB [matriculaescuela]> create table Materia_Profesor -> (Cod_Materia varchar(2) not null, -> (Cod_Profesor varchar(3) not null, -> foreign key(Cod_Materia) references Materia(Cod_Materia) on delete cascade on update cascade, -> foreign key(Cod_Profesor) references profesor(Cod_Profesor) on delete cascade on update cascade); 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 '(Cod_Profesor varchar(3) not null, foreign key(Cod_Materia) references Materi...' at line 3 MariaDB [matriculaescuela]> create table Materia_Profesor -> (Cod_Materia varchar(2) not null, -> Cod_Profesor varchar(3) not null, -> foreign key(Cod_Materia) references Materia(Cod_Materia) on delete cascade on update cascade, -> foreign key(Cod_Profesor) references profesor(Cod_Profesor) on delete cascade on update cascade); Query OK, 0 rows affected (0.022 sec) MariaDB [matriculaescuela]> describe acudiente; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | Cod_Acudiente | varchar(3) | NO | PRI | NULL | | | Nombre | varchar(50) | NO | | NULL | | | Direccion | varchar(50) | NO | | NULL | | | Telefono | varchar(7) | NO | | NULL | | | E_mail | varchar(50) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 5 rows in set (0.010 sec) MariaDB [matriculaescuela]> select * from acudiente; Empty set (0.001 sec) MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("001","ACEVEDO CARDONA ESTEBAN", "Barrio la pradera", "5846069", "estebacardona@gmail.com"); Query OK, 1 row affected (0.003 sec) MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("002","AGUDELO MANCO DIANA PATRICIA", "Barrio rosaleda", "5882104", "dianapatricia@gmail.com"); Query OK, 1 row affected (0.003 sec) MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("003","ZPATA VALENCIA JORGE", "Barrio Aragon", "5841998", "jorgezapata@gmail.com"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("004","VELASQUEZ CANO JENNY ASTRID", "Barrio la pradera", "2791469", "jennyvelasquez@gmail.com"); Query OK, 1 row affected (0.004 sec) MariaDB [matriculaescuela]> insert into estudiante_acudiente(Cod_acudiente, Cod_estudiante) values("001", "00001"); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`matriculaescuela`.`estudiante_acudiente`, CONSTRAINT `estudiante_acudiente_ibfk_2` FOREIGN KEY (`Cod_Estudiante`) REFERENCES `estudiante` (`Cod_Estudiante`) ON DELETE CASCADE ON UPDATE CASCAD) MariaDB [matriculaescuela]> insert into estudiante(cod_estudiante, nombre, direccion, telefono, e_mail) values("00001","ACEVEDO BURITICA JUAN ESTEBAN", "Barrio la pradera", "5846069", "juanestebacardona@gmail.com"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into estudiante(cod_estudiante, nombre, direccion, telefono, e_mail) values("00002","ALVAREZ AGUDELO ESTEBAN", "Barrio rosaleda", "5882104", "estebanlavarez@gmail.com"); Query OK, 1 row affected (0.003 sec) MariaDB [matriculaescuela]> insert into estudiante(cod_estudiante, nombre, direccion, telefono, e_mail) values("00003","ZAPATA CAMPI¥O ISABEL", "Barrio Aragon", "5841998", "zapataisabel@gmail.com"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into estudiante(cod_estudiante, nombre, direccion, telefono, e_mail) values("00004","VALLE VELASQUEZ SOFIA", "Barrio la pradera", "2791469", "sofiavelasquez@gmail.com"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into estudiante(cod_estudiante, nombre, direccion, telefono, e_mail) values("00005","MORENO POSADA DIEGO ALEJANDRO", "Urbanizacion compartir", "2868617", "diegomoreno@gmail.com"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("01", "Espanol"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("02", "LectoEscritura"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("03", "Matematicas"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("04", "Ciencias Naturales"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("05", "Investigacion"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("06", "Fisica"); Query OK, 1 row affected (0.003 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("07", "Filosofia"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("08", "Educacion Fisica"); Query OK, 1 row affected (0.003 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("09", "Etica"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("10", "Artistica"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("11", "Tecnologia"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("12", "Informatica"); Query OK, 1 row affected (0.011 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("13", "Religion"); Query OK, 1 row affected (0.019 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("14", "Sociales"); Query OK, 1 row affected (0.036 sec) MariaDB [matriculaescuela]> insert into materia(cod_Materia, nombre) values("15", "Ingles"); Query OK, 1 row affected (0.019 sec) MariaDB [matriculaescuela]> insert into profesor(cod_profesor, nombre, direccion, telefono, e_mail) values("001","CIFUENTES MESA MYEIDY MARIA", "Urbanizacion compartir", "2868617", "myleidym.iearm@gmail.com"); Query OK, 1 row affected (0.092 sec) MariaDB [matriculaescuela]> insert into profesor(cod_profesor, nombre, direccion, telefono, e_mail) values("003","CUADRADO PEREZ ADRID JOSE", "", "", "adrid.iearm@gmail.com"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into profesor(cod_profesor, nombre, direccion, telefono, e_mail) values("002","GUIRALES MAURICIO", "", "", "esterl.iearm@gmail.com"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into profesor(cod_profesor, nombre, direccion, telefono, e_mail) values("004","DUQUE RESTREPO ESTER LUCIA", "", "", "mauriciog.iearm@gmail.com"); Query OK, 1 row affected (0.003 sec) MariaDB [matriculaescuela]> insert into profesor(cod_profesor, nombre, direccion, telefono, e_mail) values("005","VERA DAZA MARIA ELENA", "", "", "mariae.iearm@gmail.com"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into profesor(cod_profesor, nombre, direccion, telefono, e_mail) values("006","PALACIO TOMAS FELIPE", "", "", "tomasf.iearm@gmail.com"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> select * from acudiente; +---------------+------------------------------+-------------------+----------+--------------------------+ | Cod_Acudiente | Nombre | Direccion | Telefono | E_mail | +---------------+------------------------------+-------------------+----------+--------------------------+ | 001 | ACEVEDO CARDONA ESTEBAN | Barrio la pradera | 5846069 | estebacardona@gmail.com | | 002 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatricia@gmail.com | | 003 | ZPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gmail.com | | 004 | VELASQUEZ CANO JENNY ASTRID | Barrio la pradera | 2791469 | jennyvelasquez@gmail.com | +---------------+------------------------------+-------------------+----------+--------------------------+ 4 rows in set (0.000 sec) MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("005","POSADA VASCO ANA", "Urbanizacion compartir", "2868617", "anaposada@gmail.com"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> select * from acudiente; +---------------+------------------------------+------------------------+----------+--------------------------+ | Cod_Acudiente | Nombre | Direccion | Telefono | E_mail | +---------------+------------------------------+------------------------+----------+--------------------------+ | 001 | ACEVEDO CARDONA ESTEBAN | Barrio la pradera | 5846069 | estebacardona@gmail.com | | 002 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatricia@gmail.com | | 003 | ZPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gmail.com | | 004 | VELASQUEZ CANO JENNY ASTRID | Barrio la pradera | 2791469 | jennyvelasquez@gmail.com | | 005 | POSADA VASCO ANA | Urbanizacion compartir | 2868617 | anaposada@gmail.com | +---------------+------------------------------+------------------------+----------+--------------------------+ 5 rows in set (0.000 sec) MariaDB [matriculaescuela]> insert into Estudiante_Acudiente(Cod_Acudiente, Cod_Estudiante) values("001", "00001"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Acudiente(Cod_Acudiente, Cod_Estudiante) values("002", "00002"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Acudiente(Cod_Acudiente, Cod_Estudiante) values("003", "00003"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Acudiente(Cod_Acudiente, Cod_Estudiante) values("004", "00004"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Acudiente(Cod_Acudiente, Cod_Estudiante) values("005", "00005"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("001", "01"); ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`matriculaescuela`.`estudiante_materia`, CONSTRAINT `estudiante_materia_ibfk_1` FOREIGN KEY (`Cod_Estudiante`) REFERENCES `estudiante` (`Cod_Estudiante`) ON DELETE CASCADE ON UPDATE CASCADE) MariaDB [matriculaescuela]> describe Estudiante_Materia; +----------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+------------+------+-----+---------+-------+ | Cod_Estudiante | varchar(5) | NO | MUL | NULL | | | Cod_Materia | varchar(2) | NO | MUL | NULL | | +----------------+------------+------+-----+---------+-------+ 2 rows in set (0.010 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "01"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "02"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "03"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "04"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "05"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "06"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "07"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "08"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "09"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "10"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "11"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "12"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "13"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "14"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00001", "15"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "01"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "02"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "03"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "04"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "05"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "06"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "07"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "08"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "09"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "10"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "11"); Query OK, 1 row affected (0.002 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "12"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "13"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "14"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia(Cod_Estudiante, Cod_Materia) values("00002", "15"); Query OK, 1 row affected (0.001 sec) MariaDB [matriculaescuela]> insert into Materia_Profesor(Cod_Materia, Cod_Profesor) values("01", "005"); Query OK, 1 row affected (0.005 sec) MariaDB [matriculaescuela]> select * from acudiente; +---------------+------------------------------+------------------------+----------+--------------------------+ | Cod_Acudiente | Nombre | Direccion | Telefono | E_mail | +---------------+------------------------------+------------------------+----------+--------------------------+ | 001 | ACEVEDO CARDONA ESTEBAN | Barrio la pradera | 5846069 | estebacardona@gmail.com | | 002 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatricia@gmail.com | | 003 | ZPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gmail.com | | 004 | VELASQUEZ CANO JENNY ASTRID | Barrio la pradera | 2791469 | jennyvelasquez@gmail.com | | 005 | POSADA VASCO ANA | Urbanizacion compartir | 2868617 | anaposada@gmail.com | +---------------+------------------------------+------------------------+----------+--------------------------+ 5 rows in set (0.000 sec) MariaDB [matriculaescuela]> select * from Estudiante_Acudiente; +---------------+----------------+ | Cod_Acudiente | Cod_Estudiante | +---------------+----------------+ | 001 | 00001 | | 002 | 00002 | | 003 | 00003 | | 004 | 00004 | | 005 | 00005 | +---------------+----------------+ 5 rows in set (0.000 sec) MariaDB [matriculaescuela]> select * from Acudiente; +---------------+------------------------------+------------------------+----------+--------------------------+ | Cod_Acudiente | Nombre | Direccion | Telefono | E_mail | +---------------+------------------------------+------------------------+----------+--------------------------+ | 001 | ACEVEDO CARDONA ESTEBAN | Barrio la pradera | 5846069 | estebacardona@gmail.com | | 002 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatricia@gmail.com | | 003 | ZPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gmail.com | | 004 | VELASQUEZ CANO JENNY ASTRID | Barrio la pradera | 2791469 | jennyvelasquez@gmail.com | | 005 | POSADA VASCO ANA | Urbanizacion compartir | 2868617 | anaposada@gmail.com | +---------------+------------------------------+------------------------+----------+--------------------------+ 5 rows in set (0.000 sec) MariaDB [matriculaescuela]> select * from Estudiante; +----------------+-------------------------------+------------------------+----------+-----------------------------+ | Cod_Estudiante | Nombre | Direccion | Telefono | E_mail | +----------------+-------------------------------+------------------------+----------+-----------------------------+ | 00001 | ACEVEDO BURITICA JUAN ESTEBAN | Barrio la pradera | 5846069 | juanestebacardona@gmail.com | | 00002 | ALVAREZ AGUDELO ESTEBAN | Barrio rosaleda | 5882104 | estebanlavarez@gmail.com | | 00003 | ZAPATA CAMPI¥O ISABEL | Barrio Aragon | 5841998 | zapataisabel@gmail.com | | 00004 | VALLE VELASQUEZ SOFIA | Barrio la pradera | 2791469 | sofiavelasquez@gmail.com | | 00005 | MORENO POSADA DIEGO ALEJANDRO | Urbanizacion compartir | 2868617 | diegomoreno@gmail.com | +----------------+-------------------------------+------------------------+----------+-----------------------------+ 5 rows in set (0.000 sec) MariaDB [matriculaescuela]> select * from Estudiante_Materia; +----------------+-------------+ | Cod_Estudiante | Cod_Materia | +----------------+-------------+ | 00001 | 01 | | 00001 | 02 | | 00001 | 03 | | 00001 | 04 | | 00001 | 05 | | 00001 | 06 | | 00001 | 07 | | 00001 | 08 | | 00001 | 09 | | 00001 | 10 | | 00001 | 11 | | 00001 | 12 | | 00001 | 13 | | 00001 | 14 | | 00001 | 15 | | 00002 | 01 | | 00002 | 02 | | 00002 | 03 | | 00002 | 04 | | 00002 | 05 | | 00002 | 06 | | 00002 | 07 | | 00002 | 08 | | 00002 | 09 | | 00002 | 10 | | 00002 | 11 | | 00002 | 12 | | 00002 | 13 | | 00002 | 14 | | 00002 | 15 | +----------------+-------------+ 30 rows in set (0.000 sec) MariaDB [matriculaescuela]> select * from Materia; +-------------+--------------------+ | Cod_Materia | Nombre | +-------------+--------------------+ | 01 | Espanol | | 02 | LectoEscritura | | 03 | Matematicas | | 04 | Ciencias Naturales | | 05 | Investigacion | | 06 | Fisica | | 07 | Filosofia | | 08 | Educacion Fisica | | 09 | Etica | | 10 | Artistica | | 11 | Tecnologia | | 12 | Informatica | | 13 | Religion | | 14 | Sociales | | 15 | Ingles | +-------------+--------------------+ 15 rows in set (0.000 sec) MariaDB [matriculaescuela]> select * from Materia_Profesor; +-------------+--------------+ | Cod_Materia | Cod_Profesor | +-------------+--------------+ | 01 | 005 | +-------------+--------------+ 1 row in set (0.000 sec) MariaDB [matriculaescuela]> select * from Profesor; +--------------+-----------------------------+------------------------+----------+---------------------------+ | Cod_Profesor | Nombre | Direccion | Telefono | E_mail | +--------------+-----------------------------+------------------------+----------+---------------------------+ | 001 | CIFUENTES MESA MYEIDY MARIA | Urbanizacion compartir | 2868617 | myleidym.iearm@gmail.com | | 002 | GUIRALES MAURICIO | | | esterl.iearm@gmail.com | | 003 | CUADRADO PEREZ ADRID JOSE | | | adrid.iearm@gmail.com | | 004 | DUQUE RESTREPO ESTER LUCIA | | | mauriciog.iearm@gmail.com | | 005 | VERA DAZA MARIA ELENA | | | mariae.iearm@gmail.com | | 006 | PALACIO TOMAS FELIPE | | | tomasf.iearm@gmail.com | +--------------+-----------------------------+------------------------+----------+---------------------------+ 6 rows in set (0.000 sec) MariaDB [matriculaescuela]> exit