Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE colegio;
- USE colegio;
- CREATE TABLE estudiante
- (
- idEstudiante INT NOT NULL,
- nombre VARCHAR (70) NOT NULL,
- apellidos VARCHAR (85) NOT NULL,
- sexo VARCHAR (1) NOT NULL,
- PRIMARY KEY (idEstudiante)
- );
- CREATE TABLE curso
- (
- idCurso INT NOT NULL,
- idEstudiante INT NOT NULL,
- nombre VARCHAR (70) NOT NULL,
- fechaInicio DATE NOT NULL,
- fechaFin DATE NOT NULL,
- PRIMARY KEY (idCurso),
- CONSTRAINT FKEY_CURSO_ESTUDIANTE FOREIGN KEY (idEstudiante) REFERENCES estudiante (idEstudiante)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement