User Account

All Pages

Evaluate whether the use of a distributed dbms structure is

Assignment Help Marketing Management
Reference no: EM13396192

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:

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:

5.Justify how Big Data tools could be used for forecasting sales and inventory of the department store.

6.Propose two (2) SQL Stored Procedures that use SQL functions to help sales associates perform explanatory or predictive analytics.

7.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.

8.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:

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.

d.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.

e.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.

f.Determine the concurrency control factors that can be used to ensure valid execution of transactions within the current multiuser environment.

g.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:

h.Suggest at least two (2) options that could be made available to provide disaster management functions for the database system within the retail environment.

i.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.

Reference no: EM13396192

Questions Cloud

Write a paper in no more than 1750 words that focuses on : the guillermo furniture store scenario or your own organization with the approval of your instructor for this
The supermarket pays 100 for each copy of people and sells : a small supermarket is trying to determine how many copies of people magazine it should order next week. the owner
It is interesting and significant for community health : it is interesting and important for community health professionals to study workplace injuries by geography by industry
Write a paper in no more than 1050 words that focuses on : the ongko furniture store scenario or your own organization with approval from your instructor for this assignment
Evaluate whether the use of a distributed dbms structure is : imagine that you have been hired as the database administrator for a local department store. the department store has
Choose current exchange rate practice and describe economic : team as we continue to understand the power of economics in a global context evaluate the impact of exchange rate
Distinguish between the occupational injuries and diseases : differentiate between occupational injuries and diseases and discuss at least two important examples of each.your
Create a pro forma cash flow budget for the organization : write a paper in no more than 1400 words that includes the following itemsanalyze ongkorsquos alternatives and make a
Explain pressing occupational safety and health challenges : describe pressing occupational safety and health challenges in america today and consider their importance in terms of

Reviews

Write a Review

Marketing Management Questions & Answers

  Integrated marketing communication

Developing an IMC plan of Amazon that aims to create awareness and knowledge amongst Singaporean  consumers of the ethics involved in buying clothing made from Bangladeshi factories  .

  Multiple choice questions on e-commerce

The assignment in Computer Science or Information Technology is about multiple choice questions, particularly in e-commerce. Questions such as types of e-commerce websites, commercial websites, disintermediation, Platform for Piracy, the data that ca..

  Balanced scorecard for red lobster

The assignment in marketing is about Red Lobster, which is one US and Canada's most loved seafood restaurant. It has hundreds of outlets in US and Canada and it now wants to expand further. The approach adopted by Red Lobster has been discussed in fu..

  Marketing plan - marketing audit, swot and smart report

The assignment in marketing is about preparing a marketing plan. As part of marketing plan, the SWOT analysis, assessing the competitive position, identifying critical competitive issues, marketing objectives, strategy and actions have been suggested..

  Marketing plan

Marketing deals with preparing a marketing plan for either an existing product or a new product. Various aspects about launching a new product into the market are discussed ranging from the industry the product belongs to, goals and vision of the com..

  Yamato corporation analysis - harvard case study

Please refer to the PDF for the Case Study and questions.The case study from Harvard Business School is about Yamato Corporation, a parcel delivery company which provides door to door delivery in Japan.

  Marketing plan - create a new product

The assignment in marketing is about competitive analysis for a new product namely "heated insoles". These heated insoles can be put in shoes and they can protect the wearer's feet by keeping them warm during cold winters.

  Report on digital marketing strategy for a website

Promotion strategies of  the one's own developed website

  Integrated marketing campaign of mccafe

Integrated marketing campaign for McDonald's McCafe. McCafe has been launched in Canada. This is a case study which involves the use of digital marketing and social media marketing apart from regular marketing such as TV and radio. All these more are..

  New product development at adidas

In this paper, the researcher also determines the different kind of practices used by Adidas to manufacture shoes for its customers.

  Managing services in competitive environment

Services can be defined as separately identifiable, intangible activities which provide want-satisfaction when marketed to household consumers and/or industrial users.

  Prepare a marketing plan

A marketing plan is an essential tool for any marketer, providing direction for a brand, product or organization. A marketing plan describes the marketing environment, marketing objectives and marketing strategies.

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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