Project Detail

Description

DMV Revenue Project

In recent months, the DMV in New York started having difficulties in keeping up with the accounting issues associated with Driver Licenses and Road Tests.

The DMV has many offices in various places in the state (such as Queens, Brooklyn, Nassau, Suffolk) and each office houses many DMV Evaluators for road test. Each office is identified with a unique code. An application for a driver license is accepted after passing a written test (no application is accepted until a person passes the written test and eye examination).

At the moment of original application, a fee of $50 is collected from each applicant and then a road test is arranged for each applicant. An applicant can take many road tests until a DMV evaluator gives him/her an OK. However, an applicant must pay $100 for each road test given. Once the road test is passed, an applicant is issued a drivers license at a fee of $75.

The DMV director has asked your assistance in developing an accounting system to keep track of applications and the road test fees. Based on your expertise in Microsoft Access you accepted to design and ERD diagram that can be used to develop this new system.


Required:
a)Identify entities, attributes and primary keys for the system

b)With the help of foreign keys establish relationships between those entities that could be used for this purpose. Using the notation we used in the class draw an ERD diagram.

c)Create an MS ACCESS database tables and relationships based on the ERD diagram you have developed above…

d)Populate those tables with fictitious persons and transactions at least 3 DMV offices, with 2-4 Evaluators in each office, and 4-5 applicants with one or more road tests)

e)Print MS Access reports showing
a.Entity Relationship Diagrams
b.Road tests to given on a specific date by each DMV office and total revenue from road tests.






Additional information submitted:

12/08/2008 at 22:35 EST:
This project has to be done by 12/9 Tuesday Midnight.

Additional files submitted:
DMV Revenue Project.doc