问创建中的MYSQL错误

EN

CONSTRAINT Sessions_Screen_ID_FK FOREIGN KEY (ScreenID) REFERENCES screen(ScreenID),

Drop Database IF EXISTS AE2_ISYS114;

CREATE Database AE2_ISYS114;

CREATE TABLE AE2_ISYS114.branch(
BranchID            char(2) NOT NULL,
BranchName          varchar(20),
BranchSuburb        varchar(15),
BranchPostCode      char(4),
PRIMARY KEY (BranchID)
);



CREATE TABLE AE2_ISYS114.movie(
MovieID                 char(2) NOT NULL,
MovieName               varchar(20),
MovieGenre              varchar(20),
MovieClassification     varchar(5),
PRIMARY KEY (MovieID)
);


CREATE TABLE AE2_ISYS114.screen(
ScreenID                char(2) NOT NULL,
BranchID                char(2),
ScreenCapacity          int(3),
PRIMARY KEY (BranchID,ScreenID),
CONSTRAINT Screen_Branch_ID_fk FOREIGN KEY (BranchID) REFERENCES Branch(BranchID)
);


CREATE TABLE AE2_ISYS114.sessions(
SessionID               char(4) NOT NULL,
BranchID                char(2),
ScreenID                char(2),
MovieID                 char(2),
SessionDate             DATE,
SessionPrice            Decimal(4,2),
PRIMARY KEY (SessionID),
CONSTRAINT Sessions_Branch_ID_fk FOREIGN KEY (BranchID) REFERENCES branch(BranchID),
CONSTRAINT Sessions_Screen_ID_FK FOREIGN KEY (ScreenID) REFERENCES screen(ScreenID),
CONSTRAINT Sessions_Movie_ID_fk FOREIGN KEY (MovieID) REFERENCES movie(MovieID)
);