Consider the following tables describing musical groups and the venues at which they perform:

Band

BNo BName Type Rate

900 Rodeo Riders Country 230.00

901 Bluesmen Blues 225.00

902 Rockers Rock&Roll 200.00

903 Harmony Girls Folk 250.00

904 V Sonata Classical 260.00

Venue

VNo VenueName Capacity

50 The Range 200

51 Town Arena 520

52 Highland Lounge 60

53 Music Hall 410

54 Townline Hall 25

Permformances

VNo BNo Date

50 900 9/19/18

51 903 9/20/18

50 904 9/20/18

52 901 9/20/18

51 902 9/21/18

53 900 9/21/18

52 901 9/21/18

50 902 9/22/18

51 903 9/22/18

53 904 9/22/18

52 902 9/22/18

a. Assuming that BNo and VNo are unique identifiers, what are likely primary keys for the Band and Venue

tables?

b. What is the primary key for the Performances table assuming the a band can perform at the same location on

mulitple dates?

c. What are the foreign keys necessary to ensure that only registered groups can perform only in registered

venues? Identify the table and column that must be foreign keys and also the table at columns to which the

foreign keys refer.

d. Can you add a tuple (904, Brass Kings, Classical, 195.00) to the Band table? Why or why not?

e. Can you add the tuple (50, 902, 9/24/18) to Performances table? Why or why not?

f. Can you remove the tuple (54, Townline Hall, 25) from the Venue table? Why or why not? What about