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/11365835/Lab07/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/uploads/20255/CST1600/41/11365835/Lab07/CST1600_CassandraHuberty_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:
Student
Student_ID*      Name               Home_Phone_Number     Mobile_Phone_Number     Major_Code*
34673656         Avram Hinton       103-391-7811          676-683-6301            NSA, CSS, CST     
83681840         Hayes Gibson       447-149-5334 		                  CST
94086534         Kristen Acosta     			  972-658-1570            CP, MAD

Table Changes: Separated phone numbers by home phone and mobile phone, and consolidated major codes into one field.


2NF:
Student
Student_ID*      Name                 Home_Phone_Number     Mobile_Phone_Number
34673656         Avram Hinton         103-391-7811          676-683-6301                  
83681840         Hayes Gibson         447-149-5334 		              
94086534         Kristen Acosta     			    972-658-1570         

Student_Major
Student ID*      Major_Code*
34673656         NSA
34673656	 CSS
34673656         CST
83681840         CST
94086534         CP
94086534         MAD

Table Changes: Created separate table for student major information.


3NF:
Student
Student_ID*      First_Name         Last_Name         Home_Phone_Number     Mobile_Phone_Number
34673656         Avram              Hinton            103-391-7811          676-683-6301                  
83681840         Hayes              Gibson            447-149-5334 		              
94086534         Kristen            Acosta     			            972-658-1570         

Student_Major
Student_ID*      Major_Code*
34673656         NSA
34673656	 CSS
34673656         CST
83681840         CST
94086534         CP
94086534         MAD

Table Changes: Separated first and last name into different fields.



Three data rows:
Student
Student_ID*      First_Name         Last_Name         HomePhoneNumber     MobilePhoneNumber
34673656         Avram              Hinton            103-391-7811        676-683-6301                  
83681840         Hayes              Gibson            447-149-5334 		              
94086534         Kristen            Acosta     			          972-658-1570         

Student_Major
Student ID*      Major_Code*
34673656         NSA
34673656	 CSS
34673656         CST
83681840         CST
94086534         CP
94086534         MAD

Anon7 - 2022
AnonSec Team