I HAVE TO CREATE NORMALISATION IN 1NF, 2NF AND 3NF AND I AM STRUGGLING TO DO THEM CAN ANYONE HELP:
Here is the scenario i have been given:
Its for a fitness club, asked to set up a new system to keep track of members and current booking.
The club has a range of facilities, catering for all ages, all bookable in advance.
For the purpose of booking, each day is divided into 15 sessions. Each session lasts for one hour. The club opens at 7.00 am and closes at 10pm.
Members are divided into catergories
Junior - 12-16
Intermidiate 16- 18
Adult - Standard - all session
Adult - Restricted - off peak sessions only
Members of the the club can book the facilites for one or more session, for which a charge is mafe, Costs for each facility differ, These costs are to be recorded in the database.
Junior and Intermediate catergories receive 10% reduction from the standard rate. Adult restricted memebers receive a 25% reduction from the standard rate.
Can anyone help thanks!