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.
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.
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
Some in-text references to modular background readings. (Will provide after handshake, must use some of provided background readings)
Body of paper should be at least 7-8 pages.