CREATE TABLE Kinomani ( ID number(3) CONSTRAINT Os_PK PRIMARY KEY, Imie varchar(10), Nazwisko varchar(15) not null, Narodowosc varchar(15) ); CREATE TABLE Filmy ( ID number(3) CONSTRAINT Fl_PK PRIMARY KEY, Tytul varchar(20) not null, Czas date, Rok_prod number(4), ID_Rez number(3) CONSTRAINT Fl_Rez_FK REFERENCES Kinomani, cena number(3) ); CREATE TABLE Sale ( ID number(3) CONSTRAINT Sa_PK PRIMARY KEY, L_miejsc number(4) not null, Nazwa varchar(12) ); CREATE TABLE Recenzje ( ID number(3) CONSTRAINT Re_PK PRIMARY KEY, Tytul varchar(12) not null, ID_Kinomani number(3) CONSTRAINT Re_Os_FK REFERENCES Kinomani, ID_Filmu number(3) CONSTRAINT Re_Fl_FK REFERENCES Filmy, Tresc varchar(4000) not null ); CREATE TABLE Obsada ( ID number(3) CONSTRAINT Ob_PK PRIMARY KEY, ID_Filmu number(3) CONSTRAINT Ob_Fl_FK REFERENCES Filmy, ID_Kinomani number(3) CONSTRAINT Ob_Os_FK REFERENCES Kinomani ); CREATE TABLE Miejsca ( Nr number(3) CONSTRAINT Mi_PK PRIMARY KEY, Nr_Sali number(3) CONSTRAINT Mi_Sa_FK REFERENCES Sale, Cena number(3) ); CREATE TABLE Seanse ( ID number(3) CONSTRAINT Se_PK PRIMARY KEY, ID_Filmu number(3) CONSTRAINT Se_Fl_FK REFERENCES Filmy, Godz date, ID_Sali number(3) CONSTRAINT Se_Sa_FK REFERENCES Sale, Data date, Cena number(3) ); CREATE TABLE Bilety ( ID number(3) CONSTRAINT Bi_PK PRIMARY KEY, ID_Seansu number(3) CONSTRAINT Bi_Se_FK REFERENCES Seanse, Nr_Miejsca number(3) CONSTRAINT Bi_Mi_FK REFERENCES Miejsca, Data_Sprzedazy date );