Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO alumno (idAlumno, nombre_alumno, dni_alumno) VALUES
- (1, "Juan Pepe", "12345678"),
- (2, "Luis Sanchez", "12332678"),
- (3, "Nacho Verdon", "12341678"),
- (4, "Ulises Gonzalez", "12345378");
- INSERT INTO profesor (idprofesor, nombre_profesor, dni_profesor) VALUES
- (1, "Joselito", "12545678"),
- (2, "Armando", "12355678"),
- (3, "Mango", "12345178"),
- (4, "Juan", "12245678");
- INSERT INTO curso (idcurso, nombre_curso, horas_curso, idprofesor) VALUES
- (1, "Acceso a datos", "6", 2),
- (2, "Ingles", "3", 3),
- (3, "Programacion de servicios y procesos", "4", 1),
- (4, "Desarrollo de interfaces", "5", 4);
- INSERT INTO curso_has_alumno (id_codigo, idcurso, idalumno, nota) VALUES
- (1, 3, 1, "14"),
- (2, 1, 1, "18"),
- (3, 2, 4, "15"),
- (4, 4, 3, "16"),
- (5, 3, 2, "14"),
- (6, 1, 2, "18"),
- (7, 2, 3, "15"),
- (8, 4, 4, "16");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement