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
TutorRating
pallavi

Chat Now!

out of 1971 reviews
More..
amosmm

Chat Now!

out of 766 reviews
More..
PhyzKyd

Chat Now!

out of 1164 reviews
More..
rajdeep77

Chat Now!

out of 721 reviews
More..
sctys

Chat Now!

out of 1600 reviews
More..
sharadgreen

Chat Now!

out of 770 reviews
More..
topnotcher

Chat Now!

out of 766 reviews
More..
XXXIAO

Chat Now!

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