· 9 years ago · Dec 14, 2016, 07:16 AM
1DROP TABLE IF EXISTS movies;
2DROP TABLE IF EXISTS boxoffice;
3DROP TABLE IF EXISTS Language;
4DROP TABLE IF EXISTS directors;
5DROP TABLE IF EXISTS MoviesDirectedBy;
6
7CREATE TABLE movies
8(
9 Id INT PRIMARY KEY NOT NULL AUTO_INCREMENT,
10 Title VARCHAR(255),
11 Director VARCHAR(255),
12 Year INT,
13 Length_min INT
14);
15
16CREATE TABLE boxoffice
17(
18 Rating DOUBLE,
19 Domestic_sales BIGINT,
20 International_sales BIGINT,
21 Aspect_ratio DOUBLE,
22 Language VARCHAR(50),
23 Movie_id INT NOT NULL,
24 Id INT PRIMARY KEY NOT NULL AUTO_INCREMENT
25);
26
27CREATE TABLE language
28(
29 Movie_id INT NOT NULL,
30 Lang_name VARCHAR(50),
31 IsSubtitles BOOL
32);
33
34INSERT INTO movies
35 (Id, Title, Director, Year, Length_min)
36VALUES
37 (3, 'Toy Story 2', 'John Lasseter', 1999, 93),
38 (6, 'The Incredibles', 'Brad Bird', 2004, 116),
39 (11,'Toy Story 3', 'Lee Unkrich', 2010, 103),
40 (4, 'Monsters, Inc.', 'Pete Docter', 2001, 92),
41 (5, 'Finding Nemo', 'Andrew Stanton', 2003, 107),
42 (7, 'Cars', 'John Lasseter', 2006, 117),
43 (8, 'Ratatouille', 'Brad Bird', 2007, 115),
44 (9, 'WALL-E', 'Andrew Stanton', 2008, 104),
45 (10,'Up', 'Pete Docter', 2009, 101),
46 (12,'Cars 2', 'John Lasseter', 2011, 120),
47 (13,'Brave', 'Brenda Chapman', 2012, 102),
48 (14,'Monsters University', 'Dan Scanlon', 2013, 110);
49
50INSERT INTO movies
51 (Title, Director, Year, Length_min)
52VALUES
53 ('The Incredibles 2', 'Brad Bird', 2018, NULL),
54 ('Toy Story 4', NULL, 2019, NULL),
55 ('Cars 3', 'Brian Fee', 2017, 91),
56 ('Coco', 'Lee Unkrich', 2017, 90),
57 ('Finding Dory', 'Andrew Stanton', 2016, 97);
58
59
60INSERT INTO boxoffice
61 (Rating, Domestic_sales, International_sales, Aspect_ratio, Language, Movie_id)
62VALUES
63 (8.2, 380843261, 555900000, 1.85, 'English', 5),
64 (7.4, 268492764, 475066843, 1.85, 'English', 14),
65 (8, 206445654, 417277164, 1.85, 'English', 8),
66 (6.4, 191452396, 368400000, 1.78, 'English', 12),
67 (7.9, 245852179, 239163000, 1.85, 'English', 3),
68 (8, 261441092, 370001000, 2.4, 'French', 6),
69 (8.5, 223808164, 297503696, 1.78, 'English', 9),
70 (8.4, 415004880, 648167031, 1.85, 'English', 11),
71 (7.2, 244082982, 217900167, 1.78, 'English', 7),
72 (8.3, 293004164, 438338580, 1.85, 'English', 10),
73 (8.1, 289916256, 272900000, 1.85, 'English', 4),
74 (7.2, 237283207, 301700000, 1.85, 'English', 13);
75
76INSERT INTO language
77 (Lang_name, movie_id, IsSubtitles)
78VALUES
79 ('English', 5, false),
80 ('English', 14, false),
81 ('English', 8, false),
82 ('English', 12, false),
83 ('English', 3, false),
84 ('French', 6, true),
85 ('English', 9, false),
86 ('English', 11, false),
87 ('English', 7, false),
88 ('English', 10, false),
89 ('English', 4, false),
90 ('English', 13, false),
91 ('Spanish', 3, true),
92 ('Arabic', 3, true),
93 ('English', 6, false),
94 ('Spanish', 11, true),
95 ('French', 8, false),
96 ('Italian', 7, true),
97 ('Japanese', 7, true),
98 ('Yiddish', 7, true);