CIS 515 Course Great Wisdom / tutorialrank.com CIS 515 Course Great Wisdom / tutorialrank.com | Page 31

the department store database in your diagram. Note: The graphically
depicted solution is not included in the required page length.

4. Research the Internet for best practices of how retail stores use
databases for retaining customers and increasing sales and complete
the following:
a. Justify how Big Data tools could be used for forecasting sales and
inventory of the department store.
b. Propose two (2) SQL Stored Procedures that use SQL functions to
help sales associates perform explanatory or predictive analytics.
c. Give your opinion on which of the two (2) ways you proposed in
Question four (4) b provide greater value to expanding their business
within the region.
d. Provide a copy of your working SQL code as part of the paper.
5. Research the Internet for database vendors that provide cloud
computing services and complete the following:

a. Estimate the types of costs involved or the pricing structure
required when implementing a cloud-hosted solution for a database.
b. Analyze security considerations and pricing of the different cloud
implementation types.
c. Rank the cloud services options of Software as a Service, Platform
as a Service and Infrastructure as a Service in terms of functionality,
mobility, and ability to provide distributed transaction concurrency.
Compare how these cloud-based services fit within an environment
where users are mobile. Determine the technical provisions that
would be required to ensure data integrity.