Question: [6.5 points for each part distributed as follows: Query: 4.5 (Select: 1.5, From: 1.5, Where: 1.5), Output: 1.5] PATIENT Patient ID Name DOB Gender BloodType

[6.5 points for each part distributed as follows:

[6.5 points for each part distributed as follows: Query: 4.5 (Select: 1.5, From: 1.5, Where: 1.5), Output: 1.5] PATIENT Patient ID Name DOB Gender BloodType 100 Victor 10/1/1989 Male A 200 Stephanie 9/12/1972 Female B 300 Andrew 11/28/1983 Male AB 400 Eric 7/20/1956 Male o 500 Eric 12/31/1999 Male o 600 Abhinav 1/2/2007 Male B 700 Rakan 3/1/1968 Male O 800 Stephanie 5/5/1985 Female A APPOINTMENT PID DID DayOfWeek 500 100 Wednesday 300 200 Friday 200 500 Monday 800 400 Monday 300 200 Tuesday 200 500 Wednesday 300 100 Thursday 600 200 Friday 600 400 Monday DOCTOR DoctorID Name Department 100 Bruce Pediatrics 200 Melissa Cardiology 300 Kendal Neurology 400 Susan Psychiatry 500 Eric Dermatology 1. What are the IDs of all patients who do not have any appointment? 2. What are the common name(s) among patients and doctors? 3. What are the names of the patients who have appointments on Thursdays? 4. What are the department names of the doctors with which Stephanie has appointments

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!