CIS431    Dr. Scher    Home Mini Exam #6        Due:  Wednesday, October 15, 2003, 6:00PM

THE DESIGN OF AN IDEF1X DATA MODEL, BASED ON A TRAFFIC CITATION (ISSUED TO THE AUTHOR OF OUR TEXT !)

READ: pp. 73 - 101 in our text, and the Powerpoint module for week 6 ("The Process for Designing Data Models.")

YOUR ASSIGNMENT:

     The above traffic citation (taken from page 107 in "DATABASE PROCESSING") which is issued to the author of our textbook, is officially entitled a "Washington State Patrol Correction Notice." The rounded corners on this form provide graphical hints about the boundaries of entities represented within the form.

    Design an IDEF1X data model, with FIVE entities, based on this form. Use the layout of the form itself, and the data items on the form, to determine your (FIVE) entities, and attributes for those entities, and cardinalities.

    For each relationship that you have, give two appropriate names for the relationship, one for each direction (for instance, see figure 3-20 on p. 98, where we have the "Chairs/Chaired By" relationship names between DEPARTMENT and PROFESSOR.) Be careful to use the appropriate type of relationship, and the appropriate cardinalities.

    Again, be reminded that cardinalities are to be inferred from the layout and data on the form. So, note that there is room for only one registered owner of a vehicle, and for the purpose of this Home Mini Exam, you may make the assumption that the registered owner is the driver of the vehicle. You can also make the assumption that under State of Washington law, the violations line(s) must be filled in to notify the driver of the violation, and it is possible that the driver could be guilty of several violations on a single correction notice. Note also that you may infer that a ticket will be issued by only one officer (since there is room for only a single "Personnel" number for the officer.).

    Your IDEF1X representation of each entity must carefully separate the attributes (if any) of the identifier from the other attributes of the entity set (i.e., the attributes of the identifier are at the top of the "rectangle" and separated from the other attributes by a boundary line.)

    Please have pride and professionalism in drawing your IDEF1X diagram.

ASIDE:  Departments of Transportation in many states will have database applications for tracking traffic summonses, which are based on data models comparable to the one you are designing for this Home Mini Exam.