a.

• i.Using the data in Figure 5, and the uniquely determines rules 1-12, describe, with an example, how an update anomaly might arise.

• ii.Briefly explain why Event is in first normal form.

• iii.Briefly explain why Event is in second normal form.

• iv.Event is not in third normal form. Identify what prevents Event being in third normal form and then split the relevant attributes into new tables so that the resulting tables are in third normal form.

Address Location Park Lane Contact Number 00123 382112 11 Rustic Town EventID Date Title E00282 10/09/22 Proms in the Park E00275 1/09/22 Stars by Starlight E00271 1/08/22 Twilight Tales Capacity AccessRestrictions OrganiserName 250 Fully accessible. Parker Promotions 300 Fully accessible. Bugle industries Haven Field 10, Half-acre Wood 555 12381 18, The Lake 145 Lakeside Manor Bugle industries 555 12381 Long steep path to lakeside. Site vehicle available to assist. Disabled access to carpark at side of site. E00283 Tall Trees Windy Lane 60 10/09/22 Tea at Tall Trees 00123 382112 Parker Promotions E00284 145 11/09/22 Proms by the Lake 18, The Lake 00551 99231 Lakeside Manor Long steep path to Oscorp events lakeside. Site vehicle available to assist. Fully accessible. Parker Promotions Fully accessible. Bugle industries Park Lane 11 Rustic Town 250 00123 382112 300 555 12381 E00285 14/06/22 Tea Dance in the Park E00290 15/09/22 Stars by Starlight E00291 17/09/22 Proms by the Lake Haven Field 10, Half-acre Wood 18, The Lake 145 Lakeside Manor Bugle industries 555 12381 Long steep path to lakeside. Site vehicle available to assist