Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
MOVIE TIME
CREATE TABLE Admin ( AID INT NOT NULL, Afname VARCHAR(15), Alname VARCHAR(15), Aemail VARCHAR (50), Apassword VARCHAR (10), Aphone VARCHAR (10), Abirth_date DATE, PRIMARY KEY(AID) ); CREATE TABLE Branch ( Bname VARCHAR(15) NOT NULL, Bcity VARCHAR(15), Bvenue VARCHAR (15), PRIMARY KEY(Bname) ); CREATE TABLE Screen ( Branch_name VARCHAR(15) NOT NULL, Sc_number INT NOT NULL, Sctype VARCHAR(15), FOREIGN KEY (Branch_name) REFERENCES Branch(Bname), PRIMARY KEY(Branch_name, Sc_number) ); CREATE TABLE Movie ( MID INT NOT NULL, Mname TEXT, Mgenre TEXT, Mdescrption TEXT, Mrun_time VARCHAR (8), AdID INT NOT NULL, FOREIGN KEY (AdID) REFERENCES Admin(AID), PRIMARY KEY(MID) ); CREATE TABLE Movie_dates ( MoID INT NOT NULL, Mdate DATE NOT NULL, FOREIGN KEY (MoID) REFERENCES Movie(MID), PRIMARY KEY(MoID, Mdate) ); INSERT INTO Branch (Bname,Bcity,Bvenue) VALUES ('VOX CINEMA', 'Riyadh', 'Riyadh Park'); INSERT INTO Branch (Bname,Bcity,Bvenue) VALUES ('Movie', 'Riyadh', 'U Walk'); INSERT INTO Branch (Bname,Bcity,Bvenue) VALUES ('Movie Theaters', 'Jeddah', 'AlYasmin Mall'); INSERT INTO Branch (Bname,Bcity,Bvenue) VALUES ('S Branch', 'Khubar', 'AlRashid Mall'); INSERT INTO Branch (Bname,Bcity,Bvenue) VALUES ('Fun Time', 'Riyadh', 'AlNakheel Mall');
run
|
edit
|
history
|
help
0
Loan
yoo
correlated subquery & top & view & derived table & group by
OUTPUT CLUASE
Mahi
Microsoft SQL Server T-SQL in 10mn ~ Lesson 15. Creating Advanced Joins samples...
tables
VANYA
Sql flight 1
Alquileres