| 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/16267537/Lab07/ |
Upload File : |
1NF Table (Student): studentID* | Name | MajorCode1^ | MajorCode2^ | MajorCode3^ | PhoneNumber ------------|------------------|------------|------------|------------|-------------------- 34673656 | Avram Hinton | NSA | CSS | CST | 103-391-7811;676-683-6301 83681840 | Hayes Gibson | CST | | | 447-149-5334 94086534 | Kristen Acosta | CP | MAD | | ;972-658-1570 96299266 | Colette Gibson | NSA | CSS | | 447-149-5334 49622000 | Kylee Pugh | CSS | | | 168-554-8071;362-673-1296 12755860 | Nissim Moreno | MAD | WP | ; 831-774-5128;676-683-6301 84228748 | Lael Abbott | CST | | ;733-772-2949;298-846-3570 40208573 | Ethan Gomez | CP | WP | ;484-285-4061;344-277-7057 99496218 | Jena Sosa | CST | | ;814-888-1642;895-585-6779 21479092 | John Smith | CST | | ;860-521-5683;418-765-5461 25357066 | Amos McCarthy | CST | NSA | ;435-975-9981;721-269-1301 98159249 | Caleb Madden | CSS | CP | ;943-541-5201 83312932 | Xerxes Hayes | WP | CP | ;877-544-4230; 42683650 | Mira Gentry | MAD | WP | CP ; ;461-854-5007 55593577 | Harper Mcmahon | NSA | CSS ;267-222-8035;530-888-7381 44107438 | Bruce Maxwell | CP ;465-255-0860;217-387-8653 32388303 | John Smith ;CSS ;945-553-7908 53068679 | Montana Dickson ;MAD ;491-349-5614 31441510 | Hayden Mcintyre ;CST ;277-380-2418;785-939-8667 78171647 | Hayes Knapp ;WP ;779-778-5915;754-114-8609 22255753 | Lucy Merritt ;NSA ;294-399-5728 15665209 | Dorian Morris ;WP ;780-424-6179;149-150-0084 10063618 | Halee Bryan ;WP ;454-713-2195;622-825-8598 46483879 | Craig Warner ;CST ;302-746-8454;147-544-8901 52300353 | Lev Albert ;WP ;620-799-3350 2NF Tables (Student, Majors, StudentPhones): Student Table (Student): studentID* | Name ------------|------------- 34673656 | Avram Hinton 83681840 | Hayes Gibson 94086534 | Kristen Acosta ... (and so on) Majors Table (Majors): MajorCode* | MajorName ------------|----------- NSA | NSA CSS | CSS CST | CST CP | CP MAD | MAD WP | WP StudentPhones Table (StudentPhones): studentID* | PhoneNumber | PhoneType ------------|----------------------|----------- 34673656 | 103-391-7811 | Home 34673656 | 676-683-6301 | Mobile 83681840 | 447-149-5334 | Home ... (and so on for other phone numbers) 3NF Tables (Student, Majors, StudentMajors, StudentPhones): Student Table (Student): studentID* | Name ------------|------------- 34673656 | Avram Hinton 83681840 | Hayes Gibson 94086534 | Kristen Acosta ... (and so on) Majors Table (Majors): MajorCode* | MajorName ------------|----------- NSA | NSA CSS | CSS CST | CST CP | CP MAD | MAD WP | WP StudentMajors Table (StudentMajors): studentID* | MajorCode* ------------|----------- 34673656 | NSA 34673656 | CSS 34673656 | CST ... (and so on for other student-major relationships) StudentPhones Table (StudentPhones): studentID* | PhoneNumber | PhoneType ------------|----------------------|----------- 34673656 | 103-391-7811 | Home 34673656 | 676-683-6301 | Mobile 83681840 | 447-149-5334 | Home ... (and so on for other phone numbers) These tables are now in 1NF, 2NF, and 3NF, with relationships established through primary and foreign keys.