A consulting company named Database Experts has also designed a logical schema for CPC. CPC found that their design is different from yours. There is the following table in their logical schema.
Donation (Donator#, Program#, Date, Amount, Title, Theme, Deadline)
The requirements of CPC also indicate that there are the following Functional Dependencies:
Donator#, Program# -> Date, Amount
Program# -> Title, Theme, Deadline
Theme -> Deadline
Although the designers at Database Experts claim that their design is superior in all aspects, CPC gives you a fair chance to justify your position. Now it's your time to do the following.
1). Find the primary key for the table DONATION (You have to show the process) (10 points)
2). Determine which normal form the DONATION table is in. Explain why.
3). Decompose their table into 3NF tables. Specify primary keys and foreign keys of your tables. (You need to show the process)