Create traffic ticket database with its associated tables

Assignment Help Operation Management

Reference no: EM132276696

Using Microsoft Access, create the following traffic ticket database with its associated tables, fields (including appropriate data type), primary keys and foreign keys. A traffic ticket is a notice issued by a law enforcement official to a motorist accusing violation of traffic laws.

Note: make sure to create the relationships between your tables before adding the records in your tables. (MS ACCESS)

The motorist information includes driver license number, name, zipcode, state. The motorist is uniquely identified by his/her license number. Create at least 5 unique motorist records.

The traffic offense type includes the offense description (i.e. red light) and its designed fine amount (i.e. $158). Each traffic offense type is uniquely identified by its offense description. Create at least 3 unique traffic offense type records.

The law enforcement official information includes badge number, name, and year in service (i.e. 2). The law enforcement is uniquely identified by his/her badge number. Create at least 3 unique law enforcement official records.

The traffic ticket includes the ticket number, date issued, the motorist’s driver license number, the traffic offense type’s description, and the law enforcement official’s badge number. The traffic ticket is uniquely identified by its ticket number. Create at least 8 traffic ticket records. One motorist may have more than one traffic ticket.

A traffic ticket is issued by a specific law enforcement official to one and only motorist. A law enforcement official can issue many traffic tickets and a motorist can received many traffic tickets.

Create one query named "Invoices" using "Query Design" that outputs the total (aka SUM function) amount of the traffic tickets due and total number (aka COUNT function) of traffic tickets received by each individual motorist's license number. The outputs should also display the name of the motorists.

Do not use "large number" as a data type for any of your fields

Your Submission

Submit your Microsoft Access database (.accdb file).

Reference no: EM132276696

Questions Cloud

Successful business messages are purposeful : Successful business messages are purposeful, audience-centered, and concise.

Identify benefits of and barriers to medical tourism : Identify benefits of and barriers to medical tourism. Reflect on reasons consumers may or may not seek medical care outside of their home country.

Diversity-technology-globalization and economic uncertainty : Diversity, technology, globalization, and economic uncertainty are among key change trends affecting organizations.

The innovation-related internationalisation model : Describe The Innovation-Related Internationalisation Model

Create traffic ticket database with its associated tables : Using Microsoft Access, create the following traffic ticket database with its associated tables, fields primary keys and foreign keys.

Define firm performance : How would you best define firm performance (aka company or organization performance)?

Company annual operating budget : It will drive the formulation of detailed action plans, and these plans will be subsequently linked to the company’s annual operating budget.

Most influence the success of business : What three factors MOST influence the success of a business (list in order of priority and explain)?

Business increase business responsibility for product safety : The complexity of today’s economy and the dependence of consumers on business increase business’s responsibility for product safety

User Account

All Pages