Question
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.
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 #5Step 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