CSC 150 Database Applications and Design Using SQL

Spring 2010

Term Project

Home

Assignments

Syllabus
This term project is required for all students taking this course. By the fourth week, you will have enough information to begin this project.
For this project, you are going to design and build your own database and construct queries to extract your data. This project should use the techniques presented in the book. You are going to be building your own application using the techniques discussed in chapters one through twelve in the course textbook.
You need to keep this simple. It is a demonstration system, not a real world application.
Due Date: May 13, 2010

Looking at the Database Design Process

Project Ideas

Music - CDs you own and the songs on them
Sports - Favorite teams and players on the teams
Books - Your favorite books, plots and characters
School - Classes you have taken and plan to take, instructors and grades
Travel - Places you have been or want to visit, things to see at these locations
Art - Your favorite artists and their paintings
And so on, and so on

Tables and Other Database Objects

Create at least four tables (up to eight if you need them). Put several rows of data into each table, 6 - 10 in most tables, 20 - 30 rows in one table. You should use the Lunches database example from the book and the Recipes database designed by your instructor as your guide.

Your database should include the following elements:

Two or more text columns
Two or more numeric columns
A date column
A referential integrity constraint
A check constraint
A uniqueness constraint
A Not Null constraint
A primary key for every table

Extra Credit Additions

A sequence used when entering some data
At least one table of constant values
A file to load data into one table from a flat file

Queries

Create at least one SQL query based on each chapter for chapters 2 - 12. It is okay to omit a few if they do not apply to your database.

What To Submit

A table of contents to identify the elements from the above list and where each of the elements is found.
A data dictionary listing each field of data and the type of the data for your database
All queries in order by chapter
Pictures of both before and after tables

Last Updated: 3/12/10