Question: Please help to answer all question, they are all related Please help to answer all question, they are all related (Given the following tables) students
Please help to answer all question, they are all related


Please help to answer all question, they are all related
(Given the following tables) students id matrixnum name tel num 1 S00001 Atit 012122222 2 S00002 Abd Razak 016788900 assesments Id matrixnum subject_code quiz assignment project total_marks grade 1 S00001 MMS3013 80 90 80 83.3 A 2 S00002 MTD3013 50 80 90 73.3 B + formula total_marks = (quiz + assignment project3 subjects id subject_codesub_name cred 1 MMS3013 3 Web Programming 2 MTD3013 Database 3 Table: Grading Marks Grade 80 - 100 A 70 - 79 60-69 50 - 59 D 0 - 49 E PART B: PHP i Build a file to link to your database and give it the file name config php (1 markah/ mark) i 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. (4 markah/marks) . 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) (7 markah/marks) iv. Assume that the following program section (Program Code 1) are variables that receives input from the user via a form Build program code to provide instructions for entering the data into the assessments table. In addition, next build a link to view the data that has been entered (4 markah/marks)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
