In Example 8.1.7 the result of the query SELECT PatientID#, Name FROM S WHERE

Chapter 8, Problem 24

(choose chapter or problem)

In Example 8.1.7 the result of the query SELECT Patient−ID#, Name FROM S WHERE Primary_Diagnosis = X is the projection onto the first two coordinates of the intersection of the set \(A_{1} \times A_{2} \times A_{3} \times\{X\}\) with the database.

a. Find the result of the query SELECT Patient−ID#, Name FROM S WHERE Primary_Diagnosis = pneumonia.

b. Find the result of the query SELECT Patient−ID#, Name FROM S WHERE Primary_Diagnosis = appendicitis.

Text Transcription:

A_1 times A_2 times A_3 times {X}