Requirements (please save the answer to each question in a separate file). Part-A: TRIGGERS Q1. The “doctorID” column in the DOCTORS table needs to be generated automatically. Each ID is sequentially numbered for a new tuple being added to the table. Notes: a) The IDs take up the full column width. b) The ID must begin with the prefix letter: D c) The doctorID value generated by the trigger s
Requirements (please save the answer to each question in a separate file). Part-A: TRIGGERS Q1. The “doctorID” column in the DOCTORS table needs to…