CIS 515 STUDY Learn Do Live /cis515study.com CIS 515 STUDY Learn Do Live /cis515study.com | Page 23

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.
6. Evaluate whether the use of a distributed DBMS structure is
appropriate and identify the optimization techniques that should be
factored in to enhance the operations of the database in your design.
7. Provide at least two (2) examples of how lost updates and
uncommitted data may occur, keeping in mind that five (5) stores will
be generating transactions.