Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Database Programming With Visual Basic .NET

Authors: Carsten Thomsen

2nd Edition

1590590325, 978-1590590324

More Books

Students also viewed these Databases questions

Question

What is the basis for Security Concerns in Cloud Computing?

Answered: 1 week ago

Question

Describe the three main Cloud Computing Environments.

Answered: 1 week ago