Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Download the below power point presentation and answer sheet and determine the appropriate cardinalities for 1 through 8. Each question has 4 cardinalities to determine.

Download the below power point presentation and answer sheet and determine the appropriate cardinalities for 1 through 8. Each question has 4 cardinalities to determine. Two sets of min, max - next to each entity.

Remember, a minimum cardinality can be "0" or "1", with "0" meaning that a row in one table does not need to be related to a row in another table. and a "1" meaning that the a row in one table needs to always be related to a row in the other table.

A maximum cardinality can be "1" or "*" (many) with a "1" meaning that a row in one table can only be related to one row in another table at all times and a "*" means that a row in one table can be related to many rows in another table.

image text in transcribed

image text in transcribed

image text in transcribed

The pictures are not downloadable. They have the information needed for the question. No powerpoint is given

For some items we know more than one vendor. 07 We know at least one vendor per item. Not all vendors participate in the vendor-item relationship. Most vendors participate many times in the vendor-item relationship. Define the cardinalities for the Item-Vendor relationship. Item Vendor Problem #3 Define the cardinalities for the Parent-Child relationship. Parent Child Problem #4 We currently have more than 100 open orders. We accept partial deliveries from Vendors. There is exactly one order for each delivery. Define the cardinalities for the Order-Delivery relationship. Order Delivery (Purchase) Problem #5

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

More Books

Students also viewed these Databases questions

Question

Select suitable tools to analyze service problems.

Answered: 1 week ago