Racism

JOHN SMITH





CENTRE NUMBER: 29225





UNIT 2: HANDALING INFORMATION





ASSIGNMENT 3




TEAM DATABASE











What the user Needs or the problem
The manager of my local Football league team has asked me to set up a system, which will enable him to keep all the information about each player on a single database. Because some of the information is private I.e. date of birth, cost to the club, date of transfer this must be in the same database but on a different table.
The system when set up must allow the user/the manager to search for a particular players address and /or telephone number.
A copy of the database should also be able to be printed in alphabetical order and numerical order.


What information is needed?
We need to know what information the manager is currently using so that different tables can be created.
I will require dummy or test data to put in the database.
From the information given the following tables will be req...