| 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/20253/CST1600/41/16750839/Lab07/ |
Upload File : |
#Note: Primary key: (*) Foreign Key: (@) UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) 1NF: Note: I could have just made it into the seperate columns, but I went a step further and made it into different tables. The StudentID is what connects all of them, as they all depend on a different StudentID. I also Combined the 3 different MajorCodes into just one MajorCode subject. I did this to save space and reduce nulls in the table. I also split the HomePhone and Mobile Phone numbers into to two. This way there's only one answer in each abstract.This way the StudentID can dig up the phone numbers separately. student(StudentID*, Name) contacts(StudentID*@, HomePhoneNumber, MobilePhoneNumber) studet_major(StudentID*@, MajorCode) 2NF: Note: There is no partial dependency in the 1NF. It passes the 2NF check as well. OK 3NF: Note:The tables in 1NF could technically work for 3NF as well, however; I made an change to make a separate table for MajorCode. This will help in the long run if anything new would rely on MajorCode (like a major name or maybe instructor). I figured this would help clarify the database and would eliminate transitive dependencies that might appear. student(StudentID*, Name) contacts(StudentID*@, HomePhoneNumber, MobilePhoneNumber) major(MajorCode*) student_major(StudentID*@, MajorCode*@) Three data rows: student(StudentID*, Name) 34673656, Avram Hinton 83681840, Hayes Gibson 94086534, Kristen Acosta contacts(StudentID*@, HomePhoneNumber, MobilePhoneNumber) 34673656, 103-391-7811, 676-683-6301 83681840, 447-149-5334, null 94086534, 972-658-1570, null major(MajorCode*) NSA CSS CST CP MAD student_major(StudentID*@, MajorCode*@) 34673656, NSA 34673656, CSS 34673656, CST 83681840, CST 94086534, CP 94086534, MAD