Project #66993 - SQL Database

Build a database that you design by yourself and write some queries that use it. This should use a lot of the material from the book. The basic idea is to build your own application using the techniques discussed in most of the chapters. You need to keep this simple. It is a demonstration system, not a real application. 

Database ideas

Music - CDs you own and the songs on them
Sport - Games of your favorite team
Books - Your favorite books
School - The classes you have taken and plan to take
Travel - The places you have been and the vacations you want to take
Money - Your plans for the business you want to start
Art - Your favorite paintings

Please note that these are only suggestions. You can be creative and come up with your own database ideas.

The tables and other database objects

Create four to six tables. (one or two more is OK if you really need them.) Put a few rows of data in them. Put 6 to 10 rows in most of the tables. Put 20 to 30 rows in one table. Make this somewhat similar to the Lunches database. Include most of the following elements:

Two or more text columns
Two or more numeric columns
Two or more date columns
A sequence (and use it when entering some data)
A table of constant values
A referential integrity constraint
A check constraint
A uniqueness constraint
A Not Null constraint
A primary key for every table
A view joining all the tables

The Queries

Create one SQL query based on each chapter, for chapters 2,3,4,6 and 7. It is OK to omit a few, if you cannot see how they apply to your database

When you submit your project, identify which of the above listed elements you have included and where. Be specific about which chapter each query comes from.


Subject Computer
Due By (Pacific Time) 05/04/2015 12:00 am
Report DMCA

Chat Now!

out of 1971 reviews

Chat Now!

out of 766 reviews

Chat Now!

out of 1164 reviews

Chat Now!

out of 721 reviews

Chat Now!

out of 1600 reviews

Chat Now!

out of 770 reviews

Chat Now!

out of 766 reviews

Chat Now!

out of 680 reviews
All Rights Reserved. Copyright by - Copyright Policy