Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Estudiante(
- cod_est varchar (11) primary key,
- nom_est varchar(35),
- apell_est varchar(35),
- edad smallint,
- estrato smallint,
- genero char(1),
- fecha_nac date
- );
- create table matricula(
- cod_est varchar(11),
- cod_asig varchar(4),
- fechainc date default '1-08-2018',
- fechafin date default '30-11-2018',
- nota real check(nota>=10 and nota<=50),
- primary key (cod_est, cod_asig),
- Foreign key (cod_est) REFERENCES Estudiante(cod_est)on delete no action,
- foreign key (cod_asig)REFERENCES asignatura(cod_asig)on delete no action
- );
- create table asignatura(
- cod_asig varchar(4) primary key not null,
- nom_asig varchar(35),
- nrocred smallint
- );
- insert into matricula (cod_est,cod_asig,fechainc,fechafin,nota)
- values
- ('1085','2030',default,default,10),
- ('1453','1011',default,default,18);
Add Comment
Please, Sign In to add comment