Database administrator for a local department store

Assignment Help Database Management System
Reference no: EM13914806

Imagine that you have been hired as the database administrator for a local department store. The department store has recently expanded by opening five (5) stores within your local region. They have also launched a series of marketing campaigns to attract new customers and increase sales. For your hired role, you will be responsible for creating and maintaining an enterprise-wide database system that will hold the sales and inventory data for the organization. The designed database will help operations in supporting its new business marketing strategy. Using the concepts presented throughout the course, you will develop a plan to create this database and establish a design that aligns with the product sales initiatives of the organization.
Write a twelve to fifteen (12-15) page paper in which you:
Identify the potential sales and department store transactions that can be stored within the database.
Design a database solution and the potential business rules that could be used to house the sales transactions of the department store.
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.
Research the Internet for best practices of how retail stores use databases for retaining customers and increasing sales and complete the following:
Justify how Big Data tools could be used for forecasting sales and inventory of the department store.
Propose two (2) SQL Stored Procedures that use SQL functions to help sales associates perform explanatory or predictive analytics.
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.
Provide a copy of your working SQL code as part of the paper.
Research the Internet for database vendors that provide cloud computing services and complete the following:
Estimate the types of costs involved or the pricing structure required when implementing a cloud-hosted solution for a database.
Analyze security considerations and pricing of the different cloud implementation types.
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.
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.
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.
Determine the concurrency control factors that can be used to ensure valid execution of transactions within the current multiuser environment.
Research the Internet for backup and restoration recovery solutions and database security threats that could be applicable to the department store. Upon your research, complete the following:
Suggest at least two (2) options that could be made available to provide disaster management functions for the database system within the retail environment.
Assess the types of security threats that may exist when managing the department store database and suggest measure(s) that can be performed to minimize these threats that are particular to retail.
Use at least six (6) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Reference no: EM13914806

Questions Cloud

Absorption costing and variable costing : Determine the unit product cost under absorption costing and variable costing.
What is the effective annual rate on your loan : You have budgeted $450 per/month to purchase an automobile. You can obtain a 5-year new car loan for 6%, Annual Percentage Rate (APR). How much will you be able to borrow? Also, what is the Effective Annual Rate (EAR) on your loan?
Determine the present value now of an investment : Determine the present value now of an investment of $3,000 made one year from now and an additional $3,000 made two years from now if the annual discount rate is 4 percent
Determine the total interest paid over the course of loan : Determine the total interest paid over the course of the loan. Determine the total principal paid over the course of the loan
Database administrator for a local department store : Imagine that you have been hired as the database administrator for a local department store. The department store has recently expanded by opening five (5) stores within your local region.
Phases of the strategic management process : In the first week of class we discussed the three phases of the Strategic Management Process. Understanding the Internal Strengths and Weaknesses is essential to both the Strategy Formulation and the Strategy Execution phases.
What is the impact of the currency changes on fourth quarter : Identify four quality of earnings issues reported in the case and the analysts' concern about each. In percentage terms, what is the impact of the currency changes on fourth quarter earnings?
Incident response system-place of employment : Why is it necessary for a business to have an Incident Response System in place? Does your place of employment have one? Explain in detail.
Analysis of specific branch of manufacturing-service-trade : Industry analysis is the analysis of a specific branch of manufacturing, service, or trade. Understanding the industry in which a company operates provides an essential framework for the analysis of the individual company—that is, company analysis.

Reviews

Write a Review

 

Database Management System Questions & Answers

  Write summary on relational database theory

Write a two-page executive summary for your boss explaining how a relational data solution can be applied to a current business problem or area for improvement. Assume that your boss knows nothing about relational database theory.

  Find three different standards practices from entities

Find at least 3 different standards / best practices from entities that you consider authoritative in this field for both Server and Database securing and hardening (that is 6 standards in total).

  Outline the main differences between the structure of a

businesses today are extremely reliant on large amounts of data for making intelligent business decisions. likewise the

  Summarize your paper by explain the database systems in

write a 600- to 700-word paper in which you do the following explain what database systems are and how they are used.

  Explain how queries are processed by the oracle dbms

Explain how queries are processed by the Oracle DBMS and Explain how transactions are processed by the Oracle DBMS

  What is cold backup and hot backup in case of oracle

What is cold backup and hot backup (in case of Oracle)? What are Armstrong rules? How do we say that they are complete and/or sound?

  How does data become usable information

How does data become usable information and Find articles to support your argument in both situations. Is the article based on quantitative or qualitative research? Explain

  Describe the importance of using sub queries in a database

1. Extracting and interpreting data can be very valuable to an organization. Describe the importance of using sub queries in a database system. Provide at least two business case scenarios to support your response.

  Craete the database to be fault tolerant

Explain the thought process of DBA as they craete the database to be fault tolerant. What policies would you suggest to get this goal?

  Recognize level within a database system

Recognize level within a database system (user, programmer of application software, and designer of the DBMS software) at which each of the following concerns or activities occur.

  Create a detailed erd using the data specificationsnoted

Use a Microsoft® Visio® diagram to create a detailed ERD using the data specificationsnoted in the Week Two Individual Assignment. Make any necessary changes provided in your faculty's feedback.

  Identify a specific type of variable that stores a number

Identify a specific type of variable that stores a number. Compare the variable type that you selected to at least one other type of variable that also stores numbers

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd