Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A small sports club keeps information about its members and the fees they pay. The secretary wants to be able to record when members pay

A small sports club keeps information about its members and the fees they pay. The secretary wants to be able to record when members pay and print a report similar to that in the figure below.

last n me - first_narne - phone - type - gender - fee - date paid

Smith Jane 563201 Full F 22.0 21/09/2011

Wiison Harry 375967 Full M 220 19/09/2011

Green Bert 439871 MidWeek M 150

Jones Bert 295784 Social F 80

Smith Sharon 387548 MidWeek F 150 16/08/2011

a. Think about when the different pieces of data might be entered. Sketch an initial use case diagram for data entry.

b. Consider what different things you are keeping information about and sketch a simple class diagram.

c. What options could you suggest to the club for different ways a report could be presented? Does your class diagram have the information readily available?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases Illuminated

Authors: Catherine M Ricardo, Susan D Urban

3rd Edition

1284056945, 9781284056945

More Books

Students also viewed these Databases questions

Question

How do Excel Pivot Tables handle data from non OLAP databases?

Answered: 1 week ago