Three Stooges
ACCESS 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.

Create tables in ACCESS for the Stooges.
Doing the queries is OPTIONAL.
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.

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/