Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose I need to model a bank which provides loans to different companies. Further suppose that the only companies in my data model are those

Suppose I need to model a bank which provides loans to different companies. Further suppose that the only companies in my data model are those to whom I am providing loans or have provided loans in the past.

What is the appropriate minimum cardinality for the relationship between LOAN and COMPANY?

Suppose I need to model a credit card company where each customer can receive up to one credit card and each card can be sent to only one address.

What is the appropriate maximum cardinality for the relationship between CUSTOMER and CARD?

Suppose I need to model a university where students can, but do not have to, participate in extra-curricular activities. Each such activity can have zero or more participants.

What is the appropriate minimum cardinality for the relationship between STUDENT and ACTIVITY?

Suppose I need to model a university where students can have up to three majors (i.e., can be part of three departments).

What is the appropriate maximum cardinality for the relationship between STUDENT and DEPARTMENT?

Suppose I need to model a hardware store with varying inventory. That is, not all products will be sold at any given time.

What is the appropriate minimum cardinality for the relationship between STORE and PRODUCT?

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

Management Accounting

Authors: Pauline Weetman

2nd Edition

0273718452, 978-0273718451

More Books

Students also viewed these Accounting questions

Question

What is the purpose of a costbenefit analysis?

Answered: 1 week ago