insertforclasswork.sql

use classork;
insert into Movie
values('01','Eyes wide shut','1999','12','English','1998-12-30','Niger');
insert into Movie
values('02','Eyes wide','1997','11','English','1997-12-02','Tanz');
insert into Movie
values('03','Enesi','1998','02','English','1998-07-02','Jamai');
insert into Movie
values('04','Dobode','1997','01','English','1997-12-02','Tanz');

insert into Actor
values('001','Koko','Lamar','F');
insert into Actor
values('002','Kaka','Lamack','M');
insert into Actor
values('003','Ibouka','Onougha','M');
insert into Actor
values('004','felicia','Lamar','F');

insert into director
values('1', 'Lala','Master');
insert into director
values('2', 'Lola','Salami');
insert into director
values('3', 'Sola','Abbey');
insert into director
values('4', 'Fola','Alabi');

insert into genres
values('01','-------' );
insert into genres
values('02','-------' );
insert into genres
values('03','-------' );
insert into genres
values('04','-------' );

insert into reviewer
values('001', 'Neni');
insert into reviewer
values('002', 'Halima');
insert into reviewer
values('003', 'Ifeoma');
insert into reviewer
values('004', 'Alicho');

insert into rating
values('01','001', null, null);
insert into rating
values('02','002', null, null);
insert into rating
values('03','003', null, null);
insert into rating
values('04','004', null, null);

insert into movie_cast
values('001','01','idk');
insert into movie_cast
values('002','02','idk');
insert into movie_cast
values('003','03','idk');
insert into movie_cast
values('004','04','idk');

insert into movie_direction
values('1', '01');
insert into movie_direction
values('2', '02');
insert into movie_direction
values('3', '03');
insert into movie_direction
values('4', '04');

insert into movie_genres
values('01','01');
insert into movie_genres
values('02','02');
insert into movie_genres
values('03','03');
insert into movie_genres
values('04','04');