Case Description
This case segment uses the physical designs you constructed for Mountain View Community Hospital (MVCH) in Chapter 5 to complete the case questions and case exercises.
Case Exercises
Using your database from Case Exercise 1, write and test SQL queries that
a. Select information from only one of the tables.
b. Aggregate information from one attribute in a table.
c. Try out the various functions, such as MIN, MAX, and AVG.
d. Qualify results by category
Reference Case Exercise 1,
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.