Part I

In this Case Assignment, you will write the SQL statement to work on the community library database for Part I and discuss discus business intelligence for Part II of the assignment. Following are the tasks you are required to perform for Part I.

Populate data to the tables in your database.

Retrieve the contact details of library customers.

Retrieve the contact details of library customers who live in certain city.

Update the residence information of a certain customer.

Retrieve names and phone number of customers who have overdue books as of a certain date.

Describe what you have learned in this assignment.

Write a paper (3-5 pages) that includes your SQL statements and screenshots of the queries in OpenOffice.

Part II

When you have finished examining these materials, prepare a 3-5 page paper discussing the following.

Data warehouse and business intelligence

In preparing the paper, you may wish to think about questions such as:

What are the differences among database and data warehouse?

What are the data warehouse technologies?

Relationship between data warehouse and business intelligence.

Assignment Expectations

Use information from the modular background readings as well as any good quality resource you can find. Please cite all sources and provide a reference list at the end of your paper.

Part I LENGTH: 3 pages typed and double-spaced.

Part II LENGTH: 3-5 pages typed and double-spaced.

Both parts should be submitted in a single paper properly labeling each part.

Demonstrate the ability to work with SQL data manipulation language.

Communicate effectively with audience.

Your ability to consolidate ideas from reading materials and your understanding on data warehouse and business intelligence