UUS Lao Answer Doc IN G 2/3 87.19 Consider the following tables DOCTOR DocID 101 102 103 First Name Muhammad Maryam Sumayyah Last Name Fateh Mazlan Idris Specialization Surgery Neurology Dermatology HireDate 15/05/2000 21/03/2001 07/02/2003 PATIENT PatientID 111 222 333 FirstName Khai Haqiem Siti Nurhaliza LastName Bahar Rusli Taruddin DocID 101 102 101 The tables show the data for PATIENT and DOCTOR. Each patient will be treated by only one doctor and each doctor will treat many patients. Answer the following questions, a) Create table for PATIENT with these constraints PatientID is a primary key and unique DocID is the foreign key which referring to DocID in DOCTOR table Patient ID cannot be mull (5 marks) b) Admin wants to insert a new doctor named Ali bin Abu (DocID = 101). State its possibility of the insertion according to entity integrity constraint rules. (2 marks) c) Find the list of doctors who start working between 2000 until 2019 and his/her specialization is surgery (3 marks) Type here to search cuer