Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE persona (
- tipo CHAR(1) NOT NULL,
- nro_doc INT NOT NULL,
- apenom CHAR(40) NOT NULL,
- domicilio CHAR(40) NOT NULL,
- fecha DATE NOT NULL,
- cod_localidad SMALLINT NOT NULL,
- CONSTRAINT pk_persona PRIMARY KEY(tipo,nro_doc),
- CONSTRAINT fk_localidad FOREIGN KEY(cod_localidad) REFERENCES localidad(cod_localidad)
- )
- CREATE TABLE carrera (
- cod_carr INT NOT NULL PRIMARY KEY,
- nom_carr CHAR(40) NOT NULL,
- cuatrimestres INT NOT NULL,
- cod_facu INT NOT NULL,
- CONSTRAINT fk_facultad FOREIGN KEY(cod_facu) REFERENCES facultad(cod_facu)
- )
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement