CIS 515 Week 10 Technical Paper Database Administrator For Department CIS 515 Week 10 Technical Paper Database Administr | Page 2

Write a twelve to fifteen (12-15) page paper in which you:
1. Identify the potential sales and department store transactions that can be stored within the
database.
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.
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.