3. Consider the following tables describing musical groups and the venues at whi

Question

3. Consider the following tables describing musical groups and the venues at which they perform: Performances Groups GID GName 100 Bluesmen 0 Rockers 102 Harmony Girls Folk 03 V Sonata 104 Rodeo Riders Country180.00 Venues VID CName 1 Highland Lounge 50 Capacity VID GID Date MusicType Price Blues Rock&Roll; 175.00 1100 9/19/17 2 103 9/20/17 1104 9/20/17 3 101 9/20/17 2 102 9/21/17 100 9/21/17 3 101 9/21/17 1102 9/22/17 2 103 9/22/17 5 104 9/22/17 3 102 9/22/17 200.00 2 Music Hall 300 150 400 225.00 3 The Range Classical 210.00 4 Town Arena

Explanation / Answer

From the table Performances column VID and GID are the foreign keys that ensures that the groups can perform only in registered venues.

Performances(VID) refers to Venues(VID)
Performances(GID) refers to Groups(GID)

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

---

---

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