Microsoft Windows [Versión 10.0.22631.4169] (c) Microsoft Corporation. Todos los derechos reservados. C:\Users\Andrade Pastrana>cd/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)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | libro | | matriculaescuela | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 7 rows in set (0.001 sec) MariaDB [(none)]> use matriculaescuela; Database changed 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.020 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.014 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.013 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.023 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.011 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.014 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.040 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.021 sec) 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.028 sec) 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.029 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); Query OK, 0 rows affected (0.038 sec) MariaDB [matriculaescuela]> describe materia_profesor; +--------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+------------+------+-----+---------+-------+ | Cod_Materia | varchar(2) | NO | MUL | NULL | | | Cod_Profesor | varchar(3) | NO | MUL | NULL | | +--------------+------------+------+-----+---------+-------+ 2 rows in set (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.012 sec) MariaDB [matriculaescuela]> show tables; +----------------------------+ | Tables_in_matriculaescuela | +----------------------------+ | acudiente | | estudiante | | estudiante_acudiente | | estudiante_materia | | materia | | materia_profesor | | profesor | +----------------------------+ 7 rows in set (0.001 sec) MariaDB [matriculaescuela]> select * from acudiente; Empty set (0.059 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.004 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.015 sec) MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("003","ZAPATA VALENCIA JORGE", "Barrio Aragon", "5841998", "jorgezapata@gmail.com"); ERROR 1062 (23000): Duplicate entry '003' for key 'PRIMARY' MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("003","ZPATA VALENCIA JORGE", "Barrio Aragon", "5841998", "jorgezapata@gmail.com"); ERROR 1062 (23000): Duplicate entry '003' for key 'PRIMARY' MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("003","ZPATA VALENCIA JORGE", "Barrio Aragon", "5841998", "jorgezapata@gmail.com"); ERROR 1062 (23000): Duplicate entry '003' for key 'PRIMARY' MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("003","ZPATA VALENCIA JORGE", "Barrio Aragon", "5841998", "jorgezapata@gmail.com"); ERROR 1062 (23000): Duplicate entry '003' for key 'PRIMARY' 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.015 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.014 sec) MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("006","ORTIZ PUERTA INDIRA", "Urbanizac ion ciudadela prado", "5841497", "indiraortiz.com"); Query OK, 1 row affected (0.013 sec) MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("006","QUINTERO MENESES ADRIANA MARIA", "barrio sangabriel", "5840570", "adrianaquintero.com"); ERROR 1062 (23000): Duplicate entry '006' for key 'PRIMARY' MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("007","QUINTERO MENESES ADRIANA MARIA", "barrio sangabriel", "5840570", "adrianaquintero.com"); Query OK, 1 row affected (0.003 sec) MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("008","MONTOYA RIVERA EDILMA", "barrio la pradera", "3767289", "edilmamontoya.com"); Query OK, 1 row affected (0.013 sec) MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("009","LOPERA MONSALVE FERNANDO ALONSO" , "barrio el limonar 1", "5709957", "fernandolopera.com"); Query OK, 1 row affected (0.013 sec) MariaDB [matriculaescuela]> insert into acudiente(cod_acudiente, nombre, direccion, telefono, e_mail) values("010","HENAO RIOS DORA EMILSE", "barrio el limonar 2", "2866222", "dorahenao.com"); Query OK, 1 row affected (0.012 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 | | 006 | ORTIZ PUERTA INDIRA | Urbanizacion ciudadela prado | 5841497 | indiraortiz.com | | 007 | QUINTERO MENESES ADRIANA MARIA | barrio sangabriel | 5840570 | adrianaquintero.com | | 008 | MONTOYA RIVERA EDILMA | barrio la pradera | 3767289 | edilmamontoya.com | | 009 | LOPERA MONSALVE FERNANDO ALONSO | barrio el limonar 1 | 5709957 | fernandolopera.com | | 010 | HENAO RIOS DORA EMILSE | barrio el limonar 2 | 2866222 | dorahenao.com | +---------------+---------------------------------+------------------------------+----------+--------------------------+ 10 rows in set (0.003 sec) MariaDB [matriculaescuela]> insert into estudiante values('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'),('00006','LZATE ORTIZ JORGE MARIO','Urbanizaci n ciudadela prado',5841497,'marioalzae@gmail.com'),('00007','ZAPATA QUINTERO JOSE MARIA','Barrio Sangabriel',5840570,'josezapata@gmail.com'),('00008','MONTOYA MONTOYA AEJANDRO','Barrio la pradera',3767289,'alejandromontoya@gmail.com'),('00009','LOPERA CARTAGENA LUISA FENANADA','Barrio el limonar 1',5709957,'luisalopera@gmail.com'),('00010','JARAMILLO HENAO JOSE LUIS','Barrio el limonar 2',2866222,'josearamillo@gmail.com'),('00011','ALVAREZ AGUDELO LUNA','Barrio rosaleda',5882104,'lunaalvarez@gmail.com'),('00012','ALVAREZ AGUDELO XAVIER','Barrio rosaleda',5882104,'xavieralvarez@gmail.com'); Query OK, 12 rows affected (0.012 sec) Records: 12 Duplicates: 0 Warnings: 0 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 | | 00006 | LZATE ORTIZ JORGE MARIO | Urbanizaci n ciudadela prado | 5841497 | marioalzae@gmail.com | | 00007 | ZAPATA QUINTERO JOSE MARIA | Barrio Sangabriel | 5840570 | josezapata@gmail.com | | 00008 | MONTOYA MONTOYA AEJANDRO | Barrio la pradera | 3767289 | alejandromontoya@gmail.com | | 00009 | LOPERA CARTAGENA LUISA FENANADA | Barrio el limonar 1 | 5709957 | luisalopera@gmail.com | | 00010 | JARAMILLO HENAO JOSE LUIS | Barrio el limonar 2 | 2866222 | josearamillo@gmail.com | | 00011 | ALVAREZ AGUDELO LUNA | Barrio rosaleda | 5882104 | lunaalvarez@gmail.com | | 00012 | ALVAREZ AGUDELO XAVIER | Barrio rosaleda | 5882104 | xavieralvarez@gmail.com | +----------------+---------------------------------+------------------------------+----------+-----------------------------+ 12 rows in set (0.001 sec) MariaDB [matriculaescuela]> insert into materia values('01','ESPA OL'),('02','LECTOESCRITURA'),('03','MATEMATICAS'),('04','CIENCIAS NATURALES'),('05','INVESTIGACION'),('06','FISICA'),('07','FILOSOFIA'),('08','EDUCACION FISICA'),('09','ETICA'),('10','ARTISTICA'),('11','TECNOLOGIA'),('12','INFORMATCA'),('13','RELIGION'),('14','SOCIALES'),('15','INGLES'); Query OK, 15 rows affected (0.014 sec) Records: 15 Duplicates: 0 Warnings: 0 MariaDB [matriculaescuela]> select * from materia; +-------------+--------------------+ | Cod_Materia | Nombre | +-------------+--------------------+ | 01 | ESPAÑOL | | 02 | LECTOESCRITURA | | 03 | MATEMATICAS | | 04 | CIENCIAS NATURALES | | 05 | INVESTIGACION | | 06 | FISICA | | 07 | FILOSOFIA | | 08 | EDUCACION FISICA | | 09 | ETICA | | 10 | ARTISTICA | | 11 | TECNOLOGIA | | 12 | INFORMATCA | | 13 | RELIGION | | 14 | SOCIALES | | 15 | INGLES | +-------------+--------------------+ 15 rows in set (0.002 sec) MariaDB [matriculaescuela]> insert into materia values('01','ESPAÑOL'),('02','LECTOESCRITURA'),('03','MATEMATICAS'),('04','CIENCIAS NATURALES'),('05','INVESTIGACION'),('06','FISICA'),('07','FILOSOFIA'),('08','EDUCACION FISICA'),('09','ETICA'),('10','ARTISTICA'),('11','TECNOLOGIA'),('12','INFORMATCA'),('13','RELIGION'),('14','SOCIALES'),('15','INGLES'); ERROR 1062 (23000): Duplicate entry '01' for key 'PRIMARY' MariaDB [matriculaescuela]> insert into profesor values('001','CIFUENTES MESA MYEIDY MARIA','',0,'myleidym.iearm@gmail.com'),('002','CUADRADO PEREZ ADRID JOSE','',0,'adrid.iearm@gmail.com'),('003','DUQUE RESTREPO ESTER LUCIA','',0,'esterl.iearm@gmail.com'),('004','GUIRALES MAURICIO','',0,'mauriciog.iearm@gmail.com'),('005','VERA DAZA MARIA ELENA','',0,'mariae.iearm@gmail.com'),('006','PALACIO TOMAS FELIPE','',0,'tomasf.iearm@gmail.com'),('007','MOSUERA OSORIO MARYETH','',0,'maryeth.iearm@gmail.com'),('008','ARBOLEDA VARGAS MARIA OFELIA','',0,'ofeliaa.iearm@gmail.com'),('009','MOSCOTE MARULANDA YANET MARIA','',0,'yanetm.iearm@gmail.com'),('010','MACIAS EDGAR ALBERTO','',0,'edgarm.iearm@gmail.com'); Query OK, 10 rows affected (0.003 sec) Records: 10 Duplicates: 0 Warnings: 0 MariaDB [matriculaescuela]> select * from profesor; +--------------+-------------------------------+-----------+----------+---------------------------+ | Cod_Profesor | Nombre | Direccion | Telefono | E_mail | +--------------+-------------------------------+-----------+----------+---------------------------+ | 001 | CIFUENTES MESA MYEIDY MARIA | | 0 | myleidym.iearm@gmail.com | | 002 | CUADRADO PEREZ ADRID JOSE | | 0 | adrid.iearm@gmail.com | | 003 | DUQUE RESTREPO ESTER LUCIA | | 0 | esterl.iearm@gmail.com | | 004 | GUIRALES MAURICIO | | 0 | mauriciog.iearm@gmail.com | | 005 | VERA DAZA MARIA ELENA | | 0 | mariae.iearm@gmail.com | | 006 | PALACIO TOMAS FELIPE | | 0 | tomasf.iearm@gmail.com | | 007 | MOSUERA OSORIO MARYETH | | 0 | maryeth.iearm@gmail.com | | 008 | ARBOLEDA VARGAS MARIA OFELIA | | 0 | ofeliaa.iearm@gmail.com | | 009 | MOSCOTE MARULANDA YANET MARIA | | 0 | yanetm.iearm@gmail.com | | 010 | MACIAS EDGAR ALBERTO | | 0 | edgarm.iearm@gmail.com | +--------------+-------------------------------+-----------+----------+---------------------------+ 10 rows in set (0.001 sec) MariaDB [matriculaescuela]> insert into profesor(cod_profesor, nombre, direccion, telefono, e_mail) values("01","CIFUENTES MESA MYEIDY MARIA", "Urba nizacion compartir", "2868617", "myleidym.iearm@gmail.com"); Query OK, 1 row affected (0.014 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 | | 006 | ORTIZ PUERTA INDIRA | Urbanizacion ciudadela prado | 5841497 | indiraortiz.com | | 007 | QUINTERO MENESES ADRIANA MARIA | barrio sangabriel | 5840570 | adrianaquintero.com | | 008 | MONTOYA RIVERA EDILMA | barrio la pradera | 3767289 | edilmamontoya.com | | 009 | LOPERA MONSALVE FERNANDO ALONSO | barrio el limonar 1 | 5709957 | fernandolopera.com | | 010 | HENAO RIOS DORA EMILSE | barrio el limonar 2 | 2866222 | dorahenao.com | +---------------+---------------------------------+------------------------------+----------+--------------------------+ 10 rows in set (0.001 sec) MariaDB [matriculaescuela]> insert into Estudiante_Materia values('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'),('00003','01'),('00003','02'),('00003','03'),('00003','04'),('00003','05'),('00003','06'),('00003','07'),('00003','08'),('00003','09'),('00003','10'),('00003','11'),('00003','12'),('00003','13'),('00003','14'),('00003','15'),('00004','01'),('00004','02'),('00004','03'),('00004','04'),('00004','05'),('00004','06'),('00004','07'),('00004','08'),('00004','09'),('00004','10'),('00004','11'),('00004','12'),('00004','13'),('00004','14'),('00004','15'),('00005','01'),('00005','02'),('00005','03'),('00005','04'),('00005','05'),('00005','06'),('00005','07'),('00005','08'),('00005','09'),('00005','10'),('00005','11'),('00005','12'),('00005','13'),('00005','14'),('00005','15'),('00006','01'),('00006','02'),('00006','03'),('00006','04'),('00006','05'),('00006','06'),('00006','07'),('00006','08'),('00006','09'),('00006','10'),('00006','11'),('00006','12'),('00006','13'),('00006','14'),('00006','15'); Query OK, 90 rows affected (0.018 sec) Records: 90 Duplicates: 0 Warnings: 0 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 | | 00003 | 01 | | 00003 | 02 | | 00003 | 03 | | 00003 | 04 | | 00003 | 05 | | 00003 | 06 | | 00003 | 07 | | 00003 | 08 | | 00003 | 09 | | 00003 | 10 | | 00003 | 11 | | 00003 | 12 | | 00003 | 13 | | 00003 | 14 | | 00003 | 15 | | 00004 | 01 | | 00004 | 02 | | 00004 | 03 | | 00004 | 04 | | 00004 | 05 | | 00004 | 06 | | 00004 | 07 | | 00004 | 08 | | 00004 | 09 | | 00004 | 10 | | 00004 | 11 | | 00004 | 12 | | 00004 | 13 | | 00004 | 14 | | 00004 | 15 | | 00005 | 01 | | 00005 | 02 | | 00005 | 03 | | 00005 | 04 | | 00005 | 05 | | 00005 | 06 | | 00005 | 07 | | 00005 | 08 | | 00005 | 09 | | 00005 | 10 | | 00005 | 11 | | 00005 | 12 | | 00005 | 13 | | 00005 | 14 | | 00005 | 15 | | 00006 | 01 | | 00006 | 02 | | 00006 | 03 | | 00006 | 04 | | 00006 | 05 | | 00006 | 06 | | 00006 | 07 | | 00006 | 08 | | 00006 | 09 | | 00006 | 10 | | 00006 | 11 | | 00006 | 12 | | 00006 | 13 | | 00006 | 14 | | 00006 | 15 | +----------------+-------------+ 90 rows in set (0.001 sec) MariaDB [matriculaescuela]> insert into materia_profesor values('01','005'),('02','007'),('03','009'),('04','003'),('05','003'),('06','003'),('07','001'),('08','010'),('09','006'),('10','004'),('11','002'),('12','002'),('13','006'),('14','007'),('15','008'); Query OK, 15 rows affected (0.016 sec) Records: 15 Duplicates: 0 Warnings: 0 MariaDB [matriculaescuela]> select * from materia_profesor; +-------------+--------------+ | Cod_Materia | Cod_Profesor | +-------------+--------------+ | 01 | 005 | | 02 | 007 | | 03 | 009 | | 04 | 003 | | 05 | 003 | | 06 | 003 | | 07 | 001 | | 08 | 010 | | 09 | 006 | | 10 | 004 | | 11 | 002 | | 12 | 002 | | 13 | 006 | | 14 | 007 | | 15 | 008 | +-------------+--------------+ 15 rows in set (0.001 sec) MariaDB [matricula1]> insert into estudiante_acudiente values('001','00001'),('002','00002'),('003','00003'),('004','00004'),('005','00005'),('006','00006'),('007','00007'),('008','00008'),('009','00009'),('010','00010'),('001','00011'),('001','00012'); Query OK, 12 rows affected (0.007 sec) Records: 12 Duplicates: 0 Warnings: 0 MariaDB [matricula1]> select * from estudiante_acudiente; +--------------+---------------+ | Cod_Acudiente | FK_Estudiante | +--------------+---------------+ | 001 | 00001 | | 002 | 00002 | | 003 | 00003 | | 004 | 00004 | | 005 | 00005 | | 006 | 00006 | | 007 | 00007 | | 008 | 00008 | | 009 | 00009 | | 010 | 00010 | | 001 | 00011 | | 001 | 00012 | +--------------+---------------+ 12 rows in set (0.000 sec) MariaDB [matricula1]> exit