(Solved): INSTRUCTIONS: Normalize the following table to Third Normal Form (3NF) CustomerID CustomerName Broke ...

INSTRUCTIONS: Normalize the following table to Third Normal Form (3NF) CustomerID CustomerName BrokerID BrokerName Gerard Mills 1006 Jane Golding 8791 2001 3392 COMM 335- Exercise on Data Normalization Carl Tate Shannon Lee 9654 Alice Chan 8923 Lisa Weitz SecID SecName SecType NumShares 875600 Allegiance 431001 Apple Fund 237 Stock 500 Stock 788 Stock 82 Stock 530 Stock Fund 438911 Citibank 431001 Apple 430925 Oracle 438390 IBM 875600 Allegiance REQUIREMENTS: For each normal form: 1NF, 2NF and 3NF Show the outline notation for tables, using this format: TABLE (PrimaryKey, ForeignKey, Nonkey) PrimaryKey underlined ForeignKey italic NonKey normal Show the functional dependencies, using this format: PrimaryKey ? NonKey 120 387