Locker+Allocation+Normalisation

Pupils at Duncastle Academy can pay a £10 deposit to get a locker in which to store their books and belongings. To save money, some pupils choose to share the locker and only pay a £5 deposit.

Mrs O'Neill keeps track of which pupils use which lockers in the table shown below.



Normalise the data to UNF and 1NF