PHPAccording to table the in the image (Build a file to link to your database and give it the file name config.php) (Build a file to display matrixnum, name from students table, subject_code and sub_name from subjects table and total_marks, grade from assessment table.) Build code using javascript, to calculate total_marks and determine grade. Where total_marks are calculated by adding quiz, assignment and project and divided by 3. Where the value range of each quiz, assignment and project is 0 to 100. Next the grade will be determined based on the grading system (refer to the grading table) (Given the following tables)studentsidmatrixnumtel_numnameSo0001Afif012122222So0002Abd Razak016788900assesmentsidmatrixnumsubject_code quizassignment project total_marks grade1S00001MMS301380908083.3AS00002MTD301350809073.3B** formulatotal_marks = (quiz + assignment + project)/3subjectsidsubject_code sub_namecredit1MMS3013Web3ProgrammingDatabase32MTD3013Table: GradingMarksGrade80 - 100A70 - 79B60 - 69C50 - 59D0- 49E

MySQL Query: SELECT s.matrixnum, s.name, a.total_marks, a.grade FROM students AS s INNER JOIN…

Answered: PHP According to table the in the…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

PHP

According to table the in the image

(Build a file to display matrixnum, name from students table, subject_code and sub_name from subjects table and total_marks, grade from assessment table.)

Build code using javascript, to calculate total_marks and determine grade. Where total_marks are calculated by adding quiz, assignment and project and divided by 3. Where the value range of each quiz, assignment and project is 0 to 100. Next the grade will be determined based on the grading system (refer to the grading table)