QSV5gveV

1DROP DATABASE IF EXISTS movie;
2CREATE DATABASE movie;
3USE movie;
4
5
6create table studio(
7id int auto_increment primary key,
8adress varchar(255) not null,
9name varchar(255) not null,
10bulstrat varchar(255) not null
11);
12
13create table procs(
14id int auto_increment primary key,
15adress varchar(255) not null,
16name varchar(255) not null,
17bulstrat varchar(255) not null
18);
19
20create table movie(
21id int auto_increment primary key,
22name varchar(255) not null,
23yearOfMovie year,
24bulstrat varchar(255) not null,
25budjet int not null,
26studio_id int not null,
27procs_id int not null,
28
29constraint foreign key(studio_id) references studio(id),
30constraint foreign key(procs_id) references procs(id)
31
32);
33
34create table actors(
35id int auto_increment primary key,
36name varchar(255) not null,
37sex enum('F','M'),
38dateOfBirht date,
39adress varchar(255) not null
40);
41
42create table movie_actor(
43movie_id int not null,
44actor_id int not null,
45
46constraint foreign key(movie_id) references movie(id),
47constraint foreign key(actor_id) references actors(id),
48primary key(movie_id,actor_id)
49);
50
51
52Insert into studio(adress,name,bulstrat)
53VALUES ('Sofia, Boris str. 56', 'Studio Diana', '1112221'),
54('London, Everest str. 355', 'Studio Express', '1457458'),
55('Berlin, Kernigan str. 455', 'Studio Europa', '1114452');
56
57
58insert into procs(adress,name,bulstrat)
59VALUES('London, Safary str. 477', '12124545', 'John Smith'),
60('Sofia, Opalchenska str. 78', '12541250','Erna & Dina EOOD'),
61('Paris, Earoh str. 626', '14514520','Exctravaganzza Trading');
62
63Insert into actors(name,adress,sex,dateOfBirht)
64VALUES('Robert de Niro', 'London, JMS str. 346', 'M','1943-08-17'),
65('Arnold Schwarzenegger', 'London, Monacco str. 47', 'M','1947-07-30'),
66('Stoyanka Mutafova', 'Sofia, Tsar Boris str. 45', 'F','1922-02-02');
67
68insert into movie(name,yearOfMovie,bulstrat,budjet,studio_id,procs_id)
69values('Kimikandja',1955,'gosho',500,1,2),
70('Daniel e gei',2018,'pesho',600,1,1),
71('Venci i kazarmata',1992,'venci',250,2,1),
72('Siso e leko sladuk',1982, 'siso',1500,3,1);
73
74
75INSERT INTO movie_actor(actor_id,movie_id)
76VALUES(1,1),
77(2,2),
78(1,2),
79(3,3);