الرجاء المساعده

السلام عليكم

انا حاليا اقوم بعمل مشروع وواجهتني بعض العقبات ارجو منكم المساعده

ارجو من الاخوان معرفة طلبي لا اريد حلا للمشروع باكمله ولكن هناك جزء لم افهمه لذا فساكتب وصف المشروع بالانجليزية

هناك نقاط معينه فقط لا اعرفها ارجو المساعده فيها

( كما سبق وذكرت ارجو من الاخوة فهمي :لا اريد حلا للمشروع وانما فقرق معيته سوف اشير لها لكي تكون واضحه مع العلم بان وصف المشروع بالانجليزية لكن اذا اراد احد معرفة اي شي فانا مستعد لايضاحها بالعربية)

Consider a football league. There are five kinds of roles in this game: player, audience, organizers, team employees, and volunteers. Some common attributes are shared by all of these people: ID (identifier), Name, Address, City/State/Zip, Birth_Date, and Phone. Each of the five groups has at least one unique attribute of its own. Players have a Position (Forward, Back or Center), organizers have a Date_Organized, Team Employees have a Date_Hired, Volunteers have Skills, and Audiences have a Attend_Date

Additional person in the game does not belong to one of these five groups (their numbers are relatively small). However, a particular person may belong to two (or more) of these groups at any given time (for example, Volunteer and Audience).

Each player belongs to one (and only one) team. A team should have at least twelve players, and should have at least two Backs, two Forwards and one Center. In each team, one of the players is assigned as the team leader. Team has Team_Id and T_Name

Employee has three kinds of job: coach, physician and staff. Coach has coach certificate, and physician has the physician license. Each employee could have only one kind of job. Each employee belongs to one (and only one) team. A team could have no staff. But it can’t have more than two coaches.

Each team should play at least one match. Each match has exactly two teams, three referees and three staff. Referee should be member of organizer. If a volunteer has the computer skill, he could be chosen as staff otherwise staff come from organizers. Match has three attributions: Match_Id, Date_Held and Staidum ID. We need record the scores of the two teams in this match

Teams play according to a schedule. Each team has a home stadium where they practice and play matches. The match scores and the crowd attendance is recorded for each match

Each Stadium has one (and only one) manager, who is a member of the organizer.

Audience could order one or more seats on his Attend_Date. Seat could be only assigned to one audience. The only attribute of seat is Seat_Id (identifier); Seat_Id is a composite attribute, which components Stadium# and Seat#. The Audience will watch the match if and only if he gets a seat in the stadium where the match will be held. Audience could be fans of some players