Three Stooges
Relational Algebra and Relational Calculus
(TWO WEEKS of lab)

Tables are: Episode, Actor, Star, Gag, GagName.
Attributes of Episode are Eid, title.
Attributes of Actor are Aid, sName.
(Moe, Larry, Curly, CurlyJo, and Shemp)
Attributes of Star are Ai, Eid.
(Assume every episode has three stars if needed.)
Attributes of Gag are gType, dBy, dTo, Eid.
(dBy is actor ID who did the gag, dTo is actor ID who had the gag done to him, Eid is the episode.)
Attributes of GagName are gType and gName.
Sample gags include:
GetOutOfHere, Nyuk Nyuk Nyuk, SlowlyITurn, HeadBonk.

Queries

List all episodes where someone other than Curly does ‘Nyuk Nyuk Nyuk’ (NNN),
List all episodes in which a star has a gag done to him, which he then does to another star.
List all stars that appear in every episode.
List stars that never do headbonk.
List stars that never do headbonk.
List episodes where someone does ‘NyukNyukNyuk’ to Curly
List episodes where both starts do the same gag to Moe.

WEEK2:
Predicate Calculus Group Assignment
In your small group, TOGETHER do two Predicate Calculus queries from the above list.
Then, do ONE of those two queries in SQL.
SUBMIT: Stooges Relational Calculus LAB

Predicate Calculus Group Individual Assignment
As an individual, do two Predicate Calculus queries from the above list, that were NOT done by your group.  Then, do ONE of those two queries in SQL.
SUBMIT: Stooges Relational Calculus Indv

Optional Background
If you are curious and are not familiar with the three stooges, here is some background information.
https://en.wikipedia.org/wiki/The_Three_Stooges_filmography
http://www.threestooges.com/
https://www.threestooges.com/2019/07/17/summer-fun-with-the-three-stooges/