vr0cuwdi

1CREATE TABLE IF NOT EXISTS Serial(
2    title TEXT NOT NULL,
3    year INTEGER NOT NULL,
4    actor TEXT NOT NULL,
5    genre TEXT NOT NULL,
6    seasons INTEGER NOT NULL,
7    number INTEGER NOT NULL,
8    PRIMARY KEY (title, year),
9    FOREIGN KEY (genre) REFERENCES ageRating(ageHuman)
10);
11
12CREATE TABLE IF NOT EXISTS ageRating (
13    ageHuman TEXT NOT NULL,
14    title TEXT NOT NULL,
15    genre TEXT NOT NULL,
16    PRIMARY KEY (ageHuman)
17);
18
19CREATE TABLE IF NOT EXISTS serialRating (
20    rating INTEGER NOT NULL,
21    title TEXT NOT NULL,
22    year INTEGER NOT NULL,
23    PRIMARY KEY (title, year),
24    FOREIGN KEY (title) REFERENCES Serial(title)
25);
26
27CREATE TABLE IF NOT EXISTS serialAwards (
28    awards INTEGER NOT NULL,
29    title  TEXT NOT NULL,
30    year   INTEGER NOT NULL,
31    PRIMARY KEY (title, year),
32    FOREIGN KEY (title, year) REFERENCES Serial (title, year)
33);
34
35
36INSERT INTO Serial (title, year, actor, genre, seasons, number)
37
38VALUES
39    ('The Witcher', '2020', 'Henry-Cavill', 'Adventure', '1', '8'),
40    ('The Walking Dead', '2013', 'Chris-Redfield', 'Horror', '8', '121'),
41    ('Game of thrones', ' 2008', 'Nikolai-Koster-Waldau', 'Fantasy', '7', '64'),
42    ('One man', '2003', 'Dmitry-Kuzmenko', 'Cartoon', '1', '4'),
43    ('Superman', '2018', 'Henry-Cavill', 'Superhero', '3', '26');
44
45INSERT INTO ageRating (ageHuman, title, genre)
46
47VALUES
48    ('16+', 'The Witcher', 'Adventure'),
49    ('18+', 'The Walking Dead', 'Horror'),
50    ('18+', 'Game of thrones', 'Fantasy'),
51    ('6+', 'One man', 'Cartoon'),
52    ('12+', 'Superman', 'Superhero');
53
54INSERT INTO serialRating (rating, title, year)
55
56VALUES
57    ('86', 'The Witcher', '2020'),
58    ('78', 'The Walking Dead', '2013'),
59    ('92', 'Game of thrones', '2008'),
60    ('85', 'One man', '2003'),
61    ('69', 'Superman', '2018');
62
63INSERT INTO serialAwards (awards, title, year)
64
65VALUES
66    ('20', 'The Witcher', '2020'),
67    ('15', 'The Walking Dead', '2013'),
68    ('50', 'Game of thrones', '2008'),
69    ('3', 'One man', '2003'),
70    ('7', 'Superman', '2018');