| 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/20245/CST1600/41/15446424/Lab07/ |
Upload File : |
UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) 1NF: Table student violates 1NF as it contains multipul optional values in phone numbers and majorCode should be one column student(Name, homePhone, MobilePhone, StudentID, MajorCode) Example Table: Avram Hinton 103-391-7811 676-683-6301 34673656 NSA Avram Hinton 103-391-7811 676-683-6301 34673656 CSS Avram Hinton 103-391-7811 676-683-6301 34673656 CST Hayes Gibson 447-149-5334 83681840 CST Kristen Acosta 972-658-1570 94086534 CP Kristen Acosta 972-658-1570 94086534 MAD 2NF creates a major table to remove repetitive data and uses studentID as PK studentInfo(StudentID*, Name) Sample Data: StudentID Name homePhone MobilePhone 34673656 Avram Hinton 103-391-7811 676-683-6301 83681840 Hayes Gibson 447-149-5334 94086534 Kristen Acosta 972-658-1570 New Table: majors(majorCode*, majorCode) Sample Data: majorCode_ID majorCode 1 NSA 2 CSS 3 CST 4 CP 5 MAD 3NF: connects the data both pk and fk studentMajor(StudentID*@, MajorCode*@) StudentID MajorCode 34673656 1 34673656 2 34673656 3 83681840 3 94086534 4 94086534 5 Three data rows: Sample Data: StudentID Name homePhone MobilePhone 34673656 Avram Hinton 103-391-7811 676-683-6301 83681840 Hayes Gibson 447-149-5334 94086534 Kristen Acosta 972-658-1570 New Table: majors(majorCode*, majorCode) Sample Data: majorCode_ID majorCode 1 NSA 2 CSS 3 CST 4 CP 5 MAD studentMajor(StudentID*@, MajorCode*@) StudentID MajorCode 34673656 1 34673656 2 34673656 3 83681840 3 94086534 4 94086534 5