Chapter 3: Part 1

Exercise 3.2 (Page 3-13)
=============
A sports club maintains records of its members showing name, category of membership and payment details. Members are either life members or standard members. Life members do not pay membership fees, so no payment details are needed.

Draw a data structure diagram to represent this data.

Exercise 3.4 (Page 3-16)
=============
The treasurer of a local sports and social club wishes to record all financial transactions on the computer. The club has four different categories of membership; junior, senior, life membership and monthly membership. As a consequence, different subscription rates apply.

Juniors and life members do not pay subscriptions. Subscriptions are payable each January for senior members, whereas monthly members pay monthly, 12 times per year. The treasurer wants a record of when members have paid so that, at the end of the financial year (December) when he does his accounts, he can identify those members who have missed paying a subscription.

Draw a structure diagram for the file.

Exercise 3.3 (Page 3-13)
=============
A train consists of an engine followed by a number of 1st class coaches, then a number of 2nd class coaches with a guards van at the end. Draw a data structure diagram to represent this structure.



Exercise 3.6 (Page 3-18)
=============
Produce the data structure diagram for the following file:
Stock File:
===========
- There are two types of records within this file, the main record and trailer records.
- Each main record is followed by as many trailer records as there are outstanding orders for that part.
- Note that these trailer records are part of the data in the record.
Main record:
=============
- Part number
- Description
- Quantity in stores
- Minimum re-order quantity
- Delivery lead times (weeks)
- Current price

Trailer records:
================
- Order number
- Order quantity
- Order week number