--creando base d datos :institutoscreate database institutouse instituto--creando tabla distritoscreate table distritos(coddis char(4),nombre varchar(30))--adicionando datos en tabla distritosinsert into distritos values('D001','Ate')insert into distritos values('D002','Miraflores')insert into distritos values('D003','Surco')insert into distritos values('D004','Callao')insert into distritos values('D005','V.E.S')select * from distritos--creando tabla alumnoscreate table alumno(cod_alu char(5),ape varchar(30),nom_alu varchar(30),direcc varchar(30),coddis char(4))--adicionando datos en tabla alumnosinsert into alumno values('Al001','Caceres','Javier','Av. las camelias 1249','D001')insert into alumno values('Al001','Caceres','Javier','Av. las camelias 1249','D001')insert into alumno values('Al001','Caceres','Javier','Av. las camelias 1249','D001')insert into alumno values('Al001','Caceres','Javier','Av. las camelias 1249','D001')insert into alumno values('Al001','Caceres','Javier','Av. las camelias 1249','D001')select * from alumno--creando tabla areascreate table area(codarea char(4),nomarea varchar(30))--adicionando datos en tabla areasinsert into area values('a001','matematicas')insert into area values('a002','progamacion')insert into area values('a003','sistemas')insert into area values('a004','contabilidad')insert into area values('a004','lenguaje')select * from area--creando tabla matriculacreate table matricula(codmat char(6),cod_alu char(5),cod_cur char(4),f_mat datetime)--adicionando datos en tabla matriculainsert into matricula values('m00001','Al001','c001','16/04/2002')insert into matricula values('m00002','Al002','c002','16/04/2002')insert into matricula values('m00003','Al003','c003','16/04/2002')insert into matricula values('m00004','Al004','c004','16/04/2002')insert into matricula values('m00005','Al005','c005','16/04/2002')select * from matricula--creando tabla cursoscreate table curso(codarea char(4),nomarea varchar(40),credito int)--adicionando datos en tabla cursosinsert into curso values('c001','Visual basic',150)insert into curso values('c002','Algoritmos',180)insert into curso values('c004','Diseo Web',200)insert into curso values('c005','Investigacion',300)insert into curso values('c003','Redes',90)select * from curso