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.
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. Purchase Cash Disbursement Protem #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) Define the cardinalities for the Item Type-Sale relationship. Sale Item Type (Stuffed Animal) Quantity on hand Name Invoice # Amount Date Problem #7 Description . 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. Fixed Asset Depreciation 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. Purchase Cash Disbursement Protem #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) Define the cardinalities for the Item Type-Sale relationship. Sale Item Type (Stuffed Animal) Quantity on hand Name Invoice # Amount Date Problem #7 Description . 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. Fixed Asset Depreciation Problem #8
