ok im sorry for the less informaton given... i hope that posting the senario is helpfull rather than telling what i understood..
"Wallsherpool Sixth Form College is located in the North East of England. Vicky Wilkinson is the performing arts teacher. She produces performances at various times during the year. Some of the performances are used to generate evidence for students studyingA-level performing arts, others are purely for fun. The next production will be The Wizard of Oz and it is a performance for fun. It will be performed for the general public over a number of dates.
Every performance needs students to take a range of production jobs, for example sound Crew, directing crew and actors. Students specify the production job they would like to have. They keep the same job on all productions they are involved in.Each production has characters, which only actors can be assigned to play. For example,in The Wizard of Oz there is a character called Dorothy. Only one actor is assigned to a title role, such as Dorothy. Up to ten actors can be required for a bit part character, such as winged monkeys.Currently Vicky keeps handwritten records of students and productions. She is finding this stressful as it is hard to make sure production jobs have been filled and all characters have actors assigned to them.
Vicky knows you are studying ICT and thinks you could
develop a more efficient IT-based solution to register students and manage the productions. In the first instance it has been agreed that you will design and build a prototype relational database system that will focus on three tasks."
so according to this senario i should normalise the data files i've posted before ... and i find it difficult... i would appreciate if you can see to it