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

2. Design a database solution and the potential business rules that
could be used to house the sales transactions of the department store.

3. Evaluate all relationships of each entity within your database
solution using the Crow’s Foot notation. Include all data elements,
entities, relationships (such as 1:M, 1:1, M:N), and cardinalities for
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.