Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1 . Provide the appropriate connectivity using the above business rules for number 1 a . 1 : 1 b . 1 : infty
Provide the appropriate connectivity using the above business rules for number
a:
b:infty
cinfty :
Provide the appropriate connectivity using the above business rules for number
a M:N
b:infty
cinfty :
Provide the appropriate connectivity using the above business rules for number
a:
b:infty
cinfty :
Provide the appropriate connectivity using the above business rules for number
a:
b:infty
cinfty :
Provide the appropriate connectivity using the above business rules for number
a M:N
b:infty
cinfty :
Provide the appropriate connectivity using the above business rules for number
a:
b:infty
cinfty :
Provide the appropriate connectivity using the above business rules for number
a:
b:infty
cinfty :
III. Tech Support
Using Crows Foot Model, provide all appropriate cardinalities using the following business rules:
Each staff is part of one of the five IT Teams Helpdesk Server, Network, Desktop, Email
and a team may have many staff members.
Each user will have the ability to submit as many tickets as needed, and each ticket must be
tied to a single user.
Each ticket is assigned to at least one topic area but no more than three topics per ticket. A
topic can include many tickets.
Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number
aN
b
c
Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number
aN
b
c
Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number
aN
b
c
Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number
aN
b
c
Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number
aN
b
c
Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number
aN
b
c
Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number
aN
b
c
Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number
aN
b
c
IV Traffic Ticket
Using Chen Model with the min max notation, provide all appropriate cardinality using the
following business rules:
A vehicle is owned by one and only driver. A driver owns at least one vehicle.
A law enforcement officer issues many fine tickets and a motorist may have received many
fine tickets.
Using Chen Model with the min max notation, provide the appropriate cardinality using the
above business rules for number
aN
b
cM
dNM
eP
Using Chen Model with the min max notation, provide the appropriate cardinality using the
above business rules for number
aN
b
cM
dNM
eP
Using Chen Model with the min max notation, provide the appropriate cardinality using the
above business rules for number
aN
b
cM
dNM
eP
Using Chen Model with the min max notation, provide the appropriate cardinality using the
above business rules for number
aN
b
cM
dNM
eP
Using Chen Model with the min max notation, provide the appropriate cardinality using the
above business rules for number
aN
b
cM
dNM
eP
V Heath Clinics
Using Crows Foot Model, provide all appropriate connectivities using the following business rules:
A physician works at one and only one clinic location and a clinic has at least one physician
worker.
A physician can prescribe one or more medications to several patients and a patient can
obtain many prescriptions from several physicians.
Using Crow's Foot Model, provide the appropriate connectivity using the above business rules for
number
a
b
c
d
Using Crow's Foot Model, provide the appropriate connectivity using the above business rules for
number
a
b
c
d
Using Crow's Foot Model, provide the appropriate connectivity using the above business rules for
number
a
b
c
d
Using Crow's Foot Model, provide the appropriate connectivity using the above business rules for
number
a
b
c
d
Using Crow's Foot Model, provide the appropriate connectivity using the above business rules for
number
a
b
c
d
VI Lead Management
Using Crows Foot Model, provide the appropriate connectivity using the following business rules:
A property is owned by a single homeowner but a homeowner may have multiple
properties.
A property may be purchased by one single buyer but a buyer can purchase many
properties.
A real estate agent may manage more than on
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