| 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/16318726/Lab07/ |
Upload File : |
UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) 1NF: Note: HomeMobilePhoneNumbers and Name fields have more than one value and there is no primary key. 1) I first named the primary key of student as StudentID* because everything has a reliance on the StudentID*@. Then I created a table called phone which includes a primary key of Phone*. Finally I added one more table called studentPhone with two foreign keys called StudentID*@ and Phone*@ to replace the HomeMobilePhoneNumbers so it would not repeat two phone numbers in the row. 2) I first renamed and replaced the field Name as two different fields named firstName and lastName so there is only one value instead of two. I also removed the HomeMobilePhoneNumbers as I replaced it with the tables phone and studentPhone. student(StudentID*, firstName, lastName, MajorCode1, MajorCode2, MajorCode3) phone(Phone*, phoneType) studentPhone(StudentID*@, Phone*@) 2NF: Note: MajorCodes 1, 2, and 3 rely soley on studentID* and you are limited to only 3 major codes. 1) I will create a table called major with the primary key of Major*. Also, I created the table studentMajor with the foreign keys StudentID*@, and Major*@ to replace the repeats of MajorCodes. 2) I will only remove the MajorCode columns as they are not needed anymore in the student table. student(StudentID*, firstName, lastName) phone(Phone*, phoneType) studentPhone(StudentID*@, Phone*@) major(Major*) studentMajor(StudentID*@, Major*@) 3NF: Note: Passes due to the attributes of the database being functionally dependent on StudentID* primary key. OK Three data rows: student(StudentID*, firstName, lastName) 34673656 Avram Hinton 83681840 Hayes Gibson 94086534 Kristen Acosta phone(Phone*, phoneType) 103-391-7811 Home 676-683-6301 Mobile 447-149-5334 Home 972-658-1570 Mobile studentPhone(StudentID*, Phone*@) 34673656 103-391-7811 34673656 676-683-6301 83681840 447-149-5334 94086534 972-658-1570 major(Major*) NSA CSS CST CP MAD studentMajor(StudentID*@, Major*@) 34673656 NSA 34673656 CSS 34673656 CST 83681840 CST 94086534 CP 94086534 MAD