Normal $-$ completely normalize the "fairy tale elections"Create both the data tables required AND a data dependency diagram in $3$NF$.$ The normal level will adequately prepare you for the following assignments.

Submit your Data Dependency Diagram as a PDF$.$ Your data dependency diagram should look like this:

Pay attention to detail. You should specify PK in a clearly visible way. You should insure that there are no transitive and partial dependencies. You should specify table names clearly. Your work should look neat and professional. Also, watch out for those pesky transitive dependencies! Transitive dependencies are dependent on something that is NOT a PK$.$ You may need to make some new keys.

Submit the tables as an excel file $(.$xlsx$).$ Include a minimum of $10$ row of data in each table $($when you start, you'll reduce this as you normalize$)$ Watch out for repeating data! If you have data repeating, you probably have not achieved $3$NF$.$

Recommendations:

$1)$ Add data first $-$ you need to start by having $10$ rows of data. I got you started with some data. Feel free to change the fandom if you want! Any fun, imaginary elections you enjoy are fine.

$2)$ Work sequentially. Start by getting to $1$NF$,$ then $2$NF$,$ don't try to do it all at once. Your goal is $3$NF$.$

$3)$ You will remove data as you go $-$ for example, you may only end up with three parties $($unless$,$ of course, you add Wizards or Hobbits as parties$).$ That is fine, but you should start with $10$ rows of data to give you some interesting data.

You should submit two files:

Your DDD as a PDF

Your tables as excel spreadsheets $(.$xlsx$)$