Question

Relational Model Given a table below Donation Records DonationID Donation Date DonationDesc 5100 7/5/17 Cash donation 5105 7/8/17 Cash donation 5110 7/13/17 Cash donation 5115 7/13/17 Clothing 5120 7/15/17 Shoes 5123 7/17/17 Cash donation 5126 8/3/17 Pots and pans 5129 8/5/17 Grandfather clock 5132 8/7/17 Dining room furniture 5135 8/11/17 Towels Donation Value CashDonation PatronID AuctionItem 50 Yes 3022 No 25 Yes 3035 No 25 Yes 3044 No 125 No 3044 No 100 No 3006 75 Yes 3041 No 50 No 3014 No 500 No 3003 Yes 250 No 3028 Yes 50 No 3033 No No (a) (b) (c) (d) (e) What is the name of the relation? What is the degree of the relation? What is the cardinality of the relation? What is the domain for the attribute "CashDonation"? What is the primary key of the relation?

Answer 1

a) Name of relation :DonationRecords

b) Degree of relation (number of attributes) = 7

c) Cardinality of the relation (number of tuples) = 10.

d) Domain for the attribute "CashDonation" is Yes or No.

e) DonationID is the primary key of the relation.