UNIVERSITY OF HERTFORDSHIRE CS2/CSE2/CSP3/CSP4

SDD Coursework2: Willowbank Assessment Arrangements

Willowbank will be assessed by demonstration only. The demonstrations will be held in the week beginning 27th April 1998. There are a total of 25 marks for this coursework. During the demonstration of your system your lecturer will assess:

The functionality we will test is indicated below. We will perform tests using the test data in the format given. In order to complete our tests we will need to be able to alter your system's current date, please ensure this is possible.

In addition to preparing your system you must also submit the following to your lecturer at the beginning of your demonstration:

Note: Failure to submit any of the above will result in the deduction of 2 marks per item; a poor standard of submitted work will result in the deduction of 1 mark per item.

It might also be in your interest to bring along your design information (e.g., ERM, DD, storyboards etc.) should you need to explain design decisions made by your team asked during the demonstration. This will not be handed in, and therefore does not need to be written up.

Note: All team members will receive the same mark for this coursework unless a case for differential marking is made to Stella in advance of the first demonstration date.

Tested Functionality

  1. display a member's details on the screen

  2. modify a member's details

  3. (a) display outstanding bookings for a specified member
    (b) display outstanding bookings for a member, including total owed.

  4. display courts available for sport at specified time.

  5. (a) make bookings - single hour
    (b) make bookings - longer session

  6. record payment for bookings

  7. cancel bookings

  8. produce summary report of takings in period to specified date.

  9. record playing of session

  10. pay subs in advance of the end of year.

  11. (a) produce overdue members list
    (b) payment of overdue subscription for existing member >

  12. (a) register a new member
    (b) calculate subscription due

  13. set subscription rate for following year

CS2 SDD - 'Willowbank' Demonstrations - Test Data 1998

This document describes data and test cases which we will use when testing your program during the demonstration; the copy of the program that you bring to the demo should already have this data stored.

Members

There are currently sixteen members, with (for convenience sake) the names AXXXX, BXXXX through to PXXXX; you can enter any reasonable data you like for the other member details (address, telephone number, etc), but we will expect this data to exist!. Membership numbers (if applicable) are to be decided by you, or by your program.

Subscriptions

Note that it will be necessary to vary the 'current date' as far as the program is concerned, to test various aspects of the subscription-handling subsystem, so your prototype should get its "current" date from the keyboard, not from the system clock.

The current subscription rate of £24.00 per year has been in force since September 1997. For the purpose of your demonstration, the current year ends on 31/8/98. The current date (initially) is 01/03/98. All of the members listed above are paid up for the year ending 31/8/98.

Obviously we will want to roll the current date forward through the end of year to test the subscription system thoroughly.

Bookings

The following price bands (these may no longer match those given to you by the Sellers, but they are consistent with those used in the provided database) are in force for court hires:-

Price Band id Hourly Rate

'A' £ 2.50
'B' £ 3.00
'C' £ 3.50
'D' £ 4.00

The following 'active' bookings (at least) should be already recorded (as at 01/03/98):-

Member Date Booked Booked Session( Date, Court, Time, Price Band, Status.)
AXXXX 15/02/98 28/02/98 intennis1 17:00 'C' played/paid
AXXXX 15/02/98 28/02/98 intennis1 18:00 'D' played/paid
AXXXX 15/02/98 04/03/98 intennis2 17:00 'C' pending/paid
AXXXX 15/02/98 04/03/98 intennis2 18:00 'D' pending/paid
AXXXX 15/02/98 06/03/98 intennis2 17:00 'C' pending/not paid
AXXXX 15/02/98 06/03/98 intennis2 18:00 'D' pending/not paid
AXXXX 20/02/98 02/03/98 squash2 19:00 'D' pending/not paid
AXXXX 20/02/98 05/03/98 squash4 19:00 'D' pending/not paid

LXXXX 18/02/98 02/03/98 squash3 19:00 'D' pending/not paid
LXXXX 18/02/98 05/03/98 squash2 19:00 'D' pending/not paid

CXXXX 16/02/98 01/03/98 squash1 19:00 'D' played/paid
CXXXX 16/02/98 02/03/98 squash1 19:00 'D' pending/paid
CXXXX 16/02/98 05/03/98 squash1 19:00 'D' pending/paid

PXXXX 24/02/98 27/02/98 badminton1 10:00 'A' played/paid
PXXXX 24/02/98 07/03/98 badminton1 10:00 'A' pending/paid
PXXXX 24/02/98 08/03/98 badminton1 10:00 'A' pending/not paid
PXXXX 24/02/98 09/03/98 badminton1 10:00 'A' pending/not paid
PXXXX 24/02/98 10/03/98 badminton1 10:00 'A' pending/not paid

HXXXX 27/02/98 27/02/98 badminton2 10:00 'A' played/paid
HXXXX 27/02/98 07/03/98 badminton2 10:00 'A' pending/paid

HXXXX 27/02/98 07/03/98 badminton2 11:00 'B' pending/paid

HXXXX 27/02/98 09/03/98 badminton2 10:00 'A' pending/paid

HXXXX 27/02/98 09/03/98 badminton2 11:00 'B' pending/paid

These pages were automatically generated using the WORD internet assistant and tidied up by Stella George.
©SDD