Question

Write a relational algebra query AND list the result as a table (use A for Actor, Sfor Show, P for Performance) List the year of the shows that were performed by any actor in Wicked Example: Find the name of actors who performed in "Hamilton'or 'Wicked' shows own (A P (Chowme - Hamilton or showWwWichead S)) actorName Sylvia Andrea Bob Mary

chart:

Answer 1

a. the List performed of shows that were actor in wicked. by any c) Actor ID of actors who worked in wicked =) B = TactorID / P A Show name = Wicked it will give us the table of Actor ID who worked in Wicked 5)) Year =) Tyear (PXB) → Tycan (PN (MacherID (PA (oshow Name = Wicked S) Ans It will produce a list the year of the show that were performed by by any actor in wicked → Show Name = Wicked S where table s it gives show Name = wicked a row from ShowID director ID Show Name Showcity Wicked New York 602 503 join this table top PA (Show Name = Wicked ActorID ShowID | Role Year Show Name Showcity directorID 5o1 602 Wicked Galinda | 2013 New York 503 506 602 Elphaba 2005 Wicked New York 503 We select only Actor ID So the table is Actor ID 504 506 Now this table to P we again join PMTTActerzo (PM (Show Alamedwicked S))) Actor ID Show ID Year 2013 602 501 506 Role Galinda Shophie Elphaba 604 2006 506 602 2005 =) At last we select Year So New table & Year 2013 2006 2005