This is probably a easy an simple task to someone that can take only a matter of minutes, but im new to this

Please will someone help me with my coll work....i have been given a task to normalise this data in to 3NF an i am totally stuck help would be very muchly apprecated....

    * Evidence of Normalisation to third normal form (3NF)


So basically just Normalising to 3NF the headers from ther tables :
Reference
Organisation Name
Address1
Town
Telephone
Email
Contact Name
Post Code

LAst NAme
First Name
Date of Birth
Department
Organisation

Course Code
Revision
Last Name
First Name
Orgnisation

Course Code
Course Title
Tutor Name
Course Date
Duration

I think altogether there should be some where around 7 tables :S but not sure!!


BELOW i have included my task an the 4 sets of data i have been given which i will have to expand on...i need to normalization to this an pick out foreign keys an primary keys

The proposed system

You have decided to use database software to provide a more efficient solution.

The following is a list of specific requirements:

•        A number of well designed queries that are appropriate to the scenario.
•        A user interface that allows users to carry out all record operations.
•        Reports that show the following information:
o        A list of all courses along with delegates that are attending
o        For statistical purposes, a report that shows a list of all current employees and their current age (Ordered by age)
o        A report that shows a list of delegates for a given course
o        ID badges for delegates of a given course

 Further information regarding requirements can be obtained from your tutor, who is acting as the client. 
Example Data

Organisations
Reference        Organisation Name        Address1        Town        Telephone        Email        Contact Name        Postcode
MONT563        Montreal Buildings Ltd        19 Cavendish Ave        Morey        01244 345020        caven@montreal.com        S. Bradley        MR3 9HG
CAMP01A        Campion Tubes        39-41 Ash Street        Alderney        020 203450        Campion.s@campion.com        P. Khan        AL4 9QA
NORT131        Northern Coaches Ltd        89 Aspect Drive        Maney        021 203402        s.taylor@northerncoaches.com        T. Bailey        MN5 78G
SLEE786        Sleepwell Beds        23-25 Luton Road        Dunstable        041 203403        T.Jones@googlemail.com        T. Jones        DN6 8YH

Delegates
Last Name        Firstname        Date of birth        Department        Organisation
Mason        Philip        10/12/1966        Finance        Drake Scientific Instruments
McGovern        Maynard        03/02/1974        Accounts        Barker & Dobbs
Gunn        Ashleigh        01/04/1986        Administration        Montreal Buildings Ltd

 
Bookings
Course Code        Revision        Lastname        Firstname        Organisation
SS001        164        Osler        Chuck        Blunts Building Designs
SS001        164        Norton        Roger        Collingwood High School
DB003        168        Ratford        Linda        Cheadle Heath Clubs
WP001        162        Parker        Clive        Chivers Property Developments
WP001        162        Adams        Tony        Montreal Buildings Ltd

Course Code        Course Title        Tutor Name        Course Date        Duration
SS001        Excel Spreadsheets for Beginners        Phil Smith        29th January 2009        1 Day
DB        Access Database Skills        Terry Bradley        29th January 2009        1 Day
WP001        Word Processing Skills        Hannah Kendall        10th April 2009        1Day
WP002        Advanced Word Processing Skills        Hannah Kendall        9th April 2009        2 Days
VB020        Visual Basic Programming        Naseer Ahmed        9th April 2009        2 Days
VB030        Visual Basic Programming (Advanced)        Naseer Ahmed        10th April 2009        1 Day


** Please note that these data lists are not exhaustive, you are to provide additional data to test/demonstrate your solution.

 
TASK 2 – 50%
Design, implement and test a database solution for a given problem.

For this task you will be designing, implementing and carrying out testing of a database solution to satisfy the requirements of the given case study.

A) A number of features are to be implemented in your solution, these are:

•        A series of queries to retrieve information from the database
•        The implementation of forms to allow simplified user interaction with your database (must support all record functions)
•        The use of appropriate reports in your solution

B) Your submission should consist (but not be limited to) the following:

•        Initial requirements report
•        Evidence of Normalisation to third normal form (3NF)
•        Complete design documentation for your solution.
•        Justification of design techniques employed.
•        The working database
•        Testing of your database

C) Your completed database must make good use of user forms and provide the reporting facilities that are detailed in the case study.