Examine a query written against the database

Assignment Help Database Management System

Reference no: EM13758758

In this assignment you will be doing the following tasks:

1. You will examine the entity/relationship diagram (ERD) and in writing explain what information the database is holding (not the specific data, but in words what the business application is and how that data can be used).

2. Add data to the database.

3. Examine a query written against the database.

4. Write an additional query.

Assignment Details

Part 1 - You are to examine the entity/relationship diagram (ERD) for the Highway_Patrol.accdb database and describe in business terms (not technical terms) what this database structure is designed to accomplish, who would add data to it (think about each entity) and how an officer would use it. In addition, discuss the minimum information an officer would need to issue a traffic citation.

Part 2 - You are to add the following data to the database. For each case state the minimum data the office needs to issue the citation.

Officer Barker with badge number 777 issued citation number 17 on 11/30/2014 at 13:08 to driver Miller with driver's license A09342 driving vehicle Ford Escort with license number 3JMN5466 for the driving offense of Failure to Stop with a cost of $436. (Note: Be sure to enter the time in the format 13:08:00)

Officer Jones with badge number 444 issued citation number 18 on 11/30/2014 at 14:37 to driver Able with driver's license A19829 driving vehicle Ford Mustang with license number 3BUM1111 for the driving offense of Speeding2 with a cost of $328.

Officer Thompson with badge number 555 issued citation number 19 on 11/30/2014 at 15:37 to driver Rose with driver's license A54203 driving vehicle Chevy Malibu with license number 2JIL9632 for the driving offense of Failure to Stop with a cost of $436. (Note: If you enter this specific record directly, you will get an error. This error should not occur in actual practice. You must figure out why you got the error, correct that and then state in a sentence in your solution as to why the error occurred and how you fixed it. Then explain why this error should never occur in reality.)

You should print out a copy of the Citation table to show that you added these items.

Part 3 - I have created Query1 for you to examine. First run the query and show the results of the query. Then explain how the database was able to get this information. That is, explain what tables the system used and how the tables were matched together to produce this output.

Part 4 - You are to create a query (name it Query2) using the query by example tool (QBE). The query should contain the following data in this order:

Officer Badge Number
Officer Name
Citation Offense
Fine Amount

This data should be sorted in ascending order of the badger number. You should print out a copy of the results of running this query and include that in your assignment.

Attachment:- highway.accdb

Reference no: EM13758758

Questions Cloud

The owners of designit : The owners of DesignIT, who recently purchased 56'x36' space for their expanding business, have asked you to place a bid on a consulting job. DesignIT is a graphic arts company that, up until now, had contracted work out to temporary design services...

Find the average number of customers waiting : A small town with one hospital has 2 ambulances to supply ambulance service. Requests for ambulances during non holiday weekends average .50 per hour and tend to be Poisson-distributed. Travel and assistance time averages 2 hours per call and follows..

Rate is poisson-distributed : A vending machine dispenses hot chocolate or coffee. service time is 30 seconds per cup and is constant. Customers arrive at a mean rate of 72 per hour, and this rate is poisson-distributed.

What is the highest sigma rating : Acme (NC) has long used a central telephone/Internet customer support center based in Jamaica. Data collected by the center show that last year, all but five (5) of every 100,000 calls/accesses received by the center were satisfactorily (to the custo..

Examine a query written against the database : Examine a query written against the database. You will examine the entity/relationship diagram (ERD) and in writing explain what information the database is holding (not the specific data, but in words what the business application is and how that ..

What role does each function play in network design : Within the organization, what groups, or functions (such as operations, sales, and marketing), are involved in a network design project (Simchi-Levi, Kaminsky, & Simchi-Levi, 2008, 108)? What role does each function play in network design? What strat..

Eliminating measles in southern africa : Despite the existence of a safe and effective vaccine, measles persists as one of the most contagious diseases killing more children in Southern Africa than HIV/AIDS. This case study examines strategies used to reduce the incidence of measles in S..

Who says the course of true love never did run smooth : Who says "The course of true love never did run smooth"? Who speaks the line "Lord, what fools these mortals be"?

Logistics activities that the business engages : Identify some of the logistics activities that the business engages in - Explain what metrics should be used to assess how effective the logistics function is that would be important to customers.

User Account

All Pages