Database Answers Ski tracks in Villars, Switzerland

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Issue Tracking Software
Back to the Data Model. 

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

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

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

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



Barry Williams
17th. November 2006
Principal Consultant
Database Answers.org

 

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map