explain how to do this question inrun sql command line (oracle database)Hospital DatabaseDoctor

 (Doc_ID, Doc_Name, Gender, DOB, Specialist, Qualification, Contact,Address, Dept_No)Department (Dept_No, Dept_Name, Room_No, Floor, HOD, Estd_Date)Staff (Staff_ID, Staff_Name, Category(nurse, lab technician, cashier, security),Designation, DOB, Contact, Address, Dept_No)Patient (Pat_ID, Pat_Name, DOB, Gender, Contact, Address)In_Patient (Pat_ID, Date_Of_Admission, Bed_No, Start_Time, End_Time)In_Patient_Prescription(Pat_ID, Pres_ID)Appointment (App_ID, Pat_ID, Doc_ID, Nurse_ID, Consult_Room_No, Date,Time)Prescription (Pres_ID, App_ID, Date, Time, Diagnosis_Detail)Prescribed_Medicines (Pres_ID, Medicine_Name, Dosage, Brand)Hospital_Bill (Inv_No, Inv_Date, Pat_ID, Bill_Amount, Payment_Type(cash/credit card/debit card), discount)Lab_Tests (Test_ID, Pat_ID, Date, Time)Test_Results (Test_ID, TT_ID, Result)Test_Types (TT_ID, Description, Low_Value, High_Value, Test_Method,Technician)

Answer rating: 100% (QA)

DDL statements ALTER CONSTRAINT etc 1 Modify Hospital Bill by adding an attribute consulting physician and add foreign key constraint for that attribute Use constraint name for foreign key constraint ... View the full answer