Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The City of Lethbridge needs a database for their new Citizens-on-Patrol (COP) program. The COP program will be responsible for patrolling different regions of the

image text in transcribed
The City of Lethbridge needs a database for their new Citizens-on-Patrol (COP) program. The COP program will be responsible for patrolling different regions of the city. A region has a unique number, a population, an area size and a boundary description. Each region will have several time blocks scheduled for patrolling. Each time block has a date, start time and end time. Note that each region has several time blocks a day, and that several region may be patrolled at the same time. COP will utilize the services of several people. Each person has a unique ID, name, address, phone# and date of birth. People are classified into police officers and citizens. A police officer will be paid an honourarium for their time on this program, which is tracked, and oversees activities for several time blocks. A citizen has a number of hours volunteered, and a crew leader designation (i.e. yeso). Each citizen is placed in one squad. A squad has a unique identifier, and signs up for one or more time blocks, not necessarily in the same region. It should be noted that several squads may sign up for the same time block, which means that several officers may be needed to oversee for the same time block. a) Identify all entity sets, attributes and relationship sets from the above description. b) Using the information from a), draw an Extended entity-relationship diagram using the entity sets, relationship sets, and attributes from part a). Mark primary keys and relationship cardinalities as appropriate. State any assumptions you make

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

Modern Database Management

Authors: Jeffrey A. Hoffer Fred R. McFadden

9th Edition

B01JXPZ7AK, 9780805360479

More Books

Students also viewed these Databases questions

Question

An unsafe state is a deadlocked state.

Answered: 1 week ago