Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE estudiante (
- lib_univ INT NOT NULL PRIMARY KEY,
- fecha DATE NOT NULL,
- observaciones VARCHAR(255),
- cod_postal INT NOT NULL,
- tipo CHAR(1) NOT NULL, --not null?
- nro INT NOT NULL,
- CONSTRAINT fk_persona FOREIGN KEY(tipo,nro) REFERENCES persona(tipo,numero)
- CONSTRAINT fk_localidad FOREIGN KEY(cod_postal) REFERENCES localidad(cod_postal)
- )
- CREATE TABLE profesor (
- tipo CHAR(1) NOT NULL,
- nro INT NOT NULL,
- tel CHAR(20), --nuuuuul
- email CHAR(40),
- fecha1 DATE NOT NULL,
- fecha2 DATE NOT NULL,
- fecha3 DATE,
- CONSTRAINT pk_persona PRIMARY KEY(tipo,nro),
- CONSTRAINT fk_persona FOREIGN KEY(tipo,nro) REFERENCES persona(tipo,nro)
- )
- CREATE TABLE materia (
- cod_mat INT NOT NULL,
- cod_carr INT NOT NULL,
- nombre CHAR(30) NOT NULL
- cod_depto INT NOT NULL,
- CONSTRAINT pk_materia PRIMARY KEY(cod_mat, cod_carr),
- CONSTRAINT fk_carrera FOREIGN KEY(cod_carr) REFERENCES carrera(cod_carr),
- CONSTRAINT fk_dpto FOREIGN KEY(cod_depto) REFERENCES depto(cod_depto)
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement