holowczak 1NF: STOCKS (Company, Symbol*, Headquarters, Date*, Close_Price) Company Symbol Headquarters Date Close Price Microsoft MSFT Redmond, WA 09/07/2013 23.96 Microsoft MSFT Redmond, WA 09/08/2013 23.93 Microsoft MSFT Redmond, WA 09/09/2013 24.01 Oracle ORCL Redwood Shores, CA 09/07/2013 24.27 Oracle ORCL Redwood Shores, CA 09/08/2013 24.14 Oracle ORCL Redwood Shores, CA 09/09/2013 24.33 2NF: COMPANY (Company, Symbol*, Headquarters) STOCKS (Symbol*@, Date*, Close_Price) company: Company Symbol Headquarters Microsoft MSFT Redmond, WA Oracle ORCL Redwood Shores, CA stock_prices: Symbol Date Close Price MSFT 09/07/2013 23.96 MSFT 09/08/2013 23.93 MSFT 09/09/2013 24.01 ORCL 09/07/2013 24.27 ORCL 09/08/2013 24.14 ORCL 09/09/2013 24.33 3NF: I am not sure this needs to be done. There is a case to be make that HQ can be left to relate directly to the company and remain in the COMPANY table. COMPANY (Company, Symbol*) HQ (Company*@, Headquarters) STOCKS (Symbol*@, Date*, Close_Price) company: Company Symbol Microsoft MSFT Oracle ORCL hq: Company Headquarters Microsoft Redmond, WA Oracle Redwood Shores, CA stock_prices: Symbol Date Close Price MSFT 09/07/2013 23.96 MSFT 09/08/2013 23.93 MSFT 09/09/2013 24.01 ORCL 09/07/2013 24.27 ORCL 09/08/2013 24.14 ORCL 09/09/2013 24.33 BCNF: FundID InvestmentType Manager 99 Common Stock Smith 99 Municipal Bonds Jones 33 Common Stock Green 22 Growth Stocks Brown 11 Common Stock Smith Site result FUNDS (FundID*, InvestmentType*@, Manager*@) INVESTMENTS (InvestmentType*) MANAGERS (Manager*, InvestmentType) My result FUNDS (FundID*) INVESTMENTS (InvestmentType*) MANAGERS (Manager*) by fund FUND_MANAGERS (FundID*@, Manager*@) FUND_INVESTMENT (FundID*, InvestmentType*@) or by investment FUND_MANAGERS (FundID*@, Manager*@) MANAGER_INVESTMENT (Manager*, InvestmentType*@)