Hi Guys ,

I would appreciate any help on the following problem:

Volunteer details Services provided by volunteer
Volunteer No 10
Name Ian Wright
Telephone 020 7089 6576
Address Hard Grove, isleworth

Booking records
client no client name date required hours required service code
004 Lee smith 19/01/08 2 01
004 Lee Smith 02/02/08 1 05
006 Sally Williams 03/02/08 3 09
007 Zaki Patel 03/02/08 1 05




Assume also that additional details are kept for clients, including address, telephone numbers and next of kin. Clients who have pets have information stored on these as well (pet number, pet name, and description). Clients who have children and require baby sitting have the following information: child number, name, date of birth, sex.


Use one of the following: BCNF, 4NF and 5NF. Use any part of the data as illustrated in the scenario above and, in addition you can add your own attributes to assist in the illustration.


the question is to develop BCNF OR 4NF OR 5NF using the scenario above and, in addition you can add your own attributes to assist in the illustration.


Many Thanks!!