Explain Why A Relational Database Would Be Suitable.
You are required to build a database system to record details for a non-profit organisation that manages the squash competition around Perthshire with the main headquarters centred in Perth (Scotland).
The main part of the system is to receive and acknowledge any new member registrations, using a friendly user interface - this allows a prospective member to enter their personal details (i.e. name, address, contact, etc.). Although the organisation is non-profit and a registered charity, it does permit new members to make a compulsory donation once they have completed the membership form. This donation itself can either be done via (BPay, Visa or cheque) with the later accepted by staff members at the various courts around Perthshire.
A newsletter is one of the main forms of communication between the administrators of the league and the players, this newsletter sets of the rules of competition, the scoring and a list of actual games that players are scheduled to play at the main centre in Perth. This newsletter is sent to all the members on a monthly basis and allows the members to send any feedback to the organisation to the company secretary who manages all the administrative functions of the organisation.
Concerning the actual games: Each singles game records two players and one result from that particular division. Players can only compete within their own particular set division. When a match has being completed a score is recorded in the following format 3 set format (e.g. 11-5, 3- 11, 11-6). The system needs to be able to record each players win and loss, the points on the ladder, matches played.
A separate part of the system will contain the competition ladder which is divided into a number of separate divisions, the five (5) divisions are based on age, with the open draw also separated by sex (i.e. an open women`s competition, and a men`s competition) with each division having a number of positions or rankings according to the players` proficiency and their accumulated points throughout the season.
The system will need to also identify future fixtures that is it should show any scheduled games to be played in the near future (i.e. 1 month ahead of time). It should also have an archival facility in that it will show any past fixtures for that season along with the scores.
The system will need to record the various staff members at the squash court centre, so a record is kept of who took payments from which member. This member will also act as the official and umpire for the various fixtures throughout the season. Since this is a charity organisation, the staff members are also players from the various divisions of the ladder, which naturally means that their personal details are also recorded on the system.
Task 1
Business Case
Task 1A. Explain why a relational database would be suitable information system for the organisation such as the one provided in the case study and provide (3) three reasons to support your recommendation (500 words).
Task 1B. Explain (3) three distinct advantages concerning what a database management system provides to any organisation. Note: Make these relevant to the organisation in the case study (500 words).
Requirements Definition
Read the case study carefully, and decide what are the important (i.e. key) features of the system. Construct a basic prototype that will display the following:
Task 1C. Design a set of Initial screens that can be shown to the client - this allows for the input of information to satisfy the user requirements, you should produce at a minimum (5) five forms. Submit a softcopy that has a set of screen shots that illustrate the screen designs with appropriate narrative for each screen. (100 Words)
Task 1D. Design a set of typical reports that would be appropriate for the proposed company database - this requires you to assume the role of the user/manager and list three (3) likely reports he/she might need to do their job. It must show the report, its main features, and then populate it with some likely test data. Submit a softcopy that has a set of screen shots that illustrate these proposed screen designs. (100 Words)
