Reference no: EM131636593

Question: A corporation sponsors a yearly campaign to solicit monetary contributions from its employees for a local charity, and the company decides to use a database to keep track of the data. Employee data already include employee ID, first name, last name, and department. Employees sign a contribution pledge on a particular date, that specifies the total amount they wish to donate and the number of equal biweekly payroll deductions (starting with the next pay period) they want to use to pay off the total. The payroll department needs to know details about each payment, including the contribution pledge the payment is for, the payment date and the amount deducted. An employee can make multiple pledges.

a. Do you agree that the following "data decomposition" is consistent with the enterprise description? If not, what should be added or what should be removed?

b. Identify a primary key for each of the Employee, Contribution, and Payment entities and explain your choice.