Question: Using RDBM, build the Hospital DBS using all enhanced techniques acquired previously and then apply SQL Note: Apply different SQL Statements including (Except (All), not

Using RDBM, build the Hospital DBS using all enhanced techniques acquired previously and then apply SQL Note: Apply different SQL Statements including (Except (All), not in, inner join, natural fall outer join, Intersect (and Group By)? Administractor ( A_id , A_name, gender) Ward ( ward_id , ward_name , Staff Members , A_id ) Staff Member ( SM_id , SM_name, job description, gender, ward_id ) Physician (ph_id , ph_name, ph_age, ph_gender, SM_id) Patients ( p_id , p_name , Patient_type, phone, age , gender, date_of_admin , date_of_discharge, ph_id ) Patient Diagnosis (PD_id , details , date , p_id ) Room (R_no, R_type , status , PD_id) Lab (lab_no, R_no, date, category, amount) Bill (Bill_id , lab_no , physician_charge, Room_charge, Lab_charge, no_of_days , total b 4:50 PM
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
