QUESTION 1 Consider the following three tables from the Microsoft Access database created for the consumer organisation LOYALTY. Assume that Referential Integrity has been enforced on the relationships between the tables. McKee Steve 5 Sunline St Seaview 5045 131101198 2 600066 Hamison Mr Steve 6 Crows Cres Croydon 5054 331101199 7568 3 70007? Ponting Fro Ricky 7 Power PI Plympton 5046 221021200 6454 4 800088 Hawn Ms Goldie '8' Hollywood CIHollywoo 407B $103119? 5637 wy 5 900099 Harpy-Williams Ms Kathry 9 Netball Ave Netley n 151031199 5014 8 Tl l-' Adelaide Melbourne 2 5102 F Adelaide - Sydney 1250 3 5103 F Adelaide - Brisbane 2150 4 5104 F IAdelaide - Damin 2350 5 5105 F Adelaide - Hobart 1400 6 5106 F Adelaide Perth 1950 7 5401 R IJclleys Adelaide 800 8 5402 R IGekkos Adelaide 850 9 5901 A Stamford Adelaide 900 A Hilton Adelaide '600066 5402 0210812005 70007? 5105 0210812005 1400 100077 5103 0810812005 2150 '800088 0410812005 900099 0210812005 U'l-hLONH (1) By selecting specic example records in the AWARDS and REDEMPTIONS tables, carefully explain the nature of the relationship between AWARDS and REDEMPTIONS