A non$-$profit organization operates a number of events to raise money for its continued operation. They keep track of who attended the event and

how much each person donated, if anything. The following is a report created by the organization to keep track of these events. You were hired to

normalize this table and create a more efficient model for the firm to use.

Given the sample of data, select the PK and draw the dependency diagram of the $1$NF$.$ Label the dependencies $($partial$/$transitive$/$other$).$

Starting with the dependency diagram drawn for step $1,$ create a set of dependency diagrams that meet $2NF$ requirements. Label each table resulting from

the transformation from one set of NFs into the next set of the NFs$.$

Starting with the dependency diagram drawn for step $2,$ create a set of dependency diagrams that meet $3NF$ requirements. Label each table resulting from

the transformation from one set of NFs into the next set of the NFs$.$

NOTE: Keep in mind that each normal form is a complete set of tables. Even if a table does not change from one NF to the next, be sure to copy

the table anyway. At each NF level, you should have a set of tables that, if implemented in a database, would allow for storage of the set of

information $($lossless join$)$

Draw an ER diagram based on the final set of $3$NF tables. Include cardinalities on the ERD. Create a relational schema based on the final set of tables.

Draw the decomposition diagram representing your normalization process.