| 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/00193071/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) 1NF: Made a student table with the students limited info but made a First and Last name column. "possiblepoints" table lists the labs and their points possible for each. "lettergrade" table lists out the percentages and their grade letter. "studentgrade" links "student" to "possiblepoints" by (studentID*) and (labNumber*) and lists the score they recieved with (studentLabScore). student (studentID*, studentFirstName, studentLastName) possiblepoints (labNumber*, labPoints) lettergrade (letterGrade*, letterPercentage) studentgrades (studentID*@, labNumber*@, studentLabScore) 2NF: OK 3NF: OK Three data rows: student (studentID*, studentFirstName, studentLastName) 84228748 Lael Abbott 44107438 Bruce Acosta 21479092 Coby Fox possiblepoints (labNumber*, labPoints) SP 5 Lab01 10 Lab02 5 Lab03 10 Lab04 10 Lab05 15 Lab06 10 Lab07 15 Lab08 15 Lab09 15 lettergrade (letterGrade*, letterPercentage) A 93 A- 90 B+ 87 B 83 B- 80 C+ 77 C 73 C- 70 F 0 studentgrades (studentID*@, labNumber*@, studentLabScore) 84228748 sp 4 84228748 lab01 10 84228748 lab02 5 84228748 lab03 9 84228748 lab04 ns 84228748 lab05 3 84228748 lab06 10 84228748 lab07 ns 84228748 lab08 ns 84228748 lab09 ns 44107438 sp 5 44107438 lab01 10 44107438 lab02 5 44107438 lab03 10 44107438 lab04 10 44107438 lab05 15 44107438 lab06 10 44107438 lab07 15 44107438 lab08 15 44107438 lab09 ns 21479092 sp 5 21479092 lab01 10 21479092 lab02 5 21479092 lab03 10 21479092 lab04 10 21479092 lab05 15 21479092 lab06 10 21479092 lab07 ng 21479092 lab08 ns 21479092 lab09 ns