Problem 4: (5 Points). The following table records performance gigs. The primary

Question

Problem 4: (5 Points). The following table records performance gigs. The primary key is underlined Performance: (Gigld, GigName, GigDate, StartTime, EndTime, Locationld, LName, Bandld, BandName) Additional FDs BandldaBandName LocationIdàLName me Time LocationID Lname Bandl Band 10:30 Gigl gi | GigDate | Gig Name | TI Start End Name 1 12/28/2015 JL Brunch 1 Jucy 1 Acoustic 12:30 PM Lucy's Mayhem Patio 11 Sams Lodge 2 Leonard Curry 2 19 /2015 Fins Bar 09:00 11:00 PM PM Tri 3 1 /10/2015 Private 09:00 11:00 1 Juciy lAcoustic Mayhem Birthday PM PM Lucy's Patio 11 Sams Lodge 9 Lime Light 4 1/11/2015 Ski Spree 10:00 12:00 l Acoustic Mayhem I Acoustic Mayhem AM PM 5 1/1S/2015 Lime Light 10:00 11:30 5 year Anniversary PM PM 2 Leonard Curry 6 1/16/2015 Aspen Ski 12:00 01:30 10 Fannys Lodge spree event PM AM party Tri Given the primary key and additional functional dependency above, answer the following questions: a. Is the table in BCNF? If not, normalize it to BCNF. b. Show final BCNF tables with data in them

Explanation / Answer

(a) No ,the given table is not in BCNF because there is redundency in data.

let A = Gigid, B =GigDate, C= Gig Name, D = Start Time, E = EndTime, F =LocationID, G =LName, H=BandId, I = BandName

In ABCDEFGHI where A is primary key

we can see there is two composite condidate keys in table

A -> FG

A -> HI

F -> G

H -> I

thereFore , The Table Needs to Normalise in BCNF

(b) :

Here the primary key is underlined and Foriegn Keys are in Bold .

Table : Performance (GigId, GigDate, GigName, StartTime, EndTime, LocationId, BandId)

Lime Light 5

Years Anniversary

Aspen Ski Spree

event Party

2

Table : Band (BandId, BandName)

Table : Location (LocationId, LocationName)

GigId GigDate GigName StartTime EndTime LocationId BandId 1 12/28/2015 JL Brunch 10:30 AM 12:30 PM 1 1 2 1/9/2015 Fins Bar 9:00 PM 11:00 PM 11 2 3 1/10/2015 Private Party 9:00 PM 11:00 PM 1 1 4 1/11/2015 Ski Spree 10:00 AM 12:00 PM 11 1 5 1/15/2015

Lime Light 5

Years Anniversary

10:00 PM 11:30 PM 9 1 6 1/16/2015

Aspen Ski Spree

event Party

12:00 PM 1:30 AM 10

2

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---