Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE datosalumno(rut varchar2(5) CONSTRAINT dat_al_pk PRIMARY KEY,nombre
- varchar2(40) CONSTRAINT dat_nom_nn NOT NULL,direccion varchar2(40) CONSTRAINT
- dat_dir_nn NOT NULL,telefono varchar2(10) CONSTRAINT dat_tel_nn NOT NULL);
- DESCRIBE datosalumno;
- CREATE TABLE datosasignatura(codigoa varchar2(3) CONSTRAINT datoa_cod_pk PRIMARY KEY,
- nombre varchar2(20) CONSTRAINT datoa_nom_nn NOT NULL,jornada varchar2(15) CONSTRAINT
- datoa_jor_nn NOT NULL,creditos INT CONSTRAINT datoa_cred_nn NOT NULL);
- CREATE TABLE asignaturaalumno(rut varchar2(5),FOREIGN KEY (rut_datosalumno) REFERENCES datosalumno(rut),
- codigoa varchar2(3),FOREIGN KEY (codigoa_datosasignatura) REFERENCES datosasignatura(codigoa));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement