This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: ) Queries The output schema for the query is given in parentheses following the query specification. 1. Which accounts have only one patient associated with it? (accountID, lastName, firstName, balance) 2. Which doctors have never made a diagnosis of ‘High blood pressure’? (doctorID, drName) 3. Which patients have had visits with the minimum visit charge? (firstName, lastName, vMonth, vDay, vYear, charge) 4. Which doctors have diagnosed all of the patients who were born in the timeframe from 1965 to 1975? (doctorID, drName, degreeYear) CSE 412/598 2 SQL Study Problems...
View Full Document
- Fall '08
- Physician, Relational model, Given name, SQL Study Problems, Patient Enterprise