Database

1
Database Data WarehouseAssignments

• BCIS 4660 Dr. Nick Evangelopoulos
• Spring 2008

2
BCIS 4660 Spring 2008Exercise 1

• Due Jan 28 for full credit, Feb 4 for 50
  credit
• Points 10 points
• Pratt Adamski End of Chapter 1 pp 27-28
• Assignments must have your name typed on the
  first page.
• Use ACCESS to write the appropriate query, form,
  report or filter to answer ALL even-numbered
  questions for Premiere Products and Henry Books.
• Turn-in printouts of the datasheet,
  filtered-datasheet, or report and the related
  query (as appropriate), which shows the answer to
  the query posed. Screen prints may be used, if
  necessary.
• NOTE For this assignment, use of Access is
  optional. You can just do it manually using Excel.

3
Objectives

• Introduce Premiere Products, the company that is
  used as the basis for many of the examples
  throughout the text
• Introduce Henry Books, the company that is used
  in the case that runs throughout the text

4
Premiere Products

• Distributor of appliances, housewares, and
  sporting goods
• Uses spreadsheet software to maintain important
  data
• Recent growth has made the spreadsheet approach
  problematic
• Redundancy
• Difficulty accessing data
• Limited security
• Size limitations

5
Introduction to Henry Books Database Case

• Book store chain operated by Ray Henry
• Henry decided to use database to gather and store
  information on
• Branches
• Publishers
• Authors
• Books

6
Exercise 2

• Due Feb 4 for full credit, Feb 11 for 50
  credit
• Points 10 points
• Pratt Adamski pp 66-68 (end of chapter 2)
• Assignments must have cover sheet with your name.
  
• Use ACCESS to write the appropriate query, form,
  report or filter to answer QBE questions 6, 8,
  10, 12 for Premiere Products and questions 15,
  19, 20 21 for Henry Books.
• NOTE Make a copy of the Premiere Products and
  Henry Books database from the end of Chapter 1
  BEFORE starting this assignment.
• Turn-in printouts of the datasheet, or report and
  the related query (as appropriate), which shows
  the answer to the query posed along with the QBE
  grid that produced the result. Screen prints may
  be used, if necessary. Show only the attributes
  each question asks for. Do not show any extra
  attributes!

7
Exercise 3

• Due Feb 11 for full credit, Feb 18 for 50
  credit
• Points 20 points
• Pratt Adamski (End of Chapters 3 4)
• Assignments must have cover sheet with your name.
  
• Chapter 3 pp 113-114 Use ACCESS to write the
  appropriate SQL query to answer questions 4, 6,
  8, 14, 15 for Premiere Products and questions 5,
  7, 12, 19, 21 for Henry Books.
• Chapter 4 pp 144-145 Use ACCESS to write the
  appropriate SQL query to answer questions 2, 4,
  7, 10 for Premiere Products and questions 2, 4,
  10 for Henry Books.
• NOTE USE the copy of the Premiere Products and
  Henry Books database from the end of Chapter 1
  the version you had BEFORE starting Exercise 2.
• Turn-in printouts of the datasheet, or report and
  the related query (as appropriate), which shows
  the answer datasheet view, table view, etc. to
  the query posed along with the SQL query that
  produced the result. Screen prints may be used,
  if necessary.

8
Exercise 4
0

• Due Feb 25 for full credit, Mar 3 for 50
  credit
• Points 20 points
• Pratt Adamski (End of Chapters 5 6)
• Assignments must have cover sheet with your name.
  
• Chapter 5 pp 174-175 Answer questions 1, 2, 3
  for Premiere Products and questions 2, 4 for
  Henry Books. Omit 4NF, answer the questions for
  3NF.
• Chapter 6 pp 221-222 Answer questions 2, 4 for
  Premiere Products and questions 1, 2, 3 for Henry
  Books. Turn in ERD and copies of new tables and
  attributes. (Alternatively, use DBDL.)