Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

B . You just landed a new job as a database architect for Comet County. For your first assignment, your manager has sent you over

B. You just landed a new job as a database architect for Comet County. For your first assignment, your manager has sent you over to the County Sheriffs Traffic Division to address their concerns around the effective organization of their traffic notice (= a traffic ticket) data. Comet is a small county and, up until now, theyve been able to record traffic notice data in Excel with only a few mishaps related to data integrity. Now that the county is growing, they need a better way of storing and retrieving this data. The Traffic Division Chief handed you a copy of the paper notice (see page 4, below) they use in the field so you can see the data values they want to capture. Along with a copy of the paper notice, she also explained to you the following:
A notice can be written up for only one vehicle but a vehicle, over time, can accumulate multiple notices or no notices
A location can be associated with no notices or many notices but the incident that gave rise to a particular notice can happen at only one location
A notice can have zero or many violations associated with it. But, a particular violation is associated with exactly one notice.
A notice is issued to exactly one driver but a particular driver, over time, can receive multiple notices or not receive any
Do the following:
Draw a Crows Foot ERD, using proper symbols, for the above scenario. Identify all entities and relationships, based on the traffic notice form data. Note that the categories shown on the notice itself will be helpful in starting to identify themes but should not be the only basis you use. Follow all relevant page 1 guidelines.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basics Of Financial Accounting An Easy Approach To Your Business Expenses And Revenue

Authors: Anayat Ur Rehman

1st Edition

B0BTKNP2XG, 979-8375416724

More Books

Students also viewed these Accounting questions