Advertisement
Guest User

dsafds;af

a guest
Nov 22nd, 2017
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.82 KB | None | 0 0
  1. INSERT INTO alumno (idAlumno, nombre_alumno, dni_alumno) VALUES
  2. (1, "Juan Pepe", "12345678"),
  3. (2, "Luis Sanchez", "12332678"),
  4. (3, "Nacho Verdon", "12341678"),
  5. (4, "Ulises Gonzalez", "12345378");
  6.  
  7.  
  8. INSERT INTO profesor (idprofesor, nombre_profesor, dni_profesor) VALUES
  9. (1, "Joselito", "12545678"),
  10. (2, "Armando", "12355678"),
  11. (3, "Mango", "12345178"),
  12. (4, "Juan", "12245678");
  13.  
  14.  
  15. INSERT INTO curso (idcurso, nombre_curso, horas_curso, idprofesor) VALUES
  16. (1, "Acceso a datos", "6", 2),
  17. (2, "Ingles", "3", 3),
  18. (3, "Programacion de servicios y procesos", "4", 1),
  19. (4, "Desarrollo de interfaces", "5", 4);
  20.  
  21. INSERT INTO curso_has_alumno (id_codigo, idcurso, idalumno, nota) VALUES
  22. (1, 3, 1, "14"),
  23. (2, 1, 1, "18"),
  24. (3, 2, 4, "15"),
  25. (4, 4, 3, "16"),
  26. (5, 3, 2, "14"),
  27. (6, 1, 2, "18"),
  28. (7, 2, 3, "15"),
  29. (8, 4, 4, "16");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement