Web program server side Php language

Please follow this guideline when submitting your exam: -submit one zip file including all PHP files with the database file (.sql) - the file should be saved like this FirstName_LastName_id.zip. (Example: Ahmad Masri 5181234 should be saved Ahmad_Masri_5181234.zip) - Make sure to include a file called connection.php to be used each time you access the Database. Question 1 (20 pts) : We need to create a web site for an online health center Create the database center that includes the following tables: Doctor: phone# (int) name (Varchar) specialtyid (int) Foreign key address (Varchar) (1654321, 'Dr. Samir', 5, 'Saida'), (1987654, 'Dr. Jamil ', 5, 'Saida '), (3123456, 'Dr. Al Chami', 8, 'Kesrwan '), (11111111, 'Dr. Majzoub', 4, 'Bekaa'), (61123456, 'Dr.Haddad', 2, 'Jbeil'), (61987654, 'Dr.Haidar', 2, 'Beirut'), (62123456, 'Dr. Abbass', 1, 'Beirut'), (62987654, 'Dr. Nelly', 1, 'Tripoli'), (71123456, 'Dr. Akl', 7, 'Nabatieh'), (701234567, 'Dr. Wassim', 8, 'Akkar'); Speciality spid (int) description (Varchar(30)) Fill few records in the table Specialty SplD Description 1 Allergy & immunology 2 Cardiology 3 Cardiothoracic surgery 4 Dermatology 5 Family Medicine Create an index page called index.php allows user to select his option Welcome to health center Add a doctor Display All doctors Find doctor by city Question 2 (30 pts) : As user selects Add a Doctor, a new page add.php lets user to add a new doctor to the database Add a Doctor Phone #: Name: Address: Specialty: Cardiology Submit Reset As the page is loaded Combo box loads all the data from specialty database table Three text boxes allow user to enter doctor's phone number, address, and his/her name A message should display whether the record is added or not. . Question 3 (20 pts): As user selects Display AllDoctors, a new page display.php will display all doctors list from the database Phone# 1654321 1987654 3123456 11111111 61123456 61987654 Name Dr. Samir Dr. Jamil Dr. Al Chami Dr. Majzoub Dr.Haddad Dr.Haidar Specialty Family Medicine Family Medicine Pediatric Dermatology Cardiology Cardiology Address Saida Saida Kesrwan Bekaa Jbeil Beirut Question 4 (30 pts): Create an AJAX page called find.php to find a doctor by city. The page find.php should call another php file called findcity.php using AJAX