Hi there, I wish to design a database system for a training company but i am having problems with normalising them first. They have training schedules,
visits to clients and trainers. The fields are:
Training Needs Visit worksheet:[/B]
Department Visited
Contact Visited
Contact Telephone Number
Contact eMail Address
Date of Visit
Time of Visit
Training Consultant Name
Training Consultant Telephone Number
Training Consultant eMail Address
Visit Duration
Visit Outcome
Further Actions
Training Plan
Training plan worksheet:
Course Title
Date of Training
Time of Training
Training Duration
Training Type
Trainer Name(s)
Trainer Telephone Number(s)
Trainer eMail Address(‘)
Number of Staff to be Trained
Location
Feedback
Course Fee (for group)
Invoiced?
Paid?
In addition to the spreadsheet data, i also need to store
information about the different client companies, including:
Company Name
Address
Town
Postcode
Telephone Number
Number of Employees
I need to sort them out into 1nf to 3NF. Can anyone please help to solve this?
