Question: 1 . Provide the appropriate connectivity using the above business rules for number 1 a . 1 : 1 b . 1 : infty

1. Provide the appropriate connectivity using the above business rules for number 1
a.1:1
b.1:\infty
c.\infty :1
2. Provide the appropriate connectivity using the above business rules for number 2
a. M:N
b.1:\infty
c.\infty :1
3. Provide the appropriate connectivity using the above business rules for number 3
a.1:1
b.1:\infty
c.\infty :1
4. Provide the appropriate connectivity using the above business rules for number 4
a.1:1
b.1:\infty
c.\infty :1
5. Provide the appropriate connectivity using the above business rules for number 5
a. M:N
b.1:\infty
c.\infty :1
6. Provide the appropriate connectivity using the above business rules for number 6
a.1:1
b.1:\infty
c.\infty :1
7. Provide the appropriate connectivity using the above business rules for number 7
a.1:1
b.1:\infty
c.\infty :1
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.
1. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number 1
a.(0,N)
b.(1,1)
c.(1,3)
2. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number 2
a.(0,N)
b.(1,1)
c.(1,3)
3. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number 3
a.(0,N)
b.(1,1)
c.(1,3)
4. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number 4
a.(0,N)
b.(1,1)
c.(1,3)
5. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number 5
a.(0,N)
b.(1,1)
c.(1,3)
6. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number 6
a.(0,N)
b.(1,1)
c.(1,3)
7. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number 7
a.(0,N)
b.(1,1)
c.(1,3)
8. Using Crow's Foot Model, provide the appropriate cardinalities using the above business rules for
number 8
a.(0,N)
b.(1,1)
c.(1,3)
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.
1. Using Chen Model with the (min, max) notation, provide the appropriate cardinality using the
above business rules for number 1
a.(0,N)
b.(1,1)
c.(1,M)
d.(N,M)
e.(0,P)
2. Using Chen Model with the (min, max) notation, provide the appropriate cardinality using the
above business rules for number 2
a.(0,N)
b.(1,1)
c.(1,M)
d.(N,M)
e.(0,P)
3. Using Chen Model with the (min, max) notation, provide the appropriate cardinality using the
above business rules for number 3
a.(0,N)
b.(1,1)
c.(1,M)
d.(N,M)
e.(0,P)
4. Using Chen Model with the (min, max) notation, provide the appropriate cardinality using the
above business rules for number 4
a.(0,N)
b.(1,1)
c.(1,M)
d.(N,M)
e.(0,P)
5. Using Chen Model with the (min, max) notation, provide the appropriate cardinality using the
above business rules for number 5
a.(0,N)
b.(1,1)
c.(1,M)
d.(N,M)
e.(0,P)
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.
1. Using Crow's Foot Model, provide the appropriate connectivity using the above business rules for
number 1
a.
b.
c.
d.
2. Using Crow's Foot Model, provide the appropriate connectivity using the above business rules for
number 2
a.
b.
c.
d.
3. Using Crow's Foot Model, provide the appropriate connectivity using the above business rules for
number 3
a.
b.
c.
d.
4. Using Crow's Foot Model, provide the appropriate connectivity using the above business rules for
number 4
a.
b.
c.
d.
5. Using Crow's Foot Model, provide the appropriate connectivity using the above business rules for
number 5
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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!