CIS4365: Database Applications
Fall, 2017

Project Instructions
The Complete ERD
DB Creation Commands
Creating the Database
Inserting Project Data
SQL Question Files
Part 1 Questions
Part 2 Questions
UTEP Oracle 9i
UTEP Oracle 10g Notes

Initial Project

Your assignment is simple: You are to create the medical database we went over in class (without the Insurance related entities) and be able to answer a few simple questions (in two Parts). 

NOTE: If you are not familiar with Using Oracle, See the tutorial at the Supplementary Material Page.

There are some files (available from the links at the left) that give additional information and that you might find helpful:

bullet

Project Instructions. This page contains the instructions needed to complete the assignment .

bullet

The Complete 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.

bullet

Database Creation Commands. 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.

bullet

Creating the Database. Once you have created the file containing the SQL commands, you will need to execute them. This page shows you how.

bullet

Insertion Commands. 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.

bullet

Part I Questions. This page lists the Questions your final program is to answer using SQL Queries (i.e., this is really the assignment).

bullet

Assignment 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.

bullet

Answers. This page gives you the answers (The SQL Prompts needed and the output each command will yield).

All Answers are to be submitted from the  Submissions Page. Check the Course Schedule for the Due Date.

  This page was last updated on 08/19/03.