MariaDB [(none)]> create database institucion -> ; Query OK, 1 row affected (0.001 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | institucion | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 6 rows in set (0.001 sec) MariaDB [(none)]> use institucion; Database changed MariaDB [institucion]> create table estudiante( -> codigo int(5) not null primary key, -> nombre varchar(25) not null, -> direccion varchar(50) not null, -> telefono int(12) not null, -> e_mail varchar(50) not null); Query OK, 0 rows affected (0.284 sec) MariaDB [institucion]> create table acudiente( -> codigo int(5) not null primary key, -> nombre varchar(25) not null, -> direccion varchar(50) not null, -> telefono int(12) not null, -> e_mail varchar(50) not null); Query OK, 0 rows affected (0.186 sec) MariaDB [institucion]> create table profesor( -> codigo int(5) not null primary key, -> nombre varchar(25) not null, -> direccion varchar(50) not null, -> telefono int(12) not null, -> e_mail varchar(50) not null); Query OK, 0 rows affected (0.211 sec) MariaDB [institucion]> create table materia( -> codigo int(5) not null primary key, -> nombre varchar(25) not null); Query OK, 0 rows affected (0.234 sec) MariaDB [institucion]> show tables; +-----------------------+ | Tables_in_institucion | +-----------------------+ | acudiente | | estudiante | | materia | | profesor | +-----------------------+ 4 rows in set (0.014 sec) MariaDB [institucion]> describe acudiente; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigo | int(5) | NO | PRI | NULL | | | nombre | varchar(25) | NO | | NULL | | | direccion | varchar(50) | NO | | NULL | | | telefono | int(12) | NO | | NULL | | | e_mail | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.064 sec) MariaDB [institucion]> describe estudiante; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigo | int(5) | NO | PRI | NULL | | | nombre | varchar(25) | NO | | NULL | | | direccion | varchar(50) | NO | | NULL | | | telefono | int(12) | NO | | NULL | | | e_mail | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.010 sec) MariaDB [institucion]> describe profesor; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigo | int(5) | NO | PRI | NULL | | | nombre | varchar(25) | NO | | NULL | | | direccion | varchar(50) | NO | | NULL | | | telefono | int(12) | NO | | NULL | | | e_mail | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.010 sec) MariaDB [institucion]> describe materia; +--------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------+-------------+------+-----+---------+-------+ | codigo | int(5) | NO | PRI | NULL | | | nombre | varchar(25) | NO | | NULL | | +--------+-------------+------+-----+---------+-------+ 2 rows in set (0.020 sec) MariaDB [institucion]> create table estudi_acu( -> cod_estudiante int(5) not null, -> cod_acudiente int(5) not null, -> foreign key(cod_estudiante) references estudiante(codigo) on delete cascade on update cascade, -> foreign key(cod_acudiente) references acudiente(codigo) on delete cascade on update cascade); Query OK, 0 rows affected (0.410 sec) MariaDB [institucion]> describe estudi_Acu; +----------------+--------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------+------+-----+---------+-------+ | cod_estudiante | int(5) | NO | MUL | NULL | | | cod_acudiente | int(5) | NO | MUL | NULL | | +----------------+--------+------+-----+---------+-------+ 2 rows in set (0.013 sec) MariaDB [institucion]> create table estudi_mat( -> cod_estudiante int(5) not null, -> cod_materia int(5) not null, -> foreign key(cod_estudiante) references estudiante(codigo) on delete cascade on update cascade, -> foreign key(cod_materia) references materia(codigo) on delete cascade on update cascade); Query OK, 0 rows affected (0.315 sec) MariaDB [institucion]> describe estudi_mat; +----------------+--------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------+------+-----+---------+-------+ | cod_estudiante | int(5) | NO | MUL | NULL | | | cod_materia | int(5) | NO | MUL | NULL | | +----------------+--------+------+-----+---------+-------+ 2 rows in set (0.010 sec) MariaDB [institucion]> create table materia_profe( -> cod_materia int(5) not null, -> cod_profesor int(5) not null, -> foreign key(cod_materia) references materia(codigo) on delete cascade on update cascade); Query OK, 0 rows affected (0.148 sec) MariaDB [institucion]> drop table materia_profe; Query OK, 0 rows affected (0.151 sec) MariaDB [institucion]> create table materia_profe( -> cod_materia int(5) not null, -> cod_profesor int(5) not null, -> foreign key(cod_materia) references materia(codigo) on delete cascade on update cascade); Query OK, 0 rows affected (0.266 sec) MariaDB [institucion]> drop table materia_profe; Query OK, 0 rows affected (0.106 sec) MariaDB [institucion]> create table materia_profe( -> cod_materia int(5) not null, -> cod_profesor int(5) not null, -> foreign key(cod_materia) references materia(codigo) on delete cascade on update cascade, -> foreign key(cod_profesor) references profesor(codigo) on delete cascade on update cascade); Query OK, 0 rows affected (0.154 sec) MariaDB [institucion]> show tables; +-----------------------+ | Tables_in_institucion | +-----------------------+ | acudiente | | estudi_acu | | estudi_mat | | estudiante | | materia | | materia_profe | | profesor | +-----------------------+ 7 rows in set (0.000 sec) MariaDB [institucion]> describe estudi_acu; +----------------+--------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------+------+-----+---------+-------+ | cod_estudiante | int(5) | NO | MUL | NULL | | | cod_acudiente | int(5) | NO | MUL | NULL | | +----------------+--------+------+-----+---------+-------+ 2 rows in set (0.009 sec) MariaDB [institucion]> describe estudi_mat; +----------------+--------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+--------+------+-----+---------+-------+ | cod_estudiante | int(5) | NO | MUL | NULL | | | cod_materia | int(5) | NO | MUL | NULL | | +----------------+--------+------+-----+---------+-------+ 2 rows in set (0.007 sec) MariaDB [institucion]> describe materia_profe; +--------------+--------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+--------+------+-----+---------+-------+ | cod_materia | int(5) | NO | MUL | NULL | | | cod_profesor | int(5) | NO | MUL | NULL | | +--------------+--------+------+-----+---------+-------+ 2 rows in set (0.010 sec) MariaDB [institucion]> insert into estudiante(codigo,nombre,direccion,telefono,e_mail) -> values(001,'Acevedo Cardona Esteban','Barrio la Pradera',5846063,'estebacardona@gmail.com'); Query OK, 1 row affected (0.072 sec) MariaDB [institucion]> insert into estudiante(codigo,nombre,direccion,telefono,e_mail) -> values(002,'Agudelo Manco Diana','Barrio Rosaleda',5882104,'dianapatricia@gmail.com'); Query OK, 1 row affected (0.053 sec) MariaDB [institucion]> select * from estudiante; +--------+-------------------------+-------------------+----------+-------------------------+ | codigo | nombre | direccion | telefono | e_mail | +--------+-------------------------+-------------------+----------+-------------------------+ | 1 | Acevedo Cardona Esteban | Barrio la Pradera | 5846063 | estebacardona@gmail.com | | 2 | Agudelo Manco Diana | Barrio Rosaleda | 5882104 | dianapatricia@gmail.com | +--------+-------------------------+-------------------+----------+-------------------------+ 2 rows in set (0.015 sec) MariaDB [institucion]> insert into estudiante(codigo,nombre,direccion,telefono,e_mail) -> values(003,'Zapata Valencia Jorge','Barrio Aragon',5841998,'jorgezapata@gmail.com'); Query OK, 1 row affected (0.049 sec) MariaDB [institucion]> insert into estudiante(codigo,nombre,direccion,telefono,e_mail) -> values(004,'Velasquez Cano Jenny','Barrio la Pradera',2791469,'jennyvelasquez@gmail.com'); Query OK, 1 row affected (0.062 sec) MariaDB [institucion]> insert into estudiante(codigo,nombre,direccion,telefono,e_mail) -> values(005,'Posada Vasco Ana','Urbanizacion Compartir',2868617,'anaposada@gmail.com'); Query OK, 1 row affected (0.035 sec) MariaDB [institucion]> select * from estudiante; +--------+-------------------------+------------------------+----------+--------------------------+ | codigo | nombre | direccion | telefono | e_mail | +--------+-------------------------+------------------------+----------+--------------------------+ | 1 | Acevedo Cardona Esteban | Barrio la Pradera | 5846063 | estebacardona@gmail.com | | 2 | Agudelo Manco Diana | Barrio Rosaleda | 5882104 | dianapatricia@gmail.com | | 3 | Zapata Valencia Jorge | Barrio Aragon | 5841998 | jorgezapata@gmail.com | | 4 | Velasquez Cano Jenny | Barrio la Pradera | 2791469 | jennyvelasquez@gmail.com | | 5 | Posada Vasco Ana | Urbanizacion Compartir | 2868617 | anaposada@gmail.com | +--------+-------------------------+------------------------+----------+--------------------------+ 5 rows in set (0.000 sec) MariaDB [institucion]> insert into estudiante(codigo,nombre,direccion,telefono,e_mail) -> values(006,'Ortiz Puerta Indira','Urbanizacin Ciudadela Prado',5841497,'indiraortiz@gmail.com'); Query OK, 1 row affected (0.083 sec) MariaDB [institucion]> insert into estudiante(codigo,nombre,direccion,telefono,e_mail) -> values(007,'Quintero Meneses Adriana','Barrio Sangabriel',5840570,'adrianaquintero@gmail.com'); Query OK, 1 row affected (0.028 sec) MariaDB [institucion]> insert into estudiante(codigo,nombre,direccion,telefono,e_mail) -> values(008,'Montoya Rivera Edilma','Barrio la Pradera',3767289,'edilmamontoya@gmail.com'); Query OK, 1 row affected (0.047 sec) MariaDB [institucion]> insert into estudiante(codigo,nombre,direccion,telefono,e_mail) -> values(009,'Lopera Monsalve Fernando','Barrio el Limonar',15709957,'fernandolopera@gmail.com'); Query OK, 1 row affected (0.062 sec) MariaDB [institucion]> insert into estudiante(codigo,nombre,direccion,telefono,e_mail) -> values(010,'Henao Rios Dora','Barrio el Limonar',22866222,'dorahenao@gmail.com'); Query OK, 1 row affected (0.065 sec) MariaDB [institucion]> select * from estudiante; +--------+--------------------------+------------------------------+----------+---------------------------+ | codigo | nombre | direccion | telefono | e_mail | +--------+--------------------------+------------------------------+----------+---------------------------+ | 1 | Acevedo Cardona Esteban | Barrio la Pradera | 5846063 | estebacardona@gmail.com | | 2 | Agudelo Manco Diana | Barrio Rosaleda | 5882104 | dianapatricia@gmail.com | | 3 | Zapata Valencia Jorge | Barrio Aragon | 5841998 | jorgezapata@gmail.com | | 4 | Velasquez Cano Jenny | Barrio la Pradera | 2791469 | jennyvelasquez@gmail.com | | 5 | Posada Vasco Ana | Urbanizacion Compartir | 2868617 | anaposada@gmail.com | | 6 | Ortiz Puerta Indira | Urbanizacin Ciudadela Prado | 5841497 | indiraortiz@gmail.com | | 7 | Quintero Meneses Adriana | Barrio Sangabriel | 5840570 | adrianaquintero@gmail.com | | 8 | Montoya Rivera Edilma | Barrio la Pradera | 3767289 | edilmamontoya@gmail.com | | 9 | Lopera Monsalve Fernando | Barrio el Limonar | 15709957 | fernandolopera@gmail.com | | 10 | Henao Rios Dora | Barrio el Limonar | 22866222 | dorahenao@gmail.com | +--------+--------------------------+------------------------------+----------+---------------------------+ 10 rows in set (0.013 sec) MariaDB [institucion]> insert into acudiente(codigo,nombre,direccion,telefono,e_mail) -> values(00001,'Acevedo Buritica Juan','Barrio la Pradera',5846069,'juanestebacardona@gmail.com'); Query OK, 1 row affected (0.041 sec) MariaDB [institucion]> insert into acudiente(codigo,nombre,direccion,telefono,e_mail) -> values(00002,'Alvarez Agudelo Esteban','Barrio Rosaleda',5882104,'estebanlavarez@gmail.com'); Query OK, 1 row affected (0.054 sec) MariaDB [institucion]> insert into acudiente(codigo,nombre,direccion,telefono,e_mail) -> values(00003,'Zapata Campio Isabel','Barrio Aragon',5841998,'zapataisabel@gmail.com'); Query OK, 1 row affected (0.048 sec) MariaDB [institucion]> insert into acudiente(codigo,nombre,direccion,telefono,e_mail) -> values(00004,'Valle Velasquez Sofia','Barrio la Pradera',2791469,'sofiavelasquez@gmail.com'); Query OK, 1 row affected (0.026 sec) MariaDB [institucion]> insert into acudiente(codigo,nombre,direccion,telefono,e_mail) -> values(00005,'Moreno Posada Diego','Urbanizacion Compartir',2868617,'diegomoreno@gmail.com'); Query OK, 1 row affected (0.080 sec) MariaDB [institucion]> insert into acudiente(codigo,nombre,direccion,telefono,e_mail) -> values(00006,'Alzate Ortiz Mario','Urbanizacin Ciudadela Prado',5841497,'marioalzae@gmail.com'); Query OK, 1 row affected (0.048 sec) MariaDB [institucion]> insert into acudiente(codigo,nombre,direccion,telefono,e_mail) -> values(00007,'Zapata Quintero Jose','Barrio Sangabriel',5840570,'josezapata@gmail.com'); Query OK, 1 row affected (0.047 sec) MariaDB [institucion]> insert into acudiente(codigo,nombre,direccion,telefono,e_mail) -> values(00008,'Montoya Montoya Alejandro','Barrio la Pradera',3767289,'alejandromontoya@gmail.com'); Query OK, 1 row affected (0.051 sec) ariaDB [institucion]> insert into acudiente(codigo,nombre,direccion,telefono,e_mail) -> values(00009,'Lopera Cartagena Luisa','Barrio el Limonar',15709957,'luisalopera@gmail.com'); Query OK, 1 row affected (0.025 sec) MariaDB [institucion]> insert into acudiente(codigo,nombre,direccion,telefono,e_mail) -> values(00010,'Jaramillo Henao Jose','Barrio el Limonar',22866222,'josearamillo@gmail.com'); Query OK, 1 row affected (0.026 sec) MariaDB [institucion]> select * from acudiente; +--------+---------------------------+------------------------------+----------+-----------------------------+ | codigo | nombre | direccion | telefono | e_mail | +--------+---------------------------+------------------------------+----------+-----------------------------+ | 1 | Acevedo Buritica Juan | Barrio la Pradera | 5846069 | juanestebacardona@gmail.com | | 2 | Alvarez Agudelo Esteban | Barrio Rosaleda | 5882104 | estebanlavarez@gmail.com | | 3 | Zapata Campio Isabel | Barrio Aragon | 5841998 | zapataisabel@gmail.com | | 4 | Valle Velasquez Sofia | Barrio la Pradera | 2791469 | sofiavelasquez@gmail.com | | 5 | Moreno Posada Diego | Urbanizacion Compartir | 2868617 | diegomoreno@gmail.com | | 6 | Alzate Ortiz Mario | Urbanizacin Ciudadela Prado | 5841497 | marioalzae@gmail.com | | 7 | Zapata Quintero Jose | Barrio Sangabriel | 5840570 | josezapata@gmail.com | | 8 | Montoya Montoya Alejandro | Barrio la Pradera | 3767289 | alejandromontoya@gmail.com | | 9 | Lopera Cartagena Luisa | Barrio el Limonar | 15709957 | luisalopera@gmail.com | | 10 | Jaramillo Henao Jose | Barrio el Limonar | 22866222 | josearamillo@gmail.com | +--------+---------------------------+------------------------------+----------+-----------------------------+ 10 rows in set (0.000 sec) MariaDB [institucion]> insert into materia(codigo,nombre) -> values(1,'Espaol'); Query OK, 1 row affected (0.043 sec) MariaDB [institucion]> insert into materia(codigo,nombre) -> values(2,'Lectoescritura'); Query OK, 1 row affected (0.042 sec) MariaDB [institucion]> insert into materia(codigo,nombre) -> values(3,'Matematicas'); Query OK, 1 row affected (0.029 sec) MariaDB [institucion]> insert into materia(codigo,nombre) -> values(4,'Ciencias Naturales'); Query OK, 1 row affected (0.036 sec) MariaDB [institucion]> insert into materia(codigo,nombre) -> values(5,'Investigacin'); Query OK, 1 row affected (0.031 sec) MariaDB [institucion]> insert into materia(codigo,nombre) -> values(6,'Filosofia'); Query OK, 1 row affected (0.036 sec) MariaDB [institucion]> insert into materia(codigo,nombre) -> values(7,'Educacin Fsica'); Query OK, 1 row affected (0.028 sec) MariaDB [institucion]> insert into materia(codigo,nombre) -> values(8,'Fsica'); Query OK, 1 row affected (0.036 sec) MariaDB [institucion]> insert into materia(codigo,nombre) -> values(9,'tica'); Query OK, 1 row affected (0.045 sec) MariaDB [institucion]> insert into materia(codigo,nombre) -> values(10,'Artistica'); Query OK, 1 row affected (0.035 sec) MariaDB [institucion]> select * from materia; +--------+--------------------+ | codigo | nombre | +--------+--------------------+ | 1 | Espaol | | 2 | Lectoescritura | | 3 | Matematicas | | 4 | Ciencias Naturales | | 5 | Investigacin | | 6 | Filosofia | | 7 | Educacin Fsica | | 8 | Fsica | | 9 | tica | | 10 | Artistica | +--------+--------------------+ 10 rows in set (0.000 sec) MariaDB [institucion]> describe profesor; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigo | int(5) | NO | PRI | NULL | | | nombre | varchar(25) | NO | | NULL | | | direccion | varchar(50) | NO | | NULL | | | telefono | int(12) | NO | | NULL | | | e_mail | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.010 sec) MariaDB [institucion]> show tables; +-----------------------+ | Tables_in_institucion | +-----------------------+ | acudiente | | estudi_acu | | estudi_mat | | estudiante | | materia | | materia_profe | | profesor | +-----------------------+ 7 rows in set (0.001 sec) MariaDB [institucion]> drop table materia_profe; Query OK, 0 rows affected (0.164 sec) MariaDB [institucion]> drop table profesor; Query OK, 0 rows affected (0.117 sec) MariaDB [institucion]> create table profesor( -> codigo int(5) not null primary key, -> nombre varchar(25) not null, -> direccion varchar(50) null, -> telefono int(12) null, -> e_mail varchar(50) not null); Query OK, 0 rows affected (0.184 sec) MariaDB [institucion]> describe profesor; +-----------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------+-------------+------+-----+---------+-------+ | codigo | int(5) | NO | PRI | NULL | | | nombre | varchar(25) | NO | | NULL | | | direccion | varchar(50) | YES | | NULL | | | telefono | int(12) | YES | | NULL | | | e_mail | varchar(50) | NO | | NULL | | +-----------+-------------+------+-----+---------+-------+ 5 rows in set (0.011 sec) MariaDB [institucion]> create table materia_profe( -> codigo_materia int(5) not null, -> codigo_profesor int(5) not null, -> foreign key(codigo_materia) references materia(codigo) on delete cascade on update cascade, -> foreign key(codigo_profesor) references profesor(codigo) on delete cascade on update cascade); Query OK, 0 rows affected (0.192 sec) MariaDB [institucion]> insert into profesor(codigo,nombre,e_mail) -> values(001,'Cifuentes Mesa Myeidy','myleidym.iearm@gmail.com'); Query OK, 1 row affected (0.041 sec) MariaDB [institucion]> insert into profesor(codigo,nombre,e_mail) -> values(002,'Cuadrado Perez Adrid','adrid.iearm@gmail.com'); Query OK, 1 row affected (0.047 sec) MariaDB [institucion]> insert into profesor(codigo,nombre,e_mail) -> values(003,'Duque Restrepo Ester','esterl.iearm@gmail.com'); Query OK, 1 row affected (0.077 sec) MariaDB [institucion]> insert into profesor(codigo,nombre,e_mail) -> values(0004,'Guirales Mauricio','mauriciog.iearm@gmail.com'); Query OK, 1 row affected (0.035 sec) MariaDB [institucion]> insert into profesor(codigo,nombre,e_mail) -> values(005,'Vera Daza Maria','mariae.iearm@gmail.com'); Query OK, 1 row affected (0.034 sec) MariaDB [institucion]> insert into profesor(codigo,nombre,e_mail) -> values(006,'Palacio Tomas Felipe','tomasf.iearm@gmail.com'); Query OK, 1 row affected (0.027 sec) MariaDB [institucion]> insert into profesor(codigo,nombre,e_mail) -> values(007,'Mosuera Osorio Maryeth','maryeth.iearm@gmail.com'); Query OK, 1 row affected (0.035 sec) MariaDB [institucion]> insert into profesor(codigo,nombre,e_mail) -> values(008,'Arboleda Vargas Ofelia','ofeliaa.iearm@gmail.com'); Query OK, 1 row affected (0.063 sec) MariaDB [institucion]> insert into profesor(codigo,nombre,e_mail) -> values(009,'Moscote Marulanda Yanet','yanetm.iearm@gmail.com'); Query OK, 1 row affected (0.022 sec) MariaDB [institucion]> insert into profesor(codigo,nombre,e_mail) -> values(010,'Macias Edgar Alberto','edgarm.iearm@gmail.com'); Query OK, 1 row affected (0.038 sec) MariaDB [institucion]> select * from profesor; +--------+-------------------------+-----------+----------+---------------------------+ | codigo | nombre | direccion | telefono | e_mail | +--------+-------------------------+-----------+----------+---------------------------+ | 1 | Cifuentes Mesa Myeidy | NULL | NULL | myleidym.iearm@gmail.com | | 2 | Cuadrado Perez Adrid | NULL | NULL | adrid.iearm@gmail.com | | 3 | Duque Restrepo Ester | NULL | NULL | esterl.iearm@gmail.com | | 4 | Guirales Mauricio | NULL | NULL | mauriciog.iearm@gmail.com | | 5 | Vera Daza Maria | NULL | NULL | mariae.iearm@gmail.com | | 6 | Palacio Tomas Felipe | NULL | NULL | tomasf.iearm@gmail.com | | 7 | Mosuera Osorio Maryeth | NULL | NULL | maryeth.iearm@gmail.com | | 8 | Arboleda Vargas Ofelia | NULL | NULL | ofeliaa.iearm@gmail.com | | 9 | Moscote Marulanda Yanet | NULL | NULL | yanetm.iearm@gmail.com | | 10 | Macias Edgar Alberto | NULL | NULL | edgarm.iearm@gmail.com | +--------+-------------------------+-----------+----------+---------------------------+ 10 rows in set (0.000 sec) MariaDB [institucion]> show tables; +-----------------------+ | Tables_in_institucion | +-----------------------+ | acudiente | | estudi_acu | | estudi_mat | | estudiante | | materia | | materia_profe | | profesor | +-----------------------+ 7 rows in set (0.001 sec) MariaDB [institucion]> insert into estudi_acu(cod_estudiante,cod_acudiente) -> values(1,1); Query OK, 1 row affected (0.077 sec) MariaDB [institucion]> insert into estudi_acu(cod_estudiante,cod_acudiente) -> values(2,2); Query OK, 1 row affected (0.040 sec) MariaDB [institucion]> insert into estudi_acu(cod_estudiante,cod_acudiente) -> values(3,3); Query OK, 1 row affected (0.039 sec) MariaDB [institucion]> insert into estudi_acu(cod_estudiante,cod_acudiente) -> values(4,4); Query OK, 1 row affected (0.045 sec) MariaDB [institucion]> insert into estudi_acu(cod_estudiante,cod_acudiente) -> values(5,5); Query OK, 1 row affected (0.028 sec) MariaDB [institucion]> insert into estudi_acu(cod_estudiante,cod_acudiente) -> values(6,6); Query OK, 1 row affected (0.039 sec) MariaDB [institucion]> insert into estudi_acu(cod_estudiante,cod_acudiente) -> values(7,7); Query OK, 1 row affected (0.033 sec) MariaDB [institucion]> insert into estudi_acu(cod_estudiante,cod_acudiente) -> values(8,8); Query OK, 1 row affected (0.033 sec) MariaDB [institucion]> insert into estudi_acu(cod_estudiante,cod_acudiente) -> values(9,9); Query OK, 1 row affected (0.027 sec) MariaDB [institucion]> insert into estudi_acu(cod_estudiante,cod_acudiente) -> values(10,10); Query OK, 1 row affected (0.023 sec) MariaDB [institucion]> select * from estudi_Acu; +----------------+---------------+ | cod_estudiante | cod_acudiente | +----------------+---------------+ | 1 | 1 | | 2 | 2 | | 3 | 3 | | 4 | 4 | | 5 | 5 | | 6 | 6 | | 7 | 7 | | 8 | 8 | | 9 | 9 | | 10 | 10 | +----------------+---------------+ 10 rows in set (0.000 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(1,1); Query OK, 1 row affected (0.094 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(1,3); Query OK, 1 row affected (0.050 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(1,7); Query OK, 1 row affected (0.035 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(1,9); Query OK, 1 row affected (0.033 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(2,3); Query OK, 1 row affected (0.024 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(2,5); Query OK, 1 row affected (0.056 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(2,7); Query OK, 1 row affected (0.061 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(2,8); Query OK, 1 row affected (0.045 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(3,4); Query OK, 1 row affected (0.051 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(3,6); Query OK, 1 row affected (0.023 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(3,1); Query OK, 1 row affected (0.029 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(3,3); Query OK, 1 row affected (0.024 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(3,10); Query OK, 1 row affected (0.031 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(4,5); Query OK, 1 row affected (0.064 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(4,6); Query OK, 1 row affected (0.035 sec) MariaDB [institucion]> insert into estudi_mat(cod_estudiante,cod_materia) -> values(4,7); Query OK, 1 row affected (0.057 sec) MariaDB [institucion]> select * from estudi_mat; +----------------+-------------+ | cod_estudiante | cod_materia | +----------------+-------------+ | 1 | 1 | | 1 | 3 | | 1 | 7 | | 1 | 9 | | 2 | 3 | | 2 | 5 | | 2 | 7 | | 2 | 8 | | 3 | 4 | | 3 | 6 | | 3 | 1 | | 3 | 3 | | 3 | 10 | | 4 | 5 | | 4 | 6 | | 4 | 7 | +----------------+-------------+ 16 rows in set (0.000 sec) MariaDB [institucion]> insert into materia_profe(codigo_materia,codigo_profesor) -> values(1,5); Query OK, 1 row affected (0.062 sec) MariaDB [institucion]> insert into materia_profe(cod_materia,cod_profesor) -> values(2,7); ERROR 1054 (42S22): Unknown column 'cod_materia' in 'field list' MariaDB [institucion]> insert into materia_profe(codigo_materia,codigo_profesor) -> values(2,7); Query OK, 1 row affected (0.027 sec) MariaDB [institucion]> insert into materia_profe(codigo_materia,codigo_profesor) -> values(3,9); Query OK, 1 row affected (0.077 sec) MariaDB [institucion]> insert into materia_profe(codigo_materia,codigo_profesor) -> values(4,3); Query OK, 1 row affected (0.021 sec) MariaDB [institucion]> insert into materia_profe(codigo_materia,codigo_profesor) -> values(5,3); Query OK, 1 row affected (0.030 sec) MariaDB [institucion]> insert into materia_profe(codigo_materia,codigo_profesor) -> values(6,3); Query OK, 1 row affected (0.029 sec) MariaDB [institucion]> insert into materia_profe(codigo_materia,codigo_profesor) -> values(7,1); Query OK, 1 row affected (0.031 sec) MariaDB [institucion]> insert into materia_profe(codigo_materia,codigo_profesor) -> values(8,10); Query OK, 1 row affected (0.065 sec) MariaDB [institucion]> insert into materia_profe(codigo_materia,codigo_profesor) -> values(9,6); Query OK, 1 row affected (0.035 sec) MariaDB [institucion]> insert into materia_profe(codigo_materia,codigo_profesor) -> values(10,4); Query OK, 1 row affected (0.056 sec) MariaDB [institucion]> select * from materia_profe; +----------------+-----------------+ | codigo_materia | codigo_profesor | +----------------+-----------------+ | 1 | 5 | | 2 | 7 | | 3 | 9 | | 4 | 3 | | 5 | 3 | | 6 | 3 | | 7 | 1 | | 8 | 10 | | 9 | 6 | | 10 | 4 | +----------------+-----------------+ 10 rows in set (0.000 sec) MariaDB [institucion]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | institucion | | mysql | | performance_schema | | phpmyadmin | | test | +--------------------+ 6 rows in set (0.001 sec) MariaDB [institucion]> exit