Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need the answer as soon as possible Please. And I will Give Upvote Q/for this data base of hospital apply 7 SQL commands at

I need the answer as soon as possible Please. And I will Give Upvote

image text in transcribed

Q/for this data base of hospital apply 7 SQL commands at least? 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 12:49 AM Q/for this data base of hospital apply 7 SQL commands at least? 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 12:49 AM

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Probabilistic Databases

Authors: Dan Suciu, Dan Olteanu, Christopher Re, Christoph Koch

1st Edition

3031007514, 978-3031007514

More Books

Students also viewed these Databases questions