ESCUELA mysql

BASE DE DATOS ESCUELA
HECHO POR LA ALUMNA GUADALUPE ISABEL CUÉLLAR PINEDA.
ESPECIALIDAD PROGRAMACION.
PROFESOR: JOSE LUIS PERALTA.





create database escuela;
use escuela;
create table datos_p(
N_control int,
nombre char (30),
direccion char (30),
telefono int,
primary key (N_control));

create table grupos(
N_grupo int,
grado int,
grupo char (20),
especialidad char (30),
turno char (20),n_alumnos int,
promedio double,
aula char (25),
primary key(N_grupo));

create table calificaciones(
N_ctrl int,
m1p1s1 float,
m1p2s1 float,
m1p3s1 float,
promp1 float,
promp2 float,
promp3 float,
promg float,
primary key(N_ctrl));

create table ser_social_pract(
N_ctrl int,
periodo_ser char (30),
lugar_ser char (30),
periodo_prac char (30),
lugar_prac char (30),
primary key(N_ctrl));

create tablelaboratorio(
fecha char (30),
hora char (30),
comp1 int,
comp10 int,
comp40 int,
observ4 char (30),
primary key (fecha));

create table computadoras(
N_comp int,
marca char (30),
procesador char (30),
memoria int,
disco_duro int,
estado char (20),
ubicacion char (20),
primary key(N_comp));

create table ser_medico(
N_ctrl int,
tipo_s char (20),
sobrepeso char (20),
asistencias int,
primary key(N_ctrl));

create table consultas(
N_cnslt int,
fecha char (30),
N_ctrl int,
descripcion char (30),
primary key(N_cnslt));

create table becas(
N_control int,
tipo_beca char (30),
ingres_mem int,
primary key(N_control));

create table biblioteca(
N_libro int,
titulo_libro char (30),
autor char (30),
editorial char (25),
asignatura char(25),
edicion int,
paginas int,
primary key(N_libro));

createtable prestamos(
N_prestamos int,
N_libro int,
N_control int,
fecha_sal char(30),
fecha_ent char(30),
primary key(N_prestamos));

insert into datos_p values(100, "Mauricio Carriles", "Puente", 3425628);
insert into datos_p values(250, "Isamar Balanzar", "Unidad", 3425689);
insert into datos_p values(809, "Isabel Cuéllar", "Tlaquitenango", 3426189);
insert into datos_p values(450, "Adriana Mondragon","Tlatizapan", 3425000);
insert into datos_p values(400, "Alan Gil", "Teques", 3425703);
insert into datos_p values(310, "Arturo Peña", "Higueron", 3426719);
insert into datos_p values(670, "Carlos Bravo", "Galeana", 3426970);
insert into datos_p values(985, "Adelina Vargas", "Jojutla", 3423459);
insert into datos_p values(350, "Esther Landa", "Zacatepec", 3431900);
insert into datos_p values(205,"Jesimiel Guzmán", "Jojutla", 3429820);

insert into grupos values(1, 2, "A", "programacion", "t", 3, 9, "a1");
insert into grupos values(2, 2, "B", "ofimatica", "m", 3, 9, "b1");
insert into grupos values(3, 2, "C", "electronica", "m", 2, 9, "c1");
insert into grupos values(4, 2, "D", "contabilidad", "m", 2, 8, "d1");
insert into grupos values(5, 2, "E", "mantenimiento", "t", 4, 7, "e1");
insertinto grupos values(6, 2, "F", "electronica", "t", 4, 8, "f1");
insert into grupos values(7, 2, "G", "programacion", "t", 3, 10, "g1");
insert into grupos values(8, 2, "H", "programacion", "m", 3, 10, "h1");
insert into grupos values(9, 2, "I", "ofimatica", "m", 2, 9, "i1");
insert into grupos values(10, 2, "J", "ofimatica", "m", 2, 10, "j1");

insert into calificaciones values(1, 10, 8, 9.5, 9,8, 7, 6.6);
insert into calificaciones values(2, 9, 8, 10, 9, 6, 6, 9.6);
insert into calificaciones values(3, 9, 7, 6.6, 7.5, 9, 8, 8.9);
insert into calificaciones values(4, 9, 6, 9, 8, 9, 9, 7.9);
insert into calificaciones values(5, 8, 9.5, 10, 9, 9, 10, 8.9);
insert into calificaciones values(6, 8, 9, 10, 9, 10, 9, 9.9);
insert into calificaciones values(7, 10, 9, 9, 9.3, 6, 9.9, 8);
insertinto calificaciones values(8, 10, 10, 8.8, 9.6, 9, 8.8, 7);
insert into calificaciones values(9, 9, 10, 8, 9, 10, 8.5, 9);
insert into calificaciones values(10, 9, 10, 8, 9, 10, 10, 10);

insert into ser_social_pract values(1, "12/09/2013", "Ing. Emiliano Zapata", "05-05-2013 a 05-05-2014", "DIF");
insert into ser_social_pract values(2, "30/05/2014", "Esc. Prim. Ramon beteta", "20-05-2012 a...