Question: Question No 3 15 Create a database having three tables department, Program and session with given fields and create a form given below, make sure


Question No 3 15 Create a database having three tables department, Program and session with given fields and create a form given below, make sure data all are fetched through database and in program field form data should be retrieved on the basis of department selection and then session field data should be retrieved on the basis of program. For question solving use JQuery, PHP and SQL. Department: dep_id, dep_name Program: prog_id , dep_id, program_name Session: session_id, prog_id, session DEPARTMENT Data from table department SELECT DEPARTMENT PROGRAM Data from program table but basis on department value SELECT PROGRAM SESSION SELECT SESSION Data from session table but basis on program value Question No 3 15 Create a database having three tables department, Program and session with given fields and create a form given below, make sure data all are fetched through database and in program field form data should be retrieved on the basis of department selection and then session field data should be retrieved on the basis of program. For question solving use JQuery, PHP and SQL. Department: dep_id, dep_name Program: prog_id , dep_id, program_name Session: session_id, prog_id, session DEPARTMENT Data from table department SELECT DEPARTMENT PROGRAM Data from program table but basis on department value SELECT PROGRAM SESSION SELECT SESSION Data from session table but basis on program value
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
