with screenshots !!

Employee Table EmpNo Name E211 Essa Al Nuaimi E467 Noora Al Hosani E199 Talal Al Malageeth E206 Abdulazeez Ahmad E253 Abdulaziz Salem Gender Male Female Department Position ISET Lecturer PET Faculty AEET Lecturer SS Admin SS Supervisor Male Male Male a. Insert Record from the forms (Form 1 and Form 2) and store/save the record in the database. Using SQL commands b. Display Records from the database to a table format. Using SQL commands | Page 10 3. Create a PHP Code that will connect to the database and view the following requirements. a. Display all Students with their information. b. Display all Employees with their information. c. Display the names of all students who live in Dubai d. Display the names of all male students e. Display the names of all Lecturer f. Insert one new record to each table g. Delete from student table the student record with student no.: A13000467 And delete from the employee table the employee record with employee id: E206. Note: Forms in HTML file and Create Database, Create Table, Insert and Display Record in PHP File. Link InsertStudRec.php, DisplayStud Rec.php, InsertEmpRec.php and DisplayEmpRec.php in the command buttons in each form. Lab Exercise: 1. Create the following in myPhpAdmin: a. Database (InfoSystem) b. Table (Studentinfo) i. StudentNo- varchar(15) ii. StudLastName - varchar(30) iii. StudFirstname - varchar(30) iv. Course - varchar(50) v. Emirates - varchar(50) vi. Gender - varchar(6) C. Table (Employee Table) i. EmpNo - varchar (15) ii. EmpLastName -varchar(30) iii. EmpFirstname -varchar(30) iv. Department - varchar(50) v. Position - varchar(50) vi. Gender - varchar(6) 2. Fill the table with the following information: StudentInfo Table StudentNo Name A13000211 Sulaiman Mohamed A13000467 Wadima Khouri A13000199 Yousef Alzaabi A13000206 Ahmad Harsi A13000253 Zayed Katby Course ISET PET AEET Emirates Dubai Ajman Abu Dhabi RAK Sharjah Gender Male Female Male Male EMET ISET Male