ISDD+Normalisation

media type="custom" key="28171239"


 * Questions**

1. 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 0NF and 1NF



2. Duncastle County Caravan Club keeps a record of all club members and their bookings in a log book as shown below.

Normalise the data to 0NF and 1NF



3. A bank keeps records of all of its customers, as shown below. Customers can have one or more bank accounts, each of a different type.

Normalise the data to 0NF and 1NF



4. A DVD rental shop stores details of each DVD rented out on a form. The form is shown below.

Each customer can borrow up to 3 films at a time.

Normalise the data to 0NF and 1NF



5. A DIY store records details of each sale on a form as shown below

Normalise the data to 0NF and 1NF



6. John and Valerie Syme breed labradors. They store the details of each puppy the sell along with information about the new owner in a table.

Normalise the data to 0NF and 1NF