Shows(Sid, title, synopsis, genre, language, dateOfRelease) Users(login, passwor

ID: 3601648 • Letter: S

Question

Shows(Sid, title, synopsis, genre, language, dateOfRelease)

Users(login, password, country, DOB, name, email)

Review(Rid, dateAndTime, text, rating, Sid, login)

castAndCrew(Pid, name, DOB, placeOfBirth, Sid)

Episodes(Sid, Snum, duration, releaseDate, SeasonNum)

Roles(Pid, roles, character)

ReviewRating(Rid, login, rating)

ShowRating(Sid, login, rating)

ShowTags(Sid, tags)

Movies(Sid, rating, duration)

TVShows(Sid, status, network)

VideoBlogs(Sid, duration)

Review(Sid) references Shows(Sid)

Review(login) references Users(login)

castAndCrew(Sid) references Show(Sid)

Episodes(Sid) references Show(Sid)

Roles(Pid) references castAndCrew(Pid)

Roles(Sid) references Shows(Sid)

ReviewRating(Rid) references Review(Rid)

ReviewRating(login) references Users(login)

ShowRating(Sid) references Shows(Sid)

ShowRating(login) references Users(login)

ShowTags(Sid) references Shows(Sid)

Movies(Sid) references Shows(Sid)

TVShows(Sid) references Shows(Sid)

VideoBlogs(Sid) references Shows(Sid)

i)Which cast members have played multiple roles in shows j) Find all shows in which Emma Watson has played a role. List show title and role name.

The above query will return the cast name and their role name who played more than one role.

The above query willl be the show title and role name played by Emma Watson.

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.