SDD Coursework Project Groups

This methodology was felt to give the best chance to all the Part Time Students by maintaining the grades of the Experts without starving the General Student of the advanced techniques and experiences available.

Work Group Steering Committee Members Harjit Sidhu Richard Reepe Chris Kendall
Team A Harjit Sidhu Allison Black Andy Smith Dawit Teklewold Ronen Peleg Interview Questions	Team B Richard Reepe Damien Healey Eileen McCarthy Simon James Ziba Gazerani Interview Questions Meeting Details	Team C Chris Kendall Asha Makame Gill Watts Lloyd Moore Maryam Selami Interview Questions

Next Coursework Objectives - 7th December 2000

1. Project Progress Summary 1.
2. Use Cases.
3. Class Diagram.
4. Oustanding Questions inhibiting project design.

Willowbank Sports Centre

Booking System Specification

1. Overview

   The Willowbank Sports Centre Booking System is to provide the ability to book time slots on courts for a selection of ball sports and maintain a database of member details. Statistics of member usage and facility access is also to be made available to management personnel.

2. Assumptions

   The following assumptions have been made to allow the initial specification to be drawn up:
   • Default Time Slot Length is One Hour.
   • Company Growth - 25% per annum.
   • Manually Written Receipts.

3. Functionality

   The following system functionality is required:
   1. Book Time Slots for each Play Area.
   2. Book Extended Time Slots for each play area.
   3. Book Regular Time Slots for each play area.
   4. Cancell a Booked Time Slot.
   5. Slot Start Times to be Flexible.
   6. Search for Next Empty Slot.
   7. Search for Required Slot.
   8. Capture Member Details at Booking Time.
   9. Capture Guest Details at Booking Time.
   10. Capture Guest Details at Playing Time.
   11. Ability to Capture Payments.
   12. Report Court Usage:
       • By Court
       • By Sport
       • By Member
       • By Slot
   13. Report Member Usage:
       • By Court
       • By Sport
       • By Slot
       • Fees

4. Coverage

   System must be able to support 25% growth per annum in membership numbers and playing areas for a 5 year period.

5. Security

   Access to the booking and reporting system is to be via UserID and Password only, with two levels of access required:
   1. User: Booking, Cancellation, Fees, Access Reports.
   2. Admin: Setup, Finance Reports, Password Admin.

6. Printing

   No requirements for receipt printing (hand written by receptionist).

7. Hardware

   Must use existing PC hardware, but upgrade of hard disk and or memory to be considered if current spec. too low to support Database access. Must acquire current spec. Backup device required - type TBD.

8. Web Access

   Set up contact page and details with local ISP. Provide mechanism to allow on-line booking of Time Slots (no on-line payments required).

9. Glossary

   • Time Slot: Minimum period of time allocated for a game booking.
   • Play Area: Court Space required to play a game.
   • Extended Time Slots: Several consecutive Time Slots.
   • Regular Time Slots: Time Slot re-occurs periodically.
   • Time Slot Interval: Gap between Regular Time Slots.
   • Flexible Start Time: Time Slot starts not limited to exact hours.
   • Next Available Slot: Next Empty Slot of This Type (Same Sport).
   • Required Time Slot: Actual Time and Play Area.
   • ISP: Internet Service Provider
   • :
   • :
   • :
   • :
   • :
   • :
   • :
   • :

Answers to Test Papers

Program Design Diagnostic 28th October 1999

Information Systems Techniques

Program Design

Systems & Networks 1

Artificial Intelligence

Systems Design

Systems & Networks 2

Computer Network Principles & Applications

Database Systems