| 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/15706840/Lab07/ |
Upload File : |
UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) Name HomeMobilePhoneNumbers studentID MajorCode1 MajorCode2 MajorCode3 Avram Hinton 103-391-7811;676-683-6301 34673656 NSA CSS CST Hayes Gibson 447-149-5334 83681840 CST Kristen Acosta ;972-658-1570 94086534 CP MAD 1NF: 1. There was no primary key 2. Name and Phone number columns had multiple values 3. Majors were stored as repeating data items on the same row I split up the name column into first and last name to create columns with only one value. I also removed the majors and phone numbers from the student table and created four new tables called student_phone, phone_type, major, and student_major to store the values of the removed columns student_phone was created to store the phone numbers of each student phone_type was created to store whether a phone number is a home or a mobile number major was created to store the codes of each major student major was created to store the majors for each student student (studentID*, firstName, lastName) student_phone(studentID*, phoneNumber@) phone_type(phoneNumber*, type) major (MajorCode*) student_major (studentID*, MajorCode*@) 2NF: The only table with a composite key is the student_major table, but it has no non-key fields, passing 2NF 3NF: The tables were created in a way that each value depends only on the primary key of the table, passing 3NF Three data rows: student (studentID* firstName lastName) 34673656 Avram Hinton 83681840 Hayes Gibson 94086534 Kristen Acosta student_phone (studentID* phoneNumber@) 34673656 103-391-7811 34673656 676-683-6301 83681840 447-149-5334 94086534 972-658-1570 phone_type (phoneNumber* type) 103-391-7811 home 676-683-6301 mobile 447-149-5334 home 972-658-1570 mobile major (majorCode*) NSA CSS CST CP MAD student_major (studentID* majorCode*@) 34673656 NSA 34673656 CSS 34673656 CST 83681840 CST 94086534 CP 94086534 MAD