Database Answers Robert Blake, Electra Glide in Blue, 1973

Printer Printer-friendly version.

Home Ask a Question Careers Contact us Data Models First Timers Search Site Map
Traffic Cops and Tickets
   Back to the Data Model.

The Draft Business Rules have been defined and are listed below.
The Area being Modelled is :-
  • Traffic Cops and Tickets.
  • Cops in Indiana issue tickets and warnings. A. DESIGN NOTES : A.1 There are no Notes for this Design. B. The Things of Interest, ('THINGS'), include :- B.1 Officers B.2 Police Departments B.3 Prosecutors Offices B.4 Tickets B.5 vehicles B.6 violaters B.7 violation information, etc. B.8 Warnings C. These THINGS are Related as follows :- C.1 A VEHICLE can be involved in one or many VIOLATIONS. C.2 D. Other Characteristics of these THINGS include :- D.1 An OFFICER can have one and only one BADGE_NUMBER. E. Sample Data includes :- E.1 To be determined F. Typical Enquiries include :- F.1 To be Determined
  •  
    
    Barry Williams
    9th. June 2003
    Principal Consultant
    Database Answers
    Home Ask a Question Careers Contact us Data Models First Timers Search Site Map