Back to the Data Model
Requirements :-
Every citizen must live in one property.
Only the owner of the car can drive the car.
No citizen earns more than £200 per month except Police and Government officals
All payments must be acompanied with a citizen ID card, so citizen spend can be tracked.
Citizens are resident in an area and they cannot leave the area without authorisation.
Possibly a offenders database which would contain known associates.
B. Things of Interest :-
B.1 Areas
B.2 Associates
B.3 Cars
B.4 Citizens
B.5 Citizen ID Card
B.6 Products
B.7 Properties
B.8 Purchases
B.9 Offenders
B.10 Payments
B.11 Properties
C. How are they related ?
C.1 Citizens are resident in one and only one area.
C.2 Only the owner of a car can drive the car.
C.3 Every citizen must live in one and only one property.
C.4 No citizen earns more than £200 per month except Police and Government officals
Barry Williams
10th. May 2003
Principal Consultant
Database Answers