Sedang Disiapkan

MS Access Project (Urgent)

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

[url removed, login to view] Relationship Diagrams

[url removed, login to view] tests to given on a specific date by each DMV office and total revenue from road tests.

Kemahiran:

Lihat lebih lanjut: access project, system tests, purpose accounting system, office relationships, design access database, accounting offices, accounting office design, urgent road test, erd diagram examination system, using diagram dmv, microsoft access project job, access erd project, revenue access database erd, dmv diagram, draw diagram msaccess data, dmv project, draw erd access, access projects york, access based erds, best access project websites, dmv erd, dmv revenue project answers, dmv revenue project, microsoft access test, access new york

Tentang Majikan:
( 1 ulasan ) Bayside, United States

ID Projek: #354828

Dianugerahkan kepada:

univedge

hi, i can do this. kindly check PM

$150 USD dalam sehari
(63 Ulasan)
2.4

16 pekerja bebas membida secara purata $202 untuk pekerjaan ini

MAnkita

Hello,Please refer your PMB.Thank you.

$250 USD dalam 7 hari
(262 Ulasan)
5.4
yousefla

Let's start

$250 USD dalam 3 hari
(93 Ulasan)
4.4
infoisoft

Dear Sir, SERIOUS BIDDER. Please check PM. Regards, Jainam Shah, iSoft Solutions.

$250 USD dalam 5 hari
(75 Ulasan)
3.8
BestWeb4U

Dear Sir/Madam I can do this project best possible. I am a expert, in making website designs, graphic designs, logo designs, banner, flash,OSCommerce, Joomla, DotnetNuke, PHP/Mysql, ASP, ASP.Net, Smarty, Access, MS SQ Lagi

$250 USD dalam 5 hari
(401 Ulasan)
3.6
guruplus

Hi Please refer the PMB Regards

$250 USD dalam 15 hari
(5 Ulasan)
1.0
stanny

gret job... let's take it done...

$100 USD dalam 7 hari
(0 Ulasan)
0.0
RAKHEEGUPTA

PLEASE SEE PM

$100 USD dalam 4 hari
(1 Ulasan)
1.0
shimona

Hi, I have been developing software systems for several years now. Try me out, you won't be disappointed. Look forward to your reply. Regards, Shimona. Hi again, I cannot post a message on the PMB; it Lagi

$225 USD dalam 3 hari
(64 Ulasan)
0.0
thoughtinreality

Hello thanks for review my bid. pl chk pmb for reference. with regards thanks

$190 USD dalam 7 hari
(1 Ulasan)
0.0
felisha

Hi, Please see the PM for more details of the project. Due to some problem not able to post Private Message. Can soon update you with our previous work. Thanks.

$220 USD dalam sehari
(0 Ulasan)
0.0
YashpalSingh123

Hi, Expert computer Engineer,I would providing you Right Solution..,Can Start work on Immediately effect. Thanx

$225 USD dalam 6 hari
(27 Ulasan)
0.0
mihirkale2006

i can provide you with the best solution.

$250 USD dalam 6 hari
(0 Ulasan)
0.0
vpbothre

I am new but I can provide you an excellent job that you required.

$99 USD dalam 4 hari
(0 Ulasan)
0.0
karloston1979

Please check sample file PM. I am ready to start your job.

$222 USD dalam 5 hari
(1 Ulasan)
0.0
COGWebTech

Hi, We are very much interested to do this project. Regards

$200 USD dalam 5 hari
(2 Ulasan)
0.0