CSC 150 Database Applications and Design Using SQL
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
- 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
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