Database Answers City Temple.

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
George Orwell's 1984
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

     

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