Escuela
CREATE DATABASE `ESCUELA`;
CREATE TABLE `Escuela`.`Grupos` (
`Grado` INT( 1 ) NOT NULL ,
`Grupo` VARCHAR( 1 ) NOT NULL ,
`Turno` VARCHAR( 1 ) NOT NULL
) ENGINE = InnoDB;
CREATE TABLE `Escuela`.`Materias` (
`ID` INT( 4 ) NOT NULL ,
`Nombre` VARCHAR( 30 ) NOT NULL ,
PRIMARY KEY ( `ID` )
) ENGINE = InnoDB;
CREATE TABLE `escuela`.`turno` (
`ID` VARCHAR( 1 ) NOT NULL ,
`nombre` VARCHAR( 10 ) NOT NULL ,
PRIMARY KEY ( `ID` )
) ENGINE = InnoDB;
CREATE TABLE `escuela`.`alumnos` (
`Matricula` INT( 6 ) NOT NULL ,
`Nombre` VARCHAR( 50 ) NOT NULL ,
`Grado` INT( 1 ) NOT NULL ,
`Grupo` VARCHAR( 1 ) NOT NULL ,
`Turno` VARCHAR( 1 ) NOT NULL ,
`Materia` VARCHAR( 4 ) NOT NULL ,
UNIQUE (
`Matricula`
)
) ENGINE = InnoDB;
INSERT INTO `escuela`.`alumnos` (
`Matricula` ,
`Nombre` ,
`Grado` ,
`Grupo` ,
`Turno` ,
`Materia`,
)
VALUES (
'741258', 'Abraham Amador', '1', 'a', 'm', '1'
), (
'785412', 'Blanca Estela Juarez', '2', 'b', 'v', '2'
), (
'745821', 'Carlos Villagran', '3', 'c', 'm', '3'
), (
'784512', 'Daniel Alonso Vega', '4', 'd', 'm', '4'
), (
'748596', 'Esteban Cortes Nuñez', '5', 'f', 'm', '5'
);
INSERT INTO `escuela`.`grupos` (
`Grado` ,
`Grupo` ,
`Turno`
)
VALUES (
'1', 'a', 'm'
), (
'1', 'a', 'v'
), (
'2', 'b', 'm'
), (
'2', 'b', 'v'
), (
'3', 'c', 'm'
), (
'3', 'c', 'v'
), (
'4', 'd', 'm'
), (
'4', 'd', 'v'
), (
'5', 'e', 'm'
), (
'5', 'e', 'v'
);
INSERT INTO `escuela`.`materias` (
`ID` ,
`Nombre`
)
VALUES (
'1', 'Español'
), (
'2', 'Matematicas'
), (
'3', 'Fisica'
), (
'4', 'Quimica'
), (
'5', 'Tutorias'
);
INSERT INTO `escuela`.`turno` (
`ID` ,
`nombre`
)
VALUES (
'v', 'Vespertino'
), (
'm', 'Matutino'
);