Above 5 steps are very important for normalizing any table and are necessary steps in your assignments. 1. Given the following table that is used by a small investment firm to keep track of stock transactions (buy/selI) for clients Transaction (StockSymbol, StockName, Trans-Date, Trans-time, Number_of_Shares, Transaction_type, Share-Price, AccountNo, ClientName, ClientEmail) Note: A clients of the investment firm may have multiple accounts. But each account only associates with one client. An account holds multiple stocks. On a trading day, a client can buy or sell (transaction type) shares of any number of stocks in his/her accounts. The system creates a transactionNumber for each transaction (but/sell). A client can only do one transaction within one account at a time. Each transcation only involves one stock trading (buy or sell). Transactions from different clients may happen at the same time. 11. List all FDs 12 What is the KEY of Transaction table? 13. What normal form this table is in? (Note, only if you have all FDs and know the key/candidate key, you can then answer this question). 14 Why this is an ill-designed table. Describe one anomaly (insert, delete or update anomaly). 15 How many THEMES are in this table and what are they? 16. Normalize this table, show the result of normalization. Note. The resulting tables must have KEY and FK so that the information carried in original table is kept by the resulting tables. Above 5 steps are very important for normalizing any table and are necessary steps in your assignments. 1. Given the following table that is used by a small investment firm to keep track of stock transactions (buy/selI) for clients Transaction (StockSymbol, StockName, Trans-Date, Trans-time, Number_of_Shares, Transaction_type, Share-Price, AccountNo, ClientName, ClientEmail) Note: A clients of the investment firm may have multiple accounts. But each account only associates with one client. An account holds multiple stocks. On a trading day, a client can buy or sell (transaction type) shares of any number of stocks in his/her accounts. The system creates a transactionNumber for each transaction (but/sell). A client can only do one transaction within one account at a time. Each transcation only involves one stock trading (buy or sell). Transactions from different clients may happen at the same time. 11. List all FDs 12 What is the KEY of Transaction table? 13. What normal form this table is in? (Note, only if you have all FDs and know the key/candidate key, you can then answer this question). 14 Why this is an ill-designed table. Describe one anomaly (insert, delete or update anomaly). 15 How many THEMES are in this table and what are they? 16. Normalize this table, show the result of normalization. Note. The resulting tables must have KEY and FK so that the information carried in original table is kept by the resulting tables