CS 4250 Project Part 6
Hardcopy/email due at the start of class on Monday, May 6, 2013.
(Subject line of "cs4250, project part 6", exactly. PDF, plain text
or MS Word only. )
What to turn in:
- Write five different queries on your database,
using the SELECT/FROM/WHERE construct
provided in SQL. Your five queries should illustrate several
different aspects of database querying, such as:
- Queries over more than one relation (by listing more than one
relation in the FROM clause)
- Queries involving
aggregate functions, such as SUM, COUNT,
- Queries involving complicated selects and joins,
- Queries involving GROUP BY,
HAVING or other similar functions.
- Queries that require the use of the DISTINCT or ALL
You do not have to illustrate all the above aspects, just the
ones that occur naturally in your application. Try to infuse
some reality into your project and think of some reasonable
queries that people would want to make with your application.
For example, in a book application, writing a query such as
"Find all authors whose ages are one fifth of the number of pages in their
novel" sounds silly!
You will not lose points if you do not cover all the above aspects.
You will lose points if you don't illustrate any of the
above aspects, and you don't explain why.
- You have already read Chapters 10 and 11 of your textbook,
which deal with indices. If you were to create indices on your
tables to speed up query processing, which attributes would you
place the indices on? What type of index would you use, for each
index you would create? Provide reasons for your decisions. Notice that
this is a theory question; you do not have to experiment with
creating indices on your recommended attributes.
A document that details the
- A list of your defined SQL schemas; these schemas are to remind me
about your project.
- A list of the SQL queries that you tried out, a description in
English of what the queries are supposed to find, and the results
you obtained. If an answer is long (and runs to several pages),
please include just enough of the answer in your solution so
that we know what is going on. Do not forget to mention that you
truncated the final output. Please do not include pages and
pages of answers.
If you can, include an example of a SQL query you
tried that did not work out, and an explanation of why it did not
work out -- I am looking for evidence of learning, and our failures are
frequently the most educational part of any learning experience.
- Your answer to question 2 above. (Indices.)
- Do not forget to include the names and email addresses of all project partners.
- Required but not graded: Include one sentence per group member summarizing
each group member's contribution to Project Part 6. These sentences
are not for part of any student grades.