Titanic Leisure Centre is a medium sized Leisure Centre in the London Borough of Folgate. It contains a gym, a large sports hall suitable for indoor sports such as 5-a-side football, badminton and basketball, a smaller sports hall used for martial arts and two swimming pools (one large and one small). Titanic Leisure Centre is run by Mr. Radagast Imperio and employs various other staff such as gym instructors, receptionists and assistants. It also employs various instructors for particular sessions such as Judo and Karate. Customers of Titanic Leisure can either be full members who pay a monthly fee by direct debit, associate members who pay a fixed yearly fee and get a reduction on whatever activity they want to do or guest members who pay full price for activities as they do them. As well as individual customers Titanic Leisure also puts on various special sessions for particular groups in the community such as a Jewish Men‟s Swimming session, a Women Only Swimming Session and a Over 60s‟ gym session. These special sessions are blocked booked for particular times every week in the name of a particular group e.g. the Folgate Women Swimmers Club. Depending on the room particular sessions might be booked by individuals, set aside for a community activity, or they might be open to all. So, for example, badminton sessions must be booked by an individual customer. Where an activity is organised by Titanic themselves then it is marked as being booked to „TITANIC‟. An example of this is a Karate or Judo session where an instructor is provided.
entities i have pulled out are
hello guys this is my scenerio for a school project can some one please help me come up with a normalization for this scenerio or idea thanks my email is firstname.lastname@example.org
cause when i get to thinking about booking and session it comes like the same thing and it driving me nuts cause i have to do it in oracle so i decided to do it in access first.. but when i get to booking and session i just get confuse. can you give me a lil wisdom on any error or abonormities.. against i decided to make customer type in teh customer table cause the customer can be groups or can be individual. do them entities look right
i no staff is a recursive relationship because a staff assign a next staff to the activity i dont no how to implement that into the database design to show which staff assigned a next staff this scenerio is driving me nuts
can you explain something how would you look at booking and session in this scenerio. that what killing me. i dont no how to normalize the booking and the session table would need the most normalize. cause in my customer td everything depends back to the primary key..
do you like the idea how i put customer type entity to distinguish between group and individual customer?
well while i looked at my table it all looked normalized perfectly because all the attributes look dependent on the primary key.. but my problem is when i start to create the table is the booking and session table... how would you recon those would be related
Session-Staff Schedule Form For any scheduled session, show all the staff assigned to it. This form should facilitate the allocation of existing staff to an existing session.
Activity-Equipment Schedule Form This form should facilitate the allocation of existing activity to existing equipment.
Session Form This form should allow the setting up of sessions for rooms. It should look something like Figure 3.
Block Booking Form For a group customer show the block bookings they have made and which sessions these block bookings belong to. This form should, therefore, link existing groups with existing sessions via a block booking.
these are the different form which my database would need so do you think that my current design can achieve that all you could say is yes or no then i no if i going in the right direction and bdw would your book assist me in this scenerio