a. Before developing a database solution, Eventbase had been using a

spreadsheet to record basic information about events. A fragment of this

spreadsheet is used in this question see Figure 5). The fragment shows the

event id, the date of the event, what it's called, where it will be held with details

about the location capacity and accessibility, the event organiser and the contact

number for the event organiser.

The company used the following relation as the template for the spreadsheet

columns. Each row in the spreadsheet holds data about one event:

Event (EventID, Date, Title, Location, Address, Capacity,

AccessRestrictions, OrganiserName, ContactNumber)

The following rules are known to always hold between the attributes of the above

relation:

1. A value of EventID uniquely determines a single Date value.

2. A value of EventID uniquely determines a single Title value.

3. A value of EventID uniquely determines a single Location value.

4. A value of EventID uniquely determines a single Capacity value.

5. A value of EventID uniquely determines a single Address value.

6. A value of EventID uniquely determines a single AccessRestrictions value.

7. A value of EventID uniquely determines a single OrganiserName value.

8. A value of EventID uniquely determines a single ContactNumber value.

9. A value of Location uniquely determines a single Capacity value.

Tutor-marked assignment TMA 02: View as single page 04/01/2021, 17:55

https://learn2.open.ac.uk/mod/oucontent/view.php?id=1677905&printable=1 Page 13 of 20

Figure 5 The relation Event represented by a table of sample data

10. A value of Location uniquely determines a single Address value.

11. A value of Location uniquely determines a single AccessRetrictions value.

12. A value of OrganiserName uniquely determines a single ContactNumber

value.

A table of sample data representing the relation is shown in Figure 5.

Date Title Address Capacihr E 10:09:22 11 Rustic Town Fully accessible. HDQIZZ Stars by Starlight 10, Half-acre Wood Fully accessible. \"-J I!" INBIZZ 13, The Lake 145 Long steep path to lakeside. Site vehicle available to assist. Disabled access to carpark at side of site. 10f09f22 Tea at Tall Trees Tall Trees 5 a. 13, The Lake Long steep path to lakeside. Site vehicle available to assist 11 Rustic Town 14f062 Fully accessible. E- 8 9 Stars by Sta rlight 10. Half-acre Wood Fully accessible. Lakeside Ma nor 17f09f22 Proms by the Lake 13, The Lake 145 Long steep path to lakeside. Site vehicle available to assist. 00125 582112 Promotions Bugle industries Bugle industries Parker Promotions 00125 582112 00551 9923]. Parker Promotions 00123 332112 Bugle industries Bugle industries 555 12381