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.

Max is either 1 or (many) Participation Cardinalities Entity "A" participates in "A" participates in ationship "rel" at a minimum of s" times (optional) time (mandatory) "I" time (single time only) "time (many times) - 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. Problem \#5 Define the cardinalities for the Parent-Child relationship. - Most people possess a passport; i.e. some people (instances of the person entity) do not participate in the relationship with passport. - A person possesses at most one passport; i.e. an instance of person can't participate more than once in the person-passport relationship. - Each passport is owned by one person; i.e. a passport must participate in the passport-person relationship and a passport participates only once in the passport-person relationship. Define the cardinalities for the Person-Passport relationship. Problem \#2 - For some items we know more than one vendor. - 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. Problem \#3 - Depreciation represents the decline in economic potential of limited life assets originating from wear and tear, natural deterioration through interaction of the elements, and technical obsolescence. - Depreciation entries spread the original cost over the estimated life of the fixed assets such as plant and equipment. - We record exactly one depreciation entry for each fixed asset per period (at the end of the period). - We record information about a fixed asset at the time it is acquired. - A depreciation entry always applies to a fixed asset (exactly one). Define the cardinalities for the Fixed Asset-Depreciation relationship. Problem \#8 We pay (cash disbursement) a vendor for all purchase transactions that occur during the month at the end of the month with one check. We also pay (cash disbursement) our employees at the end of the month. > Define the cardinalities for the Purchase-Cash Disbursement relationship. Problem \#6 - Monica S. Eles owns a "Stuffed Animals" store in downtown Lansing. - Her business is going extremely well since she started (last year) selling exclusive items such as 'Seven Dwarfs' Limited Edition, the 'Aristocats' Diamond Series, the ultimate 'Tin Tin' collection, etc. - Currently, Monica has 486 different types of stuffed animals, such as: Sleepy-small, Sleepy-big, Garfield-yellow, Garfield-gold, etc. - For each item type she records name, description and quantity on hand. - She has two item types in stock (Tin Tin small and Obelix big) nobody seems to be interested in. - She sells stuffed animals exclusively. - Yesterday, she sold 3 Sleepy-small and 4 Garfield-gold to a customer (one invoice)