create table film

FilmDatabase SQL Örnek create database FilmDatabase; oadi varchar(20), osoyadi varchar(20), use FilmDatabase; dob year ); create table film ( select * from oyuncu; fno int primary key, fadi varchar(40), create table yapimci yili int, ( butcesi double, yapno int primary key, puani float, yadi varchar(50), yno int, yadres varchar(50) yapno int ); ); select * from yapimci; select * from film; create table filo create table yonetmen ( ( oscar varchar(10) yno int primary key, ); yadi varchar(20), ysoyadi varchar(20), select * from filo; dob year ); insert into film(fno,fadi,yili,butcesi,puani,yno,yapno) select * from yonetmen; create table oyuncu ( ono int primary key, values (1,'The Dark Knight',2008,185000000,9,1,1), (2,'Pulp Fiction',1994,8000000,8.9,2,2), (3,'Fight Club',1999,63000000,8.9,3,3), (4,'The Lord of the Rings‐Two Towers',2002,94000000,8.7,4,4), 1 FilmDatabase SQL Örnek (5,'Inception',2010,160000000,8.8,1,5), select fadi,yadi (6,'Seven',1995,33000000,8.7,3,6), from film (7,'The Usual Suspects',1995,6000000,8.7,5,7), join yonetmen (8,'Leon',1996,115000000,8.6,6,8), (9,'Back to the Future',1985,19000000,8.5,7,9), (10,'Django Unchained',2012,100000000,8.5,2,10); select * from film; insert into yonetmen(yno,yadi,ysoyadi,dob) values (1,'Christopher','Nolan',1970); insert into yonetmen(yno,yadi,ysoyadi,dob) values (2,'Quentin', 'Tarantino',1963), (3,'David', 'Fincher',1962), (4,'Peter', 'Jackson',1961), (5,'Bryan', 'Singer',1965), (6,'Luc','Besson',1959), (7,'Robert','Zemeckis',1951); select * from yonetmen; alter table film add foreign key (yno) references yonetmen(yno); on film.yno=yonetmen.yno; select fadi,yadi,ysoyadi from film left join yonetmen on film.yno=yonetmen.yno; select fadi,yadi from film right join yonetmen on film.yno=yonetmen.yno; alter table filo add (fno int, ono int); select * from filo; alter table filo add foreign key(fno) references film(fno); alter table filo add foreign key(ono) references oyuncu(ono); 2 FilmDatabase SQL Örnek insert into oyuncu(ono,oadi,osoyadi,dob) values (1, 'Brad', 'Pitt',1960), (2, 'Christian', 'Bale',1960); select * from oyuncu; insert into filo (oscar,fno,ono) values ('Evet',1,2); insert into filo (oscar,fno,ono) values ('evet',2,5); select * from filo; 3