A better design would be one with the following tables: Patient : | pid | name | dob | addr | tel | Exam : | acc | pid | eid | result | date | ExamDictionary : | eid | name | normal | Questions: Create SQL queries (select statements) that accomplish the following. 1. List all of the Exams for Ms. Jones (pid=12). 2. List all of the Patients that hail from jolly old London. 3. List all of the Exams with results that exceed their normal.
A better design would be one with the following tables:
- Patient : | pid | name | dob | addr | tel |
- Exam : | acc | pid | eid | result | date |
- ExamDictionary : | eid | name | normal |
Questions:
Create SQL queries (select statements) that accomplish the following.
1. List all of the Exams for Ms. Jones (pid=12).
2. List all of the Patients that hail from jolly old London.
3. List all of the Exams with results that exceed their normal.
4. List the name of all Patients that had Exams with results that exceed their (the exam’s) normal.
5. List the name of all Patients that had Exams with results that exceed their (the exam’s) normal, but list names only once and in alphabetical order.
Step by step
Solved in 2 steps with 6 images
4. List the name of all Patients that had Exams with results that exceed their (the exam’s) normal.
5. List the name of all Patients that had Exams with results that exceed their (the exam’s) normal, but list names only once and in alphabetical order.
by Bartleby Expert
