Advertisement
Guest User

Untitled

a guest
Jul 3rd, 2015
234
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.51 KB | None | 0 0
  1. CREATE DATABASE colegio;
  2. USE colegio;
  3.  
  4. CREATE TABLE estudiante
  5. (
  6. idEstudiante INT NOT NULL,
  7. nombre VARCHAR (70) NOT NULL,
  8. apellidos VARCHAR (85) NOT NULL,
  9. sexo VARCHAR (1) NOT NULL,
  10. PRIMARY KEY (idEstudiante)
  11. );
  12.  
  13. CREATE TABLE curso
  14. (
  15. idCurso INT NOT NULL,
  16. idEstudiante INT NOT NULL,
  17. nombre VARCHAR (70) NOT NULL,
  18. fechaInicio DATE NOT NULL,
  19. fechaFin DATE NOT NULL,
  20. PRIMARY KEY (idCurso),
  21. CONSTRAINT FKEY_CURSO_ESTUDIANTE FOREIGN KEY (idEstudiante) REFERENCES estudiante (idEstudiante)
  22. );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement