BD Escuela (Consola de MySQL)

create database cetis_50;

use cetis_50;

create table materias(                                                                                                                                            nombre varchar (30),                                                                                                                                       profesor varchar (30),                                                                                                                                     especialidad varchar (10)                                                                                                                                      );

create table alumnos(                                                                                                                                          nombre varchar (30),                                                                                                                                            apellidos varchar (30),                                                                                                                              num_control int (15),                                                                                                                                              grado int (1),                                                                                                                                                          grupo varchar (1),                                                                                                                                            especialidad varchar (20),                                                                                                                                     direccion varchar (60)                                                                                                                                             );

create table turnos(                                                                                                                                             idturno int (1),                                                                                                                                                     turno varchar (10)                                                                                                                                                  );

create table grupos(                                                                                                                                              idgrupo int (2),                                                                                                                                                 grupo varchar (1),                                                                                                                                           grado int (1),                                                                                                                                        especialidad varchar (30),                                                                                                                             idturno int (1)                                                                                                                                                         );