Case 4 is in two parts delivering SQL and data warehouse topic of personal interest.
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.
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.
Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.
Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.