Database Project
Introduction
In this assignment, you will create a database for an application area
of your choosing. First, you will identify a domain and write a
specification for your database. You will review this specification
with the instructor and possibly make changes. Then you will design
and implement a database in Oracle based on the specification.
This is an individual assignment, meaning that you will work on
this project on your own.
The goals of this assignment are to give you experience designing
a complex schema based on real-world situations and then to implement
it in Oracle.
This assignment is intended to make you think about how to design for
real-world situations. Part of the assignment is for you to choose
a domain that reflects a real-world database need. You are encouraged,
but not required, to choose a project that could actually be used.
It is a requirement that your project and design should focus on
a domain that will have a large number of database entries
(e.g. at least 100,000 records).
Carefully think about your design and justify the choices you make.
What to turn in and how
There will be three dates that you turn-in parts of this assignment.
Project Proposal
Due on Sep 16 at the start of class:
-
Turn-in a written "mini-world description" of the domain for your database.
This should be in the style of the mini-world descriptions
from the course textbooks.
Your mini-world description should not be more than 2 pages
in 12 point font.
Project Design
Due on Oct 21 at the start of class:
- A written document that contains:
- An ER diagram reflecting your design
- A description of your schema/tables
- Note and justifications about your design
- A list of sample queries
Completed Project
Due at any time after Oct 21, but before Dec 8:
-
You will give a brief (15-minute) demonstration of your database
to the instructor by scheduling a time to meet in the SILS computer lab.
Note that during the demonstration, the instructor may ask
you to drop and re-create tables, and to re-load data.
You are expected to be prepared to quickly do these tasks
using Oracle scripts and the Oracle bulk-loader.
-
You will also turn in:
- A written document that contains:
- An up-to-date mini-world description
- An ER diagram reflecting your design
- A description of your schema/tables
- Note and justifications about your design
- A list of sample queries, SQL code for them, and output
- A working DB instance implemented in Oracle on the SILS server
- A loaded data set that you have created
|