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 Please helpto answer all question, they are all related (Given the following tables)

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!