CAN ANY OF YOU DO THESE 11 QUESTIONS IN 2.5 HRS ? REPLY ASAP

if you are assured about it then only take it if you are not assured then do not go for it because if i will fail in this homework then i will fail and if i will fail then i will destroy your id and if you will do a great job then you will be appreciated and will award you a 2 five star ratings one for handshake and other for answer 

thanks

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:
   1. Justify how Big Data tools could be used for forecasting sales and inventory of the department store.
   2. Propose two (2) SQL Stored Procedures that use SQL functions to help sales associates perform explanatory or predictive analytics.
   3. 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.
   4. 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:
   1. Estimate the types of costs involved or the pricing structure required when implementing a cloud-hosted solution for a database. 
   2. Analyze security considerations and pricing of the different cloud implementation types.
   3. 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.
8. Determine the concurrency control factors that can be used to ensure valid execution of transactions within the current multiuser environment.
9. 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:
   1. Suggest at least two (2) options that could be made available to provide disaster management functions for the database system within the retail environment.
   2. 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.
10. Use at least six (6) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in Excel, Visio, MS Project, or one of their equivalents such as Open Project, Dia, and OpenOffice. The completed diagrams / charts must be imported into the Word document before the paper is submitted.local dept store database

This assignment is not an essay but an exercise that helps build toward your Final Paper for the course. Your task in this assignment is to construct the best argument you can for a position on a controversial topic. Your argument should be your own creation. You may take inspiration from other arguments, but the formulation of the argument you present should be original to you.

Prepare:

• Begin by choosing a topic from the PHI103 Final Paper Options list.
• Construct an argument for a position on the topic. This is the position that you will defend in your Final Paper. Make your argument as high quality as possible: In particular, make sure that all of your premises are true and that the truth of the conclusion is demonstrated by your premises.
• Consider possible objections to your argument, and revise it several times until you have an argument that is as strong as possible.
• Search in the Ashford University Library for quality academic sources that support some aspect of your argument.
• Constructing quality arguments is harder than it sounds; you may find that your first few attempts have problems and that it takes quite a bit of time and effort to revise an argument to a point that the premises adequately support the conclusion. You will be revising this argument for each of the remaining assignments in this course.

Write: In your paper,

• Present a main argument in standard form with each premise and the conclusion on a separate line. Here is an example of what it means for an argument to be presented in standard form

All men are mortal.
Socrates is a man.
Therefore, Socrates is mortal.

• Provide support for each premise of your argument. Explain the meaning of the premise, and provide supporting evidence for the premise. [One paragraph for each premise]
• Pay special attention to those premises that could be seen as controversial. Evidence may include academic research sources, supporting arguments, or other ways of demonstrating the truth of the premise (for more ideas about how to support the truth of premises take a look at the instructor guidance for this week). This section should include at least one scholarly research source. For further information about discovering and including high-quality research take a look at the [email protected] (Links to an external site.)Links to an external site. Tutorial.
• Explain how your conclusion follows from your premises.
• For an example of how to complete this paper, take a look at the Week One Annotated Example The Ethics of Elephants in Circuses (Links to an external site.)Links to an external site.. Let your instructor know if you have any remaining questions about how to complete this paper.

Writing specialists are here 24/7, every day of the year, ready to support you! Click HERE to instantly chat with an online tutor. Click HERE to submit your paper for a review. Papers are returned within 24 hours with a revision plan. Click HERE to email us any writing questions. For additional writing resources like Grammarly (Links to an external site.)Links to an external site., click on the Writing Center tab in the left navigation pane.

For guidance about how to paraphrase sources visit the Ashford Writing Center Guidelines for Paraphrasing Sources (Links to an external site.)Links to an external site. webpage.  For guidance about how to quote sources visit the Ashford Writing Center Integrating Quotes Into Your Essay (Links to an external site.)Links to an external site. webpage. For guidance about summarizing visit the Ashford Writing Center Guidelines for Summarizing Sources (Links to an external site.)Links to an external site. webpage.

The Initial Argument Paper

• Must be 400 to 600 words in length (not including the title and references pages) and formatted according to APA style as outlined in the Ashford Writing Center (for more information about using APA style, take a look at the APA Essay Checklist for Students (Links to an external site.)Links to an external site..
• Must include a separate title page with the following:
  • Title of paper
  • Student’s name
  • Course name and number
  • Instructor’s name
  • Date submitted

• Must use at least one scholarly source in addition to the course text.

• The Scholarly, Peer Reviewed, and Other Credible Sources table offers additional guidance on appropriate source types. If you have questions about whether a specific source is appropriate for this assignment, please contact your instructor. Your instructor has the final say about the appropriateness of a specific source for a particular assignment.

• Must document all sources in APA style as outlined in the Ashford Writing Center (for more information about how to create an APA reference list, take a look at the APA References List (Links to an external site.)Links to an external site. webpage.
• Must include a separate references page that is formatted according to APA style as outlined in the Ashford Writing Center.