sqlstudyproblem2

Sqlstudyproblem2 - Queries The output schema for the query is given in parentheses following the query specification 1 Which accounts have only one

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ER Diagram for Patient Enterprise 1 N 1 N N M 1 N CSE 412/598 1 SQL Study Problems Nam dateOfBirt firstNam lastNam Patient accoun patientI patient account accountI balance responsible Party bMont bDay bYear Patien t visit visit charge descriptio visitDate vYea vDay vMont Doctor visit doctor Visit diagnosis diagnosis degreeYea doctorID drName dCode dDescriptio
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
WinRDBI Patient Relational Database Schema patient (patientID , lastName, firstName, bMonth, bDay, bYear, accountID) account (accountID , balance, responsibleParty) visit (patientID, vMonth, vDay, vYear , description, charge, doctorID) doctor (doctorID , drName, degreeYear) diagnosis (dCode, dDescription) visitDiagnosis (patientID, vMonth, vDay, vYear, dCode
Background image of page 2
This is the end of the preview. Sign up to access the rest of the 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

This note was uploaded on 12/11/2009 for the course CSE 412 taught by Professor Davulcu,h during the Fall '08 term at ASU.

Page1 / 2

Sqlstudyproblem2 - Queries The output schema for the query is given in parentheses following the query specification 1 Which accounts have only one

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online