assignment is simple: You are to create the medical database we went over in
the Insurance related entities) and
be able to answer a few simple questions (in two Parts).
you are not familiar with Using Oracle, See the tutorial at the
Supplementary Material Page.
some files (available
from the links at the left) that give additional information and that you might find helpful:
Instructions. This page contains the instructions
needed to complete the assignment .
ERD. This is the ERD that we completed in class. I would suggest
you get a copy of it an refer to it when creating the database and
especially when attempting to answer the questions. It will make life so
much easier for you.
This page contains the SQL commands you are to enter into your command file
to create the database. We will use file in the Lab.
Creating the Database. Once you have created
the file containing the SQL commands, you will need to execute them. This
page shows you how.
This page contains the SQL commands that I have put into the file inmeddat.sql
and that you will use to put the data into your tables. You really don't
need these commands, but for those of you who are curious, I have made the
file available to you.
I Questions. This page lists the Questions your
final program is to answer using SQL Queries (i.e., this is really the
Part II.. This page gives instructions for
physically changing the contents of the database. DO NOT ATTEMPT TO COMPLETE
PART II UNTIL AFTER YOU HAVE COMPLETED PART I.
This page gives you the answers (The SQL Prompts needed and the output each
command will yield).