delete movies;
delete movie_preferences;
delete age_categories;

insert into age_categories
( id, description)
values (1,'2-6 years')
;
insert into age_categories
( id, description)
values (2,'7-12 years')
;
insert into age_categories
( id, description)
values (3,'12-15 years')
;
insert into age_categories
( id, description)
values (4,'16-21 years')
;
insert into age_categories
( id, description)
values (5,'21+ years')
;

insert into MOVIES
( "ID" , "TITLE")
values (1, 'Shrek 2')
;
insert into MOVIES
( "ID" , "TITLE")
values (2, 'Monster Inc')
;
insert into MOVIES
( "ID" , "TITLE")
values (3, 'Sharktale')
;
insert into MOVIES
( "ID" , "TITLE")
values (4, 'Bridget Jones - On the edge of reason')
;
insert into MOVIES
( "ID" , "TITLE")
values (5, 'Love Actually')
;
insert into MOVIES
( "ID" , "TITLE")
values (6, 'Dodgeball')
;
insert into MOVIES
( "ID" , "TITLE")
values (7, 'The Matrix Reloaded')
;
insert into MOVIES
( "ID" , "TITLE")
values (8, 'K3 en het betoverde medaillon')
;
insert into MOVIES
( "ID" , "TITLE")
values (9, 'Lord of The Rings')
;
insert into MOVIES
( "ID" , "TITLE")
values (10, 'Finding Nemo')
;

insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 1, 5 ,'M', 9, 7, 5  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 2, 5 ,'M', 9, 10, 2  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 3, 5 ,'M', 10, 7, 9  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 4, 4 ,'M', 6, 7, 9  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 5, 4 ,'M', 6, 7, 9  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 6, 4 ,'F', 4, 7, 9  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 7, 4 ,'F', 4, 3, 9  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 8, 4 ,'F', 4, 5, 6  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 9, 5 ,'F', 4, 5, 3  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 10, 5 ,'F', 4, 5, 3  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 11, 5 ,'F', 2, 5, 3  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 12, 5 ,'F', 10, 2, 3  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 13, 5 ,'F', 4, 5, 7  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 14, 1 ,'F', 8, 10, 2  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 15, 1 ,'F', 8, 10, 2  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 16, 1 ,'M', 3, 10, 2  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 17, 1 ,'M', 3, 10, 2  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 18, 1 ,'M', 3, 1, 2  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 19, 2 ,'M', 3, 1, 2  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 20, 2 ,'F', 3, 8, 1  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 21, 2 ,'F', 3, 8, 1  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 22, 3 ,'F', 10, 3, 1  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 23, 3 ,'F', 10, 3, 2  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 24, 3 ,'F', 10, 3, 1  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 25, 3 ,'M', 10, 3, 1  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 26, 3 ,'M', 10, 3, 6  )
;
insert into "MOVIE_PREFERENCES"
( "ID", "AGE_CATEGORY", "GENDER" , "MVE_ID_1"  , "MVE_ID_2"  , "MVE_ID_3" )
values 
( 27, 3 ,'M', 2, 3, 6  )
;