unf

Put the above database into UNF, 1NF, 2NF, and 3NF using the notation taught in Week 4’s lecture. Place repeating groups inside of the following brackets: “{“ and “}”. Place tables inside the following brackets: “[“ and “]”. Do not use character values as part of the primary key. Name tables if there is more than one. Underline the attributes comprising the primary key for each table. Finally, designate foreign keys for 3NF.