phase1 markdown documentation.md

GROUP 7

FOOTBALL DATABASE MANEGEMENT SYSTEM

1. CLUB

Field Name	Example of Data	Comments (Description)	type of data
Employee_ID	87908767		INT
Department	medical	takes care of medical details for players	VARCHAR(10)
Address	'16789 108 ST'	includes address of all employees
City	Vancouver	city where wmployee lives
Postal_adress	v3t5l8	postal adress of eployee
Email_address	includes email address of all employees
Mobile_number	2364537698	mandatory to have one

2. PLATERS

Field Name	Example of Data	Comments (Description)	type of data
Employee_ID	87908767
First_name	Cosmas
Last_name	Otoyo
Title	Assistant_coach
Department	medical	takes care of medical details for players
Address	'16789 108 ST'	includes address of all employees
City	Vancouver	city where wmployee lives
Postal_adress	v3t5l8	postal adress of eployee
Email_address	includes email address of all employees
Mobile_number	2364537698	mandatory to have one
points	18
rebounds	78	postal adress of eployee
assists	26
championships	2

3. COACH

Field Name	Example of Data	Comments (Description)	type of data
games_won	2	gives number of games the coach has won in his career
games_lost	6
awards	4

4. FACILITIES

Field Name	Example of Data	Comments (Description)	type of data
fooball_pitches	2	gives details of pitches owned by a club
gym	2	gives details about the gym
SWIMMING COMPLEX	4
MEETING ROOMS	9

5. EQUIPMENTS

Field Name	Example of Data	Comments (Description)	type of data
CLEATS	80	gives details about the CLEATS
SHIN_GUARDS	70	gives details about the SHIN_GUARDS
balls	70	gives details about the balls
water_bottles	70	gives details about the water_bottles
uniform	280	gives details about the jersey,training kits etc