North Beach College was founded as a small, liberal arts school just three years ago. Since that time, the institution has grown to the point where parking on campus is difficult and parking in illegal areas is common. Accordingly, the Board of Directors has reluctantly approved a policy requiring gcampus police to issue parking tickets.

Currently, the college requires students and faculty to register their cars with the parking office, which issues them parking decals that registrants must display inside the front windshield of their cars. At present, all record keeping at the parking office is done manually, severely limiting the ability of office personnel to create reports or perform meaningful statistical analyses about parking on campus. For example, it is currently not known how many students of each class (freshman, sophomore, etc.) register their cars or how many full-time faculty, part-time faculty, or clerical staff register their cars. The new policy of writing parking tickets will only add to this problem because it will require office staff to match parking tickets to student or faculty names. In addition, the Board of Directors would like an end-of-semester report indicating how many parking violations of each type (meter violation, invalid parking sticker, etc.) are issued by the campus police.

Requirements

1. Use Microsoft Access (or an alternate DBMS designated by your instructor) to create the three tables illustrated in Figure 7-17.

2. Create at least three records in the car registration table. Be sure to use your own name as one of the registrants. Also, create at least three records for the Parking Violations Code File. Make up your own descriptions instead of using the ones shown in the figure.

3. For each record you create in the car registration table in step 2 above, create at least three parking tickets and input this information to the Tickets File. Thus, you should have at least nine records in this file. Be sure that at least one record in the Tickets File contains a reference to each of the records in the Parking Violations Code File (i.e., at least one person breaks every possible parking violation).

4. Attempt to create a record in the Ticket File that contains a nonexistent ticket code in the parking Violations Code File. Were you successful?

5. Link the tables together. Be sure to check “enforce referential integrity.” When you get finished, your relationships window should resemble the one shown in Figure 8-15. What are the relationships among the records in the three tables?

6. Now again attempt to create a record in the ticket file that contains a nonexistent ticket code in the parking Violations Code File. Were you successful this time?

7. Finally, attempt to delete a record in the Parking Violations Code File. Why can’t you do it?