Back to the Data Model.

A. What are the Requirements ?
A.1 A Database to track Problems with Software Products.

B What are the Things of Interest ?
B.1 Problems
B.2 Problem Log
B.3 Products
B.4 Staff

C. How are they Related ?
C.1 A Problem can have one or many entries in the Problem Log.
C.2 An entry in the Problem Log is assigned to one member of Staff.
C.3 When a Problem is closed, it is authorised by a member of Staff.
C.4 Each entry in the Problem Log is categorized.
C.5 Each entry in the Problem Log has a Status, eg 'being fixed', 'fixed'.

D. What else do we know about them ?
D.1 A Problem has a description.
D.2 Each entry in the Problem Log has its own description.
D.3 Each entry in the Problem Log is assigned to a member of Staff.
D.4 Each entry in the Problem Log has its own description.