POSD

--CREAR LA TABLA CARRERA.
CREATE TABLE carrera(
clave_c int,
nom_c varchar2(50),
durac_c float,
CONSTRAINT pk_cc primary key(clave_c)
);

/*Tabla Materia*/


create table materia(
clave_m int,
nom_m VARCHAR2(50),
cred_m float,
CONSTRAINT pk_cm primary key (clave_m)

);
--Tabla profesor
create table profesor(
clave_p int,
nom_p varchar2(150),
dir_p varchar2(200),
tel_p LONG,
hor_p date,
CONSTRAINT pk_cp primary key (clave_p)
);
/*
tabla alumno con una clave foranea*/
create table alumno (
mat_alu int,
nom_alu VARCHAR2(150),
edad_alu int,
sem_alu int,
gen_alu varchar2(10),
clave_c1 int,
CONSTRAINT pk_calu primary key (mat_alu),
CONSTRAINT fk_fc1 FOREIGN key (clave_c1) REFERENCES carrera(clave_c)
);

create table alu_pro(
mat_alu1 int,
clave_p1 int,
constraint fk_falu1 foreign key(mat_alu1) references alumno(mat_alu),
constraint fk_fp1 FOREIGN key(clave_p1) references profesor(clave_p)
);



create table mat_alu(
clave_m1 int,
mat_alu2 int,
CONSTRAINT fk_fm1 foreign key (clave_m1) REFERENCES materia(clave_m),
constraint fk_falu2 foreign key (mat_alu2) references alumno (mat_alu)
);

create table mat_pro(
clave_m2 int,
clave_p2 int,
constraint fk_fm2 foreign key(clave_m2) references materia (clave_m),
constraint fk_fp2 foreign key (clave_p2)  references profesor(clave_p)
);