Answered step by step
Verified Expert Solution
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 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 guidelines.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started