Database Programming – INFT224

Spring 2009

Final Project

Due Wednesday, August 5

Objectives

- To reinforce your knowledge gained from the readings, exercises and class discussions.

- To further extend an understanding of database technology and share this information with the class.

Option 1: Database design and implementation

Design a database (e. g. a group of tables used to hold information to solve a problem). The database system created for this project can be either proposed by you or you may select from one of the suggestions below. In most cases, the data should be normalized. If they are not, please note this and the reason why.

Deliverables

- Database sketch (by hand)

- ER diagram (by hand neatly or using a program such as Visio or Word)

- Be sure the system consists of a minimum of 4 tables

- print out the CREATE TABLE statements for all tables.

- print out the insert statements.

- 4 reports are required (with at least one that performs a join)

- Print out the SQL that generates the report.

- Print out the report itself

- for each table, try to define a primary key, and any applicable foreign keys to help your data maintain integrity. If it is not possible to create a PK or FK, state why.

- write a one page (single spaced) report describing your experience in creating the database. Please include problems encountered and some of the things that you learned.

- Submit your report to Smarthinking and submit their response to me. Do this early enough so you will be able to get the feedback in time for the project completion.

- Class presentation of your project to the class. You can use Powerpoint if you like. Also, you can demonstrate your queries and data structures.

Option 2: Database Technology Paper

Write a 4 page paper (single spaced) on a particular aspect of database technology, or a combination of technologies. Be sure to report on the importance of the technology as well as issues that are prevalent. Possible topics include:

- Open source databases (MySQL, SQLite, PostgreSQL, MaxDB, Firebird, Ingres)

- Data warehouses and Data marts

- Data mining.

- Programming aspects of databases, such as PL/SQL, functions, procedures, triggers, etc.

- Various usages of databases (text data, image data, sound data, etc.)

- Database Administration

- Other database related technology you find interesting.

Deliverables

- Class presentation of your project to the class. You can use Powerpoint if you like.

- 4 page paper.

- Submit your report to Smarthinking and submit their response to me. Do this early enough so you will be able to get the feedback in time for the project completion.