Project Description
• This project manages the Egyptian league competition between Egyptian teams.
• Each team contains many players.
• Each team play two matches against all of its competitors.
• The system should handle the competition from the teams, players and scores of matches.
• The system should handle scores between teams and players who score the goals.
• According to the rules of Egyptian league the winning team takes (3) points, loser team takes no points and if the two teams are equivalent each one take (1) point.
• The system has two main entities:
o Team: Each team has basic information (Name – Id – Address – president –….)
o Player: Each player has basic information (Name – Id – Team – position – birth date –salary- age….).
System Required Functions
1- For Team
a. Enter team information.
b. Display team information.
c. Update team information.
d. Search for team using (id - name).
e. Display team players.
f. Display team detailed scores and order.
2- For Player
g. Enter player information.
h. Display player information.
i. Update player information.
j. Search for player using (id – name - team).
k. Display player goals.
3- General Functions
n. Display teams ordered by their points.
o. Display top (3) players who score the greatest no of goals.
p. Display top (3) goalkeepers who have the fewest no of goals.
q. Display top (3) players ordered by their ages.
r. Display top (3) players ordered by their salaries.
s. Display teams ordered by no. of scored goals.
t. Display teams ordered by the average ages of its players.
u. Display teams ordered by the average salaries of its players.
• This project manages the Egyptian league competition between Egyptian teams.
• Each team contains many players.
• Each team play two matches against all of its competitors.
• The system should handle the competition from the teams, players and scores of matches.
• The system should handle scores between teams and players who score the goals.
• According to the rules of Egyptian league the winning team takes (3) points, loser team takes no points and if the two teams are equivalent each one take (1) point.
• The system has two main entities:
o Team: Each team has basic information (Name – Id – Address – president –….)
o Player: Each player has basic information (Name – Id – Team – position – birth date –salary- age….).
System Required Functions
1- For Team
a. Enter team information.
b. Display team information.
c. Update team information.
d. Search for team using (id - name).
e. Display team players.
f. Display team detailed scores and order.
2- For Player
g. Enter player information.
h. Display player information.
i. Update player information.
j. Search for player using (id – name - team).
k. Display player goals.
3- General Functions
n. Display teams ordered by their points.
o. Display top (3) players who score the greatest no of goals.
p. Display top (3) goalkeepers who have the fewest no of goals.
q. Display top (3) players ordered by their ages.
r. Display top (3) players ordered by their salaries.
s. Display teams ordered by no. of scored goals.
t. Display teams ordered by the average ages of its players.
u. Display teams ordered by the average salaries of its players.
Asked Mar 26, 2013
0