Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Create a data model with 4 entities. Use the data items on the form to specify identifiers and attributes for those entities. Using Crows

1. Create a data model with 4 entities. Use the data items on the form to specify identifiers and attributes for those entities. Using Crows Foot notation show the relationships and cardinality of the relationships. If there is not enough information on the form to determine the cardinality, then make a list of questions you would need to ask the customer to clarify.

For instance, on the form it looks like there can only be one officer writing the ticket. So Max would be one. But can we conclude that one driver could receive more than one ticket?

Submit your ERD with attached notes to this assignment. You can draw it and scan or use MS Visio or another program to create it.

image text in transcribed

I have attached one that i did. you can use as a sample

image text in transcribed

WASHINGTON STATE PATROL CORRECTION NOTICE NAME Kroenke ADORESS 5053 88 Ave SE ay Mecer Island STATE Wa 98040 David M LAST FRST STATE BIRTH DATE HGT WGT EYES War 2/2746 6 1658 VEHICLES UCENSE STATE COLOR EAR TYPE VIN REGISTERED OWNER MOLATION DATE DIST DETACH DAY LOCATION E OrEnumckum on SR410 Writing text while MILES MIOLATIONS OFFICERS SIGNATURE S Scott NUMBER 850 man 1re Conte demces Sch ools School D Plower s Plowes D ast Nane Huht mie him ma C1 state Madiot Nownd Posrhon Yeoe onde WASHINGTON STATE PATROL CORRECTION NOTICE NAME Kroenke ADORESS 5053 88 Ave SE ay Mecer Island STATE Wa 98040 David M LAST FRST STATE BIRTH DATE HGT WGT EYES War 2/2746 6 1658 VEHICLES UCENSE STATE COLOR EAR TYPE VIN REGISTERED OWNER MOLATION DATE DIST DETACH DAY LOCATION E OrEnumckum on SR410 Writing text while MILES MIOLATIONS OFFICERS SIGNATURE S Scott NUMBER 850 man 1re Conte demces Sch ools School D Plower s Plowes D ast Nane Huht mie him ma C1 state Madiot Nownd Posrhon Yeoe onde

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

Advanced Oracle Solaris 11 System Administration

Authors: Bill Calkins

1st Edition

0133007170, 9780133007176

More Books

Students also viewed these Databases questions

Question

2 What are the implications for logistics strategy?

Answered: 1 week ago