Trabajo final

 CREATE TABLE Carrera(

clave_c int,

num_c varchar (50),

durac_c float,

primary key (clave_c)

)

insert into Carrera values (1,'Informatica',5)

insert into Carrera values (2,'Administracion',4)

create table Alumno(

clave_alu int,

mat_alu varchar (50),

nom_alu varchar (50),

edad_alu int,

sem_alu int,

gen_alu int,

primary key (clave_alu),

foreign key (clave_c1)REFERENCES Carrera (clave_c)

)

Insert into Alumno values (50, 'Lupita Solis', 16,2,2017,1)

Insert into Alumno values (51, 'Alberto Lopez',15,2,2017,1)

Insert into Alumno values (52,'Denise Sosa',17,3,2016,1)

Insert into Alumno values (53,'Hilda Lira',15,2,2017,1)

Insert into Alumno values (54,'Carlos Mendez',16,2,2017,2)

Insert into Alumno values (55,'Sofia Hernandez',16,2,2017,1)

Insert into Alumno values (56,'Monica Cerda',16,2,2017,2)

Insert into Alumno values (57,'Daniel Tobias',15,2,2017,2)

Insert into Alumno values (58,'Elda Lopez', 17,3,2017,2)

Insert into Alumno values (59,'Ruben Limon',18,5,2015,1)

ALTER TABLE 'Alumno' ADD 'C_ele' datatype;

UPDATE Alumno SET C_ele= 'lupitasolis@gmail.com' WHERE mat_alu=50

UPDATE Alumno SET C_ele= 'albertolopez@gmail.com' WHERE mat_alu=51

UPDATE Alumno SET C_ele= 'denisesosa@gmail.com' WHERE mat_alu=52

UPDATE Alumno SET C_ele= 'hildalira@gmail.com' WHERE mat_alu=53

UPDATE Alumno SET C_ele= 'carlosmendez@gmail.com' WHERE mat_alu=54

UPDATE Alumno SET C_ele= 'sofiahernandez@gmail.com' WHERE mat_alu=55

UPDATE Alumno SET C_ele= 'monicacerda@gmail.com' WHERE mat_alu=56

UPDATE Alumno SET C_ele= 'danieltobias@gmail.com' WHERE mat_alu=57

UPDATE Alumno SET C_ele= 'eldalopez@gmail.com' WHERE mat_alu=58

UPDATE Alumno SET C_ele= 'rubenlimon@gmail.com' WHERE mat_alu=59