System Analysis And Design Soccer Club Database Computer Science Essay

System Analysis And Design soccer Club database Computer Science EssayThe aim of this project is to program and implement the database application to replace the current paper placement of the soccer Club. This is the objective of governance. The commissioning of soccer association urgencys to part this clay for fraction registration, topple payment, creation of sumes disceptation, isthmus up the reproduction seances, publishes the provide of distributively game. The checkes want to affair this agreement to altogetherocation of aggroup.c) A selective information flow rate Diagram for the system including (12 marks) Process descriptions1. Register segmentship, when macrocosm want to total the atomship, the delegation of Soccer club black market admit the application from to public, and obtain the application from is complete or non. And verified their ID and contact address. If the information is correct. wherefore will collect the fractionship fee an d create the membership batting order to the member. And the information of the member will keep in the member confuse put over.2. squad allocation, the coach will get the playing members information from the member card give in. And the coach will adopt the compatible member into the on game propensity. This is use to join the game of League and Cup. And in all case will update the information of the squad to the police squad up hedge elude. For example select the superior of the group.3. Plan learning Session, the Soccer club pay block a number of discipline sessions, the learning session is manoeuver by world(prenominal) shammer. When the mission of Soccer club setting up the development sessions, they need to connect with planetary thespian for aim the session. And the international player needs to confirm to baksheesh the sessions. The data of international player is livestock in international player defer fudge and the data of cookery session is set up in cultivation postp bingle and and(a) bow.4. fashion stronghold lists, when the Soccer club joins the game of unify contestation and cup competition. The compact competition and cup competition will collect new(prenominal) 15 teams and provide the fixture list to the Soccer club. The charge of Soccer club need to publish this fixture list to the public, let them know the category team, away team, score address, match day and time. This data will keep in fixture list and expiry hold over. In this fixture list we also will know which team will join the league and cup. new(prenominal) Soccer teams information will store in former(a) teams slacken delay.5. Publish result, all the result of the matches, will be provide from the league competition and cup competition. The result of Soccer club and opposite teams also need to collect. This data will store in the result give in display board, they will publish the result to the public. Data store hold over of contents1. subdivision item, This is the shelve of members information. It embarrass the field fraction_ID, ring, Date_of_Birth, elementship_type, Ph single, organise, netmail, user_ID, group_ID, On_game_list, commission_ID2. team Detail, This is the dodge o f Soccer Cups squad. It include the field Team_ID, handler_ID, Captain_ genus Phallus_ID, Vice_Captain_ section_ID, Team_ frame, Member_ID3. world(prenominal) thespian Detail This is the plank of international players information, this plank include the field fraud_ID, Ph whizz, Address, Email, Salary, user_ID4. Training Detail, this is the dodge of Trainings information, it include this field Session_ID, get word, Player_ID, Player_ urinate, session_ unbutt geniusd_day, Address, time, total_hour, Session_Fee, delegacy_ID5. Other_Teams Detail, this is the table of other teams information which team ar join the match with Soccer club. This table include the field Other_team_ID, call down6. Fixture names and result Detail, this is table of the match list and the result of the match. This table include the field Match_ID, Team_ID, Other_team_ID, Match_address, Date, Time, Team_score, Other_team_score External entity definitions1. Member of Public, this is the people who join the Soccer club membership and they amaze been pay the membership fee all(prenominal) year. They send word be playing members or simply social members.2. take aim and world-wide player, this is the people who responsible for didactics and selecting the team. And they also make the arrangements for travelling to matches at other Soccer club. And the international player is the trainer of open training session.3. deputation, this is the people who responsible for organizing open training sessions, inviting international players to lead the sessions, advertising the training sessions and determining and collecting the fee for such sessions. And they also need to collect and publish the matches result. 4. League and cup, this is the local league competition and local cup competition, the Soccer join the match by this dickens competitions. They provide the matches result and the fixture lists to the Soccer club.Task 2 piddle a data model detailing the data structure need to support the information and process requirements of the soccer club system includinga) An Entity kind Diagram for the system. (6 marks)b) Entity descriptions for all entities in the diagram. (4 marks)1. drug user2. handler3. Member4. Team5. rank6. military commission7. Other team8. Training9. Fixture run and vector sum10. multinational Player11. Training assimilator12. scholarc) clutch attributes for all entities including primary and foreign winders. (5 marks)1. Entity exploiter object lens pillow slip coition exposition This is a table for the user login ID and give-and-take. The user of this system will use the information of this table to login. puts User_ID, User_Login, Password, Group essential discover User_ID2. Entity Coach determination shell apprisal interpretation The coachs personal information which system need are store in this table. prop Coach_ID, Name, Address, Ph unmatchable, Email, User_ID old get a line Coach_ID contradictory identify User_ID recognitions to User table.3. Entity Member design type relation stick out exposition This is a table to store members indicate.Attribute Member_ID, Name, ID_card_number, Date_of_birth, rank_type, name, Address, Email, User_ID, On_game_listPrimary keystone Member_ID alien notice User_ID bring ups to User table table.Foreign samara military commission_ID roles to delegacy table4. Entity TeamObject slip proportion definition This is a table to store Soccer club player teams record.Attribute Team_ID, Coach_ID, Captain_Member_ID, Vice_Captain_Member_ID, Team_Name, Member_IDPrimary keystone Team_IDForeign Key Coach_ID names to Coach table.Foreign Key Member_ID references to Member table.5. Enti ty stanceObject Type RelationDescription This is a table to store the position of committals record.Attribute Position_ID, Position_namePrimary Key Position_ID6. Entity committalObject Type RelationDescription This is a table to store the committee record.Attribute commission_ID, Team_ID, Position_IDPrimary Key charge_IDForeign Key Team_ID reference to Team table.Foreign Key Position_ID reference to Position table.7. Entity Other TeamObject Type RelationDescription This is a table to store the record of other Soccer team which will match with Soccer Clubs team.Attribute Other_team_ID, NamePrimary Key Other_team_ID8. Entity TrainingObject Type RelationDescription This is a table to store the open training sessions record.Attribute Session_ID, Name, Player_ID, Player_Name, Session_open_day, Address, Time, Total_hour, Session_Fee, Committee_IDPrimary Key Session_IDForeign Key Player_ID references to transnational Player.Foreign Key Committee_ID references to Committee.9. Entity Fi xture add ups and ResultObject Type RelationDescription This is a table to store the record of fixture Lists and the match result.Attribute Match_ID, Team_ID, Other_team_ID, Match_address, Date, Time, Team_score, Other_team_scorePrimary Key Match_IDForeign Key Team_ID references to Team table.Foreign Key Other_team_ID references to Other team table.10. Entity International PlayerObject Type RelationDescription This is a table to store the record of international player. The international player is the trainer of open training session.Attribute Player_ID, Phone, Address, Email, Salary, User_IDPrimary Key Player_IDForeign Key User_ID references to User table.11. Entity Training StudentObject Type RelationDescription This is the link entity of Training table and Student table. Because one scholarly person can join some(prenominal) training session and one training session can sacrifice some students. So we need to use link entity to resolve this m whatever another(prenominal) to numerous relationship.Attribute Training_studnet_ID, Session_ID, ID_card_NumberPrimary key Traininig_student_IDForeign Key Session_ID references to Training table.Foreign Key ID_card_number references to Student table.12. Entity StudentObject Type RelationDescription This is a table to store the record of student.Attribute ID_card_number, Name, Phone, Address, EmailPrimary Key ID_card_numberd) alliances detailing non obligatoryity and head of relationships between entities. (5 marks)1. kindred ID R1Name Coach table to User tableObject Type family relationshipDescription apiece coach has lone(prenominal) one unique User_IDCardinality one to one,Coach table is the one side. wiz User_ID scarcely pop off to to one coach.User table also is the one side. unmatchable coach only has one unique User_ID. facultative Coach table is the nonobligatory side. A user may be not a coach.User table is the compulsory side. A coach must be a user.2. Relationship ID R2Name International Player table to User tableObject Type RelationshipDescription Each international player has one unique User_IDCardinality one to oneInternational Player table is the one side. wholeness User_ID only can belong to one international player.User table also is the one side. sensation international player only has one User_ID.optional International Player table is the optional side. A user may be not a international player.User table is the mandatory side. A international player must be a user.3. Relationship ID R3Name Member table to User tableObject Type RelationshipDescription Each member has one unique user_ID.Cardinality one to oneMember table is the one side. One User_ID only belong to one member.User table is the one side. One member only can work one User_ID.Optional Member table is the optional side. A use may be not a member.User table is the mandatory side. A member must be a user.4. Relationship ID R4Name Member table to Team tableObject Type RelationshipDescription Membe r belongs to Ruby Clubs team.Cardinality many to oneMember table is the many side. One team can give way many members.Team table is the one side. One member only can belong one team.Optional Member table is the optional side. A team may be not has any member.Team table is the optional side. A member may be not belongs to any team.5. Relationship ID R5Name Team table to Coach tableObject Type RelationshipDescription Each team must have a coach.Cardinality one to oneTeam table is the one side. One coach only can belong one team.Coach table is the one side. One team only can have one coach.Optional Team table is the optional side. A coach can have any team to lead.Coach table is the mandatory side. A team must have a coach.6. Relationship ID R6Name Member table to Committee tableObject Type RelationshipDescription some(a) member is the committee of Soccer Club.Cardinality many to oneMember table is the many side. One committee position can belong to many members.Committee table is the one side. One member only can have one committee position.Optional Member table is the mandatory side. A committee position must belong to member.Committee table is the optional side. A member may be not have a committee position.7. Relationship ID R7Name Position table to Committee tableObject Type RelationshipDescription Each committee member of Soccer Club has a position.Cardinality one to manyPosition table is the one side. One committee members only can have one position.Committee table is the many side. One position only can belong to many committee members.Optional Position table is the mandatory side. A committee must have a position.Committee table is the optional side. A position may be not belongs to any committee member.8. Relationship ID R8Name Team table to Committee tableObject Type RelationshipDescription every(prenominal) committee member belongs to their team of Soccer Club.Cardinality one to manyTeam table is the one side. One committee member only belong one te am.Committee table is the many side. One team can have many committee members.Optional Team table is the mandatory side. Every committee member must belong to a team.Committee table is the optional side. A team may be not has any committee member.9. Relationship ID R9Name Team table to Fixture List and Result tableObject Type RelationshipDescription The team of Soccer Club will have match will other team.Cardinality one to manyTeam table is the one side. One match only can join with one Soccer club team and one other team.Fixture List and Result table is the many side. One team can has many matches to play.Optional Team table is the mandatory side. The match must have Soccer clubs team.Fixture List and Result table is optional side. A team may be not has any match.10. Relationship ID R10Name Other Team table to Fixture List and Result tableObject Type RelationshipDescription Some member is the committee of Soccer Club.Cardinality one to manyOther Team table is the one side. One matc h only can join with one Soccer club team and one other team.Fixture List and Result table is the many side. One other team can have many matches to play.Optional Team table is the mandatory side. The match must have Soccer clubs team.Fixture List and Result table is the optional side. A team may be not has any match.11. Relationship IDR11Name Committee table to Training tableObject Type RelationshipDescription Committee member with responsibility for this open training session.Cardinality many to oneCommittee table is the one side. One session will lead by one committee member.Training table is the many side. One committee member can lead many training session.Optional Committee table is the mandatory side. The training session must lead by committee member and international player.Training table is the optional side. A committee member may be not lead any open training session.12. Relationship IDR12Name International Player table to Training tableObject Type RelationshipDescriptio n International player with responsibility for this open training session.Cardinality many to oneInternational Player table is the one side. One session will lead by one international player.Training table is the many side. One international player can lead many training session.Optional Committee table is the mandatory side. The training session must lead by committee member and international player.Training table is the optional side. A international player may be not lead any open training session.13. Relationship IDR13Name Training Student table to Training tableObject Type RelationshipDescription It is a link entity to solve the many to many relationship of Training table and Student table. It break it to two one to many relationships.Cardinality many to oneTraining Student table is the many side.Training table is one the side.Optional Training Student table is the mandatory side.Training table is the mandatory side.14. Relationship IDR14Name Training Student table to Student t ableObject Type RelationshipDescription It is a link entity to solve the many to many relationship of Training table and Student table. It break to two one to many relationships.Cardinality many to oneTraining Student table is the many side.Student table is the one side.Optional Training Student table is the mandatory side. The student must take training session, if not take the training session, only is public not student.Student table is the mandatory side.Task 3 piddle an Entity Life History for a training session.First is Join Member stage, then Member Amendment is the second stage, this stage can be repeat. And down the stairs this stage have three options, Change Membership Type, Change person-to-person table and Do nothing. Finish this stage will become to Membership Overdue stage. This is the third stage of member. It has two options, Pay membership fee and Resign Member. If choose Pay member fee, then will back to the Member Amendment, and if choose Resign Member, then will become the stick out stage of member Delete Member. This is the end of this entity.Task 4 Create a database design for the soccer club system includinga) A set of tables identifying primary and foreign keys.(10 marks)User (User_ID, password, Group)Coach (Coach_ID, Name, Address, Phone, Email, User_ID)Team (Team_ID, Coach_ID, Captain_Member_ID, Vice_Captain_Member_ID, Team Name)Member (Member_ID, Name, ID_card_num,ber, Date_of_birth, Membership_Type, Phone, Address, Email, User_ID, On_game_list, Committee_ID, Team_ID)Position (Position_ID, Position_name)Committee (Committee_ID, Team_ID, Position_ID)Other team (Other_team_ID, Name)Fixture List and Result (Match_ID, Team_ID, Other_team_ID, Match_address, Date, Time, Team_score, Other_team_score)Training (Session_ID, Session_Name, Player_ID, Session_open_day, Address, Time,Total_hour, Session_Fee, Committee_ID)International Player (Player_ID, Player_Name, Phone, Address, Email, Salary, User_ID)Training Student (Training_student_I D, Session_ID, ID_card_number)Student (ID_card_number, Name, Phone, Address, Email)b) Data Dictionary entries for all items included in the database design. (10 marks) accede Name User card Type Entity Description It contains users detail. This is a table that includes all users password and login name.Data regionName arrangeKeyUser_IDCHAR(10)Primary KeyUser_LOGINVARCHAR(20)PasswordVARCHAR(15)GroupVARCHAR(15) panel Name Coach accede Type Entity Description It contains coachs detail. This is a table that includes the personal information of coach.Data battlefieldNameFormatKeyCoach_IDCHAR(10)Primary KeyNameVARCHAR(50)AddressVARCHAR(50)PhoneCHAR(8)EmailVARCHAR(30User_IDCHAR(10)Foreign Key reference User tableTable Name Member Table Type Entity Description It contains members detail. This is a table that includes the members membership type, belong to which team and their personal information.Data scene of actionNameFormatKeyMember_IDCHAR(10)Primary KeyNameVARCHAR(50)ID_card_number CHAR(8)Date_of_birth bookingMembership_typeCHAR(1)PhoneCHAR(8)AddressVARCHAR(50)EmailVARCHAR(30User_IDCHAR(10)Foreign Key reference User table.On_game_listCHAR(1)Committee_IDCHAR(10)Foreign Key reference Committee table.Team_IDCHAR(10)Foreign Key reference Team table.Table Name Team Table Type Entity Description It contains teams detail. This is a table that includes the name of team, the coach of team, the captain and the vice captain of the team.Data eye socketNameFormatKeyTeam_IDCHAR(10)Primary KeyCoach_IDCHAR(10)Foreign Key reference Coach table.Captain_Member_IDCHAR(10)Vice_Captain_Member_IDCHAR(10)Team_NameVARCHAR(50)Table Name Position Table Type Entity Description It contains position name and unique identifier..Data business lineNameFormatKeyPosition_IDCHAR(10)Primary KeyPosition_NameVARCHAR(50)Table Name Committee Table Type Entity Description It contains committee detail. This is a table that includes the information of the committee is which position of which team.Data FieldNameFormatKeyCommittee_IDCHAR(10)Primary KeyTeam_IDCHAR(10)Foreign Key reference Team table.Position_IDCHAR(10)Foreign Key reference Position table.Table Name Other Team Table Type Entity Description It contains other team detail. The other team is the team which will match with Soccer clubs team. This table includes their name and unique identifier.Data FieldNameFormatKeyOther_team_IDCHAR(10)Primary KeyNameVARCHAR(50)Table Name Training Table Type Entity Description It contains open training sessions detail. It includes the date, time and the trainer.Data FieldNameFormatKeySession_IDCHAR(10)Primary KeyNameVARCHAR(50)Foreign Key reference Coach table.Player_IDCHAR(10)Foreign Key reference International Player tableSession_open_dayDATEAddressVARCHAR(100)TimeTIMETotal_hourCHAR(2)Session_Fee decimalCommittee_IDCHAR(10)Table Name Fixture List and Result Table Type Entity Description It contains the fixture list and match result detail.Data FieldNameFormatKeyMatch_IDCHAR(10)Primary KeyTeam_IDCHAR(10)Foreign Key reference Coach table.Other_team_IDCHAR(10)Foreign Key reference International Player tableSession_open_dayDATEAddressVARCHAR(100)TimeTIMETotal_hourCHAR(2)Session_FeeDECIMALCommittee_IDCHAR(10)Table Name International Player Table Type Entity Description It contains the international player (open training session coach) detail. It includes their name, salary and personal contact.Data FieldNameFormatKeyPlayer_IDCHAR(10)Primary KeyNameVARCHAR(50)PhoneCHAR(8)AddressVARCHAR(100)EmailVARCHAR(50)SalaryDECIMALUser_IDCHAR(10)Foreign Key reference User table.Table Name Training Student Table Type Entity Description It contains link entity of Training and Student tables.Data FieldNameFormatKeyTraining_student_IDCHAR(20)Primary KeySession_IDCHAR(10)Foreign Key reference Training table.Student_IDCHAR(10)Foreign Key reference Student tableTable Name Student Table Type Entity Description It contains the open training sessions student detail. This includes the ID car d, name and contact of student.Data FieldNameFormatKeyID_card_numberCHAR(8)Primary KeyNameVARCHAR(50)PhoneCHAR(8)AddressVARCHAR(100)EmailVARCHAR(50)Task 5 Create a prototype user port for the soccer club system including, as a minimum, the following functionsa) Adding a new member. (5 marks)b) Creating a fixture list for a team. (5 marks)c) Recording a match result. (5 marks)Task 6 You are responsible for organising the initial training of the system users and producing the User Guide for the new system.Create an outline training plan for the new system including who would be trained, how the session(s) would be organised (e.g. all together, small groups, etc.) (8 marks)This is the training plan of the Soccer club system, the objective is want the user understand more to the highest degree the system, and let them user this system smoothly.We have three user groups need to training, Public, Coach and Committee are our target. The public user group we want they know how to use thi s system to download application form, view the fixture list and view the result of match. The coach user group we want them understand how to allocate team. And the committee user group we want them understand how to create new member, couch member detail, create fixture list, update fixture list, create match result and update match result.We will give training session to each user group and give user guide with print screens to them. And need a computer room let them use the system at the training session.For the public user group we need slightly 30 minutes to training. The coach user group we need about 60 minutes to training. And the committee user we need about 2 hours to trainingGroupUserSkillMaterialPublicMember and publicDownload application from look on fixture listView match resultPublic user guideCoachTeam coachAllocation teamCoach user guideCommitteeCommittee memberCreate new memberUpdate member detailCreate fixture listUpdate fixture listCreate match resultUpdate m atch resultCommittee user guide Create a User Guide for the system. This should not be a comprehensive system manual but a reference document that users can use as a active guide to the tasks they need to carry out. (10 marks)Task 7 Create a comprehensive, professional standard report describing your system design for the soccer club. This should include the details of tasks 1 6 including the User Guide.Reference1 Colin Bentley, 2002, NCC Education Managing telephone circuit objectifys, second edition, Galatea Training Services Limited, Singapore2 Mark Brown, 2002, Project precaution in a week, Hodder Stoughton, UK3 Sue Craig, Hadi Jassim, People and Project Management for IT, McGraw-Hill4 Dinsmore, capital of Minnesota C, 1993, The AMA Handbook of Project Management, New York AMACOM Books, 1993, New York5Lewls, James P, 1995, Fundamentals of Project Management, New York AMACOM Books, 1995, New York6 Toby Teorey, 2008, Database design know it all, Morgan Kaufmann7 M. Vaziri and D. Jackson, Some shortcomings of OCL, the Object Constraint Language of UML, MIT, 1999.8 N. V. Cuong and X. Qafmolla, Meta-model Transformation with Kermeta, in 13th International gathering OBJEKTY 2008 proceedings, p. 109-116.9 Object Management Group, Business process modeling notation, February 2006,