MariaDB [(none)]> create database BDMatricula; ERROR 1007 (HY000): Can't create database 'bdmatricula'; database exists MariaDB [(none)]> use BDMatricula; Database changed MariaDB [BDMatricula]> create table Acudiente(codacudiente varchar(4) not null primary key, -> nombre varchar(50) not null, -> direccion varchar(15) not null, -> telefono varchar(10) not null, -> email varchar(20) not null); Query OK, 0 rows affected (0.013 sec) MariaDB [BDMatricula]> desrcibe acudiente; 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 'desrcibe acudiente' at line 1 MariaDB [BDMatricula]> describe acudiente; +--------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------+-------------+------+-----+---------+-------+ | codacudiente | varchar(4) | NO | PRI | NULL | | | nombre | varchar(50) | NO | | NULL | | | direccion | varchar(15) | NO | | NULL | | | telefono | varchar(10) | NO | | NULL | | | email | varchar(20) | NO | | NULL | | +--------------+-------------+------+-----+---------+-------+ 5 rows in set (0.007 sec) MariaDB [BDMatricula]> create table Estudiante(codestudiante varchar(4) not null primary key, -> nombre varchar(50) not null, -> direccion varchar(15) not null, -> telefono varchar(10) not null, -> email varchar(20) not null); Query OK, 0 rows affected (0.012 sec) MariaDB [BDMatricula]> describe estudiante; +---------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+-------------+------+-----+---------+-------+ | codestudiante | varchar(4) | NO | PRI | NULL | | | nombre | varchar(50) | NO | | NULL | | | direccion | varchar(15) | NO | | NULL | | | telefono | varchar(10) | NO | | NULL | | | email | varchar(20) | NO | | NULL | | +---------------+-------------+------+-----+---------+-------+ 5 rows in set (0.004 sec) MariaDB [BDMatricula]> create table Docente(coddocente varchar(4) not null primary key, -> nombre varchar(50) not null, -> direccion varchar(15), -> telefono varchar(10), -> email varchar(20) not null); Query OK, 0 rows affected (0.009 sec) MariaDB [BDMatricula]> describe docente; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | coddocente | varchar(4) | NO | PRI | NULL | | | nombre | varchar(50) | NO | | NULL | | | direccion | varchar(15) | YES | | NULL | | | telefono | varchar(10) | YES | | NULL | | | email | varchar(20) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 5 rows in set (0.005 sec) MariaDB [BDMatricula]> create table Materia(codmateria varchar(4) not null primary key, -> nombre varchar(15) not null); Query OK, 0 rows affected (0.010 sec) MariaDB [BDMatricula]> describe materia; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | codmateria | varchar(4) | NO | PRI | NULL | | | nombre | varchar(15) | NO | | NULL | | +------------+-------------+------+-----+---------+-------+ 2 rows in set (0.004 sec) MariaDB [BDMatricula]> create table Estuacu(codestudiante varchar(4) not null, -> codacudiente varchar(4) not null, -> foreign key(codestudiante) references estudiante(codestudiante) on delete cascade on update cascade, -> foreign key(codacudiente) references acudiente(codacudiente) on delete cascade on update cascade); Query OK, 0 rows affected (0.014 sec) MariaDB [BDMatricula]> describe estuacu; +---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | codestudiante | varchar(4) | NO | MUL | NULL | | | codacudiente | varchar(4) | NO | MUL | NULL | | +---------------+------------+------+-----+---------+-------+ 2 rows in set (0.004 sec) MariaDB [BDMatricula]> create table Estudocemate(codestudiante varchar(4) not null, -> coddocente varchar(4) not null, -> codmateria varchar(4) not null, -> foreign key(codestudiante) references estudiante(codestudiante) on delete cascade on update cascade, -> foreign key(coddocente) references docente(coddocente) on delete cascade on update cascade, -> foreign key(codmateria) references materia(codmateria) on delete cascade on update cascade); Query OK, 0 rows affected (0.013 sec) MariaDB [BDMatricula]> describe estudocemate; +---------------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+------------+------+-----+---------+-------+ | codestudiante | varchar(4) | NO | MUL | NULL | | | coddocente | varchar(4) | NO | MUL | NULL | | | codmateria | varchar(4) | NO | MUL | NULL | | +---------------+------------+------+-----+---------+-------+ 3 rows in set (0.004 sec) MariaDB [BDMatricula]> insert into Acudiente(codacudiente, nombre, direccion, telefono, email) values('A01','ACEVEDO CARDONA ESTEBAN', 'Barrio la pradera', '5846069', 'estebacardona@gmail.com'); Query OK, 1 row affected, 2 warnings (0.009 sec) MariaDB [BDMatricula]> insert into Acudiente(codacudiente, nombre, direccion, telefono, email) values('A02','AGUDELO MANCO DIANA PATRICIA', 'Barrio rosaleda', '5882104', 'dianapatricia@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [BDMatricula]> insert into Acudiente(codacudiente, nombre, direccion, telefono, email) values('A03','ZPATA VALENCIA JORGE', 'Barrio Aragon', '5841998', 'jorgezapata@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> insert into Acudiente(codacudiente, nombre, direccion, telefono, email) values('A04','VELASQUEZ CANO JENNY ASTRID', 'Barrio la pradera', '2791469', 'jennyvelasquez@gmail.com'); Query OK, 1 row affected, 2 warnings (0.002 sec) MariaDB [BDMatricula]> insert into Acudiente(codacudiente, nombre, direccion, telefono, email) values('A05','POSADA VASCO ANA', 'Urbanizacion compartir', '2791469', 'jennyvelasquez@gmail.com'); Query OK, 1 row affected, 2 warnings (0.002 sec) MariaDB [BDMatricula]> insert into Acudiente(codacudiente, nombre, direccion, telefono, email) values('A06','ORTIZ PUERTA INDIRA', 'Urbanizaci¢n ciudadela prado ', '5841497', 'indiraortiz@gmail.com'); Query OK, 1 row affected, 2 warnings (0.002 sec) MariaDB [BDMatricula]> insert into Acudiente(codacudiente, nombre, direccion, telefono, email) values('A07','QUINTERO MENESES ADRIANA MARIA', 'Barrio Sangabriel', '5840570', 'adrianaquintero@gmail.com'); Query OK, 1 row affected, 2 warnings (0.002 sec) MariaDB [BDMatricula]> insert into Acudiente(codacudiente, nombre, direccion, telefono, email) values('A08','MONTOYA RIVERA EDILMA', 'Barrio la pradera', '3767289', 'edilmamontoya@gmail.com'); Query OK, 1 row affected, 2 warnings (0.002 sec) MariaDB [BDMatricula]> insert into Acudiente(codacudiente, nombre, direccion, telefono, email) values('A09','LOPERA MONSALVE FERNANDO ALONSO', 'Barrio el limonar 1', '5709957', 'fernandolopera@gmail.com'); Query OK, 1 row affected, 2 warnings (0.003 sec) MariaDB [BDMatricula]> insert into Acudiente(codacudiente, nombre, direccion, telefono, email) values('A10','HENAO RIOS DORA EMILSE', 'Barrio el limonar 2', '2866222', 'dorahenao@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> select * from acudiente; +--------------+---------------------------------+-----------------+----------+----------------------+ | codacudiente | nombre | direccion | telefono | email | +--------------+---------------------------------+-----------------+----------+----------------------+ | A01 | ACEVEDO CARDONA ESTEBAN | Barrio la prade | 5846069 | estebacardona@gmail. | | A02 | AGUDELO MANCO DIANA PATRICIA | Barrio rosaleda | 5882104 | dianapatricia@gmail. | | A03 | ZPATA VALENCIA JORGE | Barrio Aragon | 5841998 | jorgezapata@gmail.co | | A04 | VELASQUEZ CANO JENNY ASTRID | Barrio la prade | 2791469 | jennyvelasquez@gmail | | A05 | POSADA VASCO ANA | Urbanizacion co | 2791469 | jennyvelasquez@gmail | | A06 | ORTIZ PUERTA INDIRA | Urbanizaci¢n ci | 5841497 | indiraortiz@gmail.co | | A07 | QUINTERO MENESES ADRIANA MARIA | Barrio Sangabri | 5840570 | adrianaquintero@gmai | | A08 | MONTOYA RIVERA EDILMA | Barrio la prade | 3767289 | edilmamontoya@gmail. | | A09 | LOPERA MONSALVE FERNANDO ALONSO | Barrio el limon | 5709957 | fernandolopera@gmail | | A10 | HENAO RIOS DORA EMILSE | Barrio el limon | 2866222 | dorahenao@gmail.com | +--------------+---------------------------------+-----------------+----------+----------------------+ 10 rows in set (0.001 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E01','ACEVEDO BURITICA JUAN ESTEBAN', 'Barrio la pradera', '5846069', 'juanestebacardona@gmail.com'); Query OK, 1 row affected, 2 warnings (0.002 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E02','ALVAREZ AGUDELO ESTEBAN', 'Barrio rosaleda', '5882104', 'estebanlavarez@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E03','ZAPATA CAMPI„O ISABEL', 'Barrio Aragon', '5841998', 'zapataisabel@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E04','VALLE VELASQUEZ SOFIA', 'Barrio la pradera', '2791469', 'sofiavelasquez@gmail.com'); Query OK, 1 row affected, 2 warnings (0.002 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E05','MORENO POSADA DIEGO ALEJANDRO', 'Urbanizacion compartir', '2868617', 'diegomoreno@gmail.com'); Query OK, 1 row affected, 2 warnings (0.002 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E06','LZATE ORTIZ JORGE MARIO', 'Urbanizaci¢n ciudadela prado', '5841497', 'marioalzae@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E07','ZAPATA QUINTERO JOSE MARIA', 'Barrio Sangabriel', '5840570', 'josezapata@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E08','MNTOYA MONTOYA AEJANDRO', 'Barrio la pradera', '3767289', 'alejandromontoya@gmail.com'); Query OK, 1 row affected, 2 warnings (0.002 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E09','LOPERA CARTAGENA LUISA FENANADA', 'Barrio el limonar 1', '5709957', 'luisalopera@gmail.com'); Query OK, 1 row affected, 2 warnings (0.003 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E10','JARAMILLO HENAO JOSE LUIS', 'Barrio el limonar 2', '2866222', 'josearamillo@gmail.com'); Query OK, 1 row affected, 2 warnings (0.003 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E11','ALVAREZ AGUDELO LUNA', 'Barrio rosaleda', '5882104', 'lunaalvarez@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> insert into Estudiante(codestudiante, nombre, direccion, telefono, email) values('E12','ALVAREZ AGUDELO XAVIER', 'Barrio rosaleda', '5882104', 'xavieralvarez@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> select * from estudiante; +---------------+---------------------------------+-----------------+----------+----------------------+ | codestudiante | nombre | direccion | telefono | email | +---------------+---------------------------------+-----------------+----------+----------------------+ | E01 | ACEVEDO BURITICA JUAN ESTEBAN | Barrio la prade | 5846069 | juanestebacardona@gm | | E02 | ALVAREZ AGUDELO ESTEBAN | Barrio rosaleda | 5882104 | estebanlavarez@gmail | | E03 | ZAPATA CAMPI„O ISABEL | Barrio Aragon | 5841998 | zapataisabel@gmail.c | | E04 | VALLE VELASQUEZ SOFIA | Barrio la prade | 2791469 | sofiavelasquez@gmail | | E05 | MORENO POSADA DIEGO ALEJANDRO | Urbanizacion co | 2868617 | diegomoreno@gmail.co | | E06 | LZATE ORTIZ JORGE MARIO | Urbanizaci¢n ci | 5841497 | marioalzae@gmail.com | | E07 | ZAPATA QUINTERO JOSE MARIA | Barrio Sangabri | 5840570 | josezapata@gmail.com | | E08 | MNTOYA MONTOYA AEJANDRO | Barrio la prade | 3767289 | alejandromontoya@gma | | E09 | LOPERA CARTAGENA LUISA FENANADA | Barrio el limon | 5709957 | luisalopera@gmail.co | | E10 | JARAMILLO HENAO JOSE LUIS | Barrio el limon | 2866222 | josearamillo@gmail.c | | E11 | ALVAREZ AGUDELO LUNA | Barrio rosaleda | 5882104 | lunaalvarez@gmail.co | | E12 | ALVAREZ AGUDELO XAVIER | Barrio rosaleda | 5882104 | xavieralvarez@gmail. | +---------------+---------------------------------+-----------------+----------+----------------------+ 12 rows in set (0.001 sec) MariaDB [BDMatricula]> insert into Docente(coddocente, nombre, email) values('D01','CIFUENTES MESA MYEIDY MARIA', 'myleidym.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [BDMatricula]> insert into Docente(coddocente, nombre, email) values('D02','CUADRADO PEREZ ADRID JOSE', 'adrid.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> insert into Docente(coddocente, nombre, email) values('D03','DUQUE RESTREPO ESTER LUCIA', 'esterl.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.003 sec) MariaDB [BDMatricula]> insert into Docente(coddocente, nombre, email) values('D04','GUIRALES MAURICIO', 'mauriciog.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> insert into Docente(coddocente, nombre, email) values('D05','VERA DAZA MARIA ELENA', 'mariae.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.001 sec) MariaDB [BDMatricula]> insert into Docente(coddocente, nombre, email) values('D06','PALACIO TOMAS FELIPE', 'tomasf.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> insert into Docente(coddocente, nombre, email) values('D07','MOSUERA OSORIO MARYETH', 'maryeth.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.001 sec) MariaDB [BDMatricula]> insert into Docente(coddocente, nombre, email) values('D08','ARBOLEDA VARGAS MARIA OFELIA', 'ofeliaa.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.001 sec) MariaDB [BDMatricula]> insert into Docente(coddocente, nombre, email) values('D09','MOSCOTE MARULANDA YANET MARIA', 'yanetm.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.001 sec) MariaDB [BDMatricula]> insert into Docente(coddocente, nombre, email) values('D10','MACIAS EDGAR ALBERTO', 'edgarm.iearm@gmail.com'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> select * from docente; +------------+-------------------------------+-----------+----------+----------------------+ | coddocente | nombre | direccion | telefono | email | +------------+-------------------------------+-----------+----------+----------------------+ | D01 | CIFUENTES MESA MYEIDY MARIA | NULL | NULL | myleidym.iearm@gmail | | D02 | CUADRADO PEREZ ADRID JOSE | NULL | NULL | adrid.iearm@gmail.co | | D03 | DUQUE RESTREPO ESTER LUCIA | NULL | NULL | esterl.iearm@gmail.c | | D04 | GUIRALES MAURICIO | NULL | NULL | mauriciog.iearm@gmai | | D05 | VERA DAZA MARIA ELENA | NULL | NULL | mariae.iearm@gmail.c | | D06 | PALACIO TOMAS FELIPE | NULL | NULL | tomasf.iearm@gmail.c | | D07 | MOSUERA OSORIO MARYETH | NULL | NULL | maryeth.iearm@gmail. | | D08 | ARBOLEDA VARGAS MARIA OFELIA | NULL | NULL | ofeliaa.iearm@gmail. | | D09 | MOSCOTE MARULANDA YANET MARIA | NULL | NULL | yanetm.iearm@gmail.c | | D10 | MACIAS EDGAR ALBERTO | NULL | NULL | edgarm.iearm@gmail.c | +------------+-------------------------------+-----------+----------+----------------------+ 10 rows in set (0.000 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M01','ESPA„OL'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M02','LECTOESCRITURA'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M03','CIENCIAS NATURALES'); Query OK, 1 row affected, 1 warning (0.002 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M04','MATEMATICAS'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M05','INVESTIGACION'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M06','FISICA'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M07','FILOSOFIA'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M08','EDUCACION FISICA'); Query OK, 1 row affected, 1 warning (0.001 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M09','ETICA'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M10','ARTISTICA'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M11','TECNOLOGIA'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M12','INFORMATICA'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M13','RELIGION'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M14','SOCIALES'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Materia(codmateria, nombre) values('M15','INGLES'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> SELECT * from materia; +------------+-----------------+ | codmateria | nombre | +------------+-----------------+ | M01 | ESPA„OL | | M02 | LECTOESCRITURA | | M03 | CIENCIAS NATURA | | M04 | MATEMATICAS | | M05 | INVESTIGACION | | M06 | FISICA | | M07 | FILOSOFIA | | M08 | EDUCACION FISIC | | M09 | ETICA | | M10 | ARTISTICA | | M11 | TECNOLOGIA | | M12 | INFORMATICA | | M13 | RELIGION | | M14 | SOCIALES | | M15 | INGLES | +------------+-----------------+ 15 rows in set (0.001 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E01','A01'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E02','A02'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E03','A03'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E04','A04'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E05','A05'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E06','A06'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E07','A07'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E08','A08'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E09','A09'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E10','A10'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E11','A01'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estuacu(codestudiante, codacudiente) values('E12','A01'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> SELECT * FROM ESTUACU; +---------------+--------------+ | codestudiante | codacudiente | +---------------+--------------+ | E01 | A01 | | E02 | A02 | | E03 | A03 | | E04 | A04 | | E05 | A05 | | E06 | A06 | | E07 | A07 | | E08 | A08 | | E09 | A09 | | E10 | A10 | | E11 | A01 | | E12 | A01 | +---------------+--------------+ 12 rows in set (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D05','M01'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D07','M02'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D09','M02'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D03','M04'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D03','M05'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D03','M06'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D01','M07'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D10','M08'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D06','M09'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D04','M10'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D02','M11'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D02','M12'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D06','M13'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D07','M14'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E01','D08','M15'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D05','M01'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D07','M02'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D09','M03'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D03','M04'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D03','M05'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D03','M06'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D01','M07'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D10','M08'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D06','M09'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D04','M10'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D02','M11'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D02','M12'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D06','M13'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D07','M14'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E02','D08','M15'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D05','M01'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D07','M02'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D09','M03'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D03','M04'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D03','M05'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D03','M06'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D01','M07'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D10','M08'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D06','M09'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D04','M10'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D02','M11'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D02','M12'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D06','M13'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D07','M14'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E03','D08','M15'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D05','M01'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D07','M02'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D09','M03'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D03','M04'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D03','M05'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D03','M06'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D01','M07'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D10','M08'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D06','M09'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D04','M10'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D02','M11'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D02','M12'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D06','M13'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D07','M14'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D08','M15'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D05','M01'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D07','M02'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D09','M03'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D03','M04'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D03','M05'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D03','M06'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D01','M07'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D10','M08'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D06','M09'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D04','M10'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D02','M11'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D02','M12'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D06','M13'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E04','D07','M14'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E05','D08','M15'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D05','M01'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D07','M02'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D09','M03'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D03','M04'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D03','M05'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D03','M06'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D01','M07'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D10','M08'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D06','M09'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D04','M10'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D02','M11'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D02','M12'); Query OK, 1 row affected (0.001 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D06','M13'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D07','M14'); Query OK, 1 row affected (0.002 sec) MariaDB [BDMatricula]> insert into Estudocemate(codestudiante, coddocente, codmateria) values('E06','D08','M15'); Query OK, 1 row affected (0.003 sec) MariaDB [BDMatricula]> select * from estudocemate; +---------------+------------+------------+ | codestudiante | coddocente | codmateria | +---------------+------------+------------+ | E01 | D05 | M01 | | E01 | D07 | M02 | | E01 | D09 | M02 | | E01 | D03 | M04 | | E01 | D03 | M05 | | E01 | D03 | M06 | | E01 | D01 | M07 | | E01 | D10 | M08 | | E01 | D06 | M09 | | E01 | D04 | M10 | | E01 | D02 | M11 | | E01 | D02 | M12 | | E01 | D06 | M13 | | E01 | D07 | M14 | | E01 | D08 | M15 | | E02 | D05 | M01 | | E02 | D07 | M02 | | E02 | D09 | M03 | | E02 | D03 | M04 | | E02 | D03 | M05 | | E02 | D03 | M06 | | E02 | D01 | M07 | | E02 | D10 | M08 | | E02 | D06 | M09 | | E02 | D04 | M10 | | E02 | D02 | M11 | | E02 | D02 | M12 | | E02 | D06 | M13 | | E02 | D07 | M14 | | E02 | D08 | M15 | | E03 | D05 | M01 | | E03 | D07 | M02 | | E03 | D09 | M03 | | E03 | D03 | M04 | | E03 | D03 | M05 | | E03 | D03 | M06 | | E03 | D01 | M07 | | E03 | D10 | M08 | | E03 | D06 | M09 | | E03 | D04 | M10 | | E03 | D02 | M11 | | E03 | D02 | M12 | | E03 | D06 | M13 | | E03 | D07 | M14 | | E03 | D08 | M15 | | E04 | D05 | M01 | | E04 | D07 | M02 | | E04 | D09 | M03 | | E04 | D03 | M04 | | E04 | D03 | M05 | | E04 | D03 | M06 | | E04 | D01 | M07 | | E04 | D10 | M08 | | E04 | D06 | M09 | | E04 | D04 | M10 | | E04 | D02 | M11 | | E04 | D02 | M12 | | E04 | D06 | M13 | | E04 | D07 | M14 | | E04 | D08 | M15 | | E05 | D05 | M01 | | E05 | D07 | M02 | | E05 | D09 | M03 | | E05 | D03 | M04 | | E05 | D03 | M05 | | E05 | D03 | M06 | | E05 | D01 | M07 | | E05 | D10 | M08 | | E05 | D06 | M09 | | E05 | D04 | M10 | | E05 | D02 | M11 | | E05 | D02 | M12 | | E05 | D06 | M13 | | E04 | D07 | M14 | | E05 | D08 | M15 | | E06 | D05 | M01 | | E06 | D07 | M02 | | E06 | D09 | M03 | | E06 | D03 | M04 | | E06 | D03 | M05 | | E06 | D03 | M06 | | E06 | D01 | M07 | | E06 | D10 | M08 | | E06 | D06 | M09 | | E06 | D04 | M10 | | E06 | D02 | M11 | | E06 | D02 | M12 | | E06 | D06 | M13 | | E06 | D07 | M14 | | E06 | D08 | M15 | +---------------+------------+------------+ 90 rows in set (0.000 sec) MariaDB [BDMatricula]> exit