Creacion Base datos por CMD

create database cine;

use cine;

create table peliculas(

-> id_pelicula int primary key not null,

-> titulo varchar (80) not null,

-> genero varchar (80) not null,

-> idioma varchar (80) not null,

-> subtitulo varchar (80) not null,

-> url varchar (80) not null,

-> duracion varchar (80) not null,

-> calificacion varchar (80) not null,

-> estreno date not null,

-> resumen varchar (80) not null,

-> director varchar (80) not null,

-> protagonistas varchar (80) not null);

____________________________________________________________

create table director(

-> id_director int primary key not null,

-> nombre varchar (80) not null,

-> nacionalidad varchar (80) not null);

_____________________________________________________________

create table actores(

-> id_actor int primary key not null,

-> nombre varchar (80) not null,

-> nacionalidad varchar (80) not null);

_____________________________________________________________

create table cines(

-> id_cine int primary key not null,

-> nombre varchar (80) not null,

-> direccion varchar (80) not null,

-> telefono varchar (80) not null);

____________________________________________________________

create table opiniones (

-> id_opinion int not null primary key,

-> nombre varchar (80),

-> fecha date not null,

-> calificaciones varchar (80) not null);

____________________________________________________________

create table funciones(

-> id int not null primary key,

-> dia date not null,

-> hora varchar(80) not null);

____________________________________________________________

agregar campos y llaves foraneas.

___________________________________________________________

mysql> alter table opiniones add peli_id int not null;

mysql> alter table opiniones add constraint fk_peli_opiniones foreign key (peli_id) references peliculas (id_pelicula);

mysql> alter table funciones add sala_id int not null;

mysql> alter table funciones add constraint fk_peli_funci foreign key (peli_id) references peliculas (id_pelicula);

mysql> alter table funciones add constraint fk_salas_funci foreign key (sala_id) references salas (id_sala);

...