| 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 : /nginx/html/uploads/20243/CST1600/41/16290651/Lab07/ |
Upload File : |
* (asterisk) to denote a primary key field. @ (at sign) to denote a foreign key field. ^ (caret) to denote a unique field that is not a primary key. UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) 1NF: No student(studentID*, FirstName, LastName, HomePhone, MobilePhone) PhoneNumbers(studentID*@, PhoneNumber*, Type) Major(MajorCode*) StudentToMajor(studentID*@, MajorCode*@) 2NF:OK 3NF:OK Three data rows:student: student(studentID*, FirstName, LastName) 34673656, Avram, Hinton 83681840, Hayes, Gibson 94086534, Kristen Acosta PhoneNumbers(studentID*@, PhoneNumber*, Type) 34673656, 103-391-7811, Home 34673656, 676-683-6301, Mobile 83681840, 447-149-5334, Home 94086534, 972-658-1570, Mobile Major(MajorCode*) NSA CSS CST CP MAD StudentToMajor(studentID*@, MajorCode*@) 34673656, NSA 34673656, CSS 34673656, CST 83681840, CST 94086534, CP 94086534, MAD