The Strayer Oracle Server may be used to test and compile the SQL Queries developed for this assignment. Your instructor will provide you with login credentials to a Strayer University maintained Oracle server.
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.
mpact on Hamlet, especially when he sees the skull of his friend Yorick who occupied a position of fool in the court during his life (Triggs, 1990, pp.73-76). Hamlet realises that death is inevitable for all people, as he puts it, We fat all creatures else to fat us and we fat ourselves for maggots. Your fat king and your lean beggar is but variable service – two dishes but to one table (Shakespeare, 1985 4.2.21-24). But this scene also reveals that the gravedigger and Hamlet are blasphemous in their treatment of death, although to a different extent (Frye, 1979, pp.17-22). As the gravedigger prepares the grave for Ophelia, he sings songs; Hamlet regards this action as awful, although his further action is more cruel. When he finds Yorick’s skull, he begins to mock at him, simultaneously laughing at death: Where be your gibes now? your gambols? your songs? your flashes of merriment that wont to set the table on a roar? Not one now to mock your own grinning? Quite chapfallen? (Shakespeare, 1985 5.1.196-199). Such an ironic vision of the principal character reveals Hamlet’s inner degradation; Ewan Fernie (2002) considers that Hamlet involves into the depth of mortality and destruction, because he feels shame that makes him regard death in an easy and obscure manner. Hamlet thinks that the inner destruction is a necessary prerequisite of revenge, and the failure of this tragic hero works against the illusion and the tyranny of the self (Fernie, 2002, p.225). Although death is a natural phenomenon, Shakespeare demonstrates that people imagine and endure death before they really die, as the ancient culture forms an attitude of people towards death based on suffering and purgatory. As Stephen Greenblatt (2001) puts it, by the late Middle Ages in Western Europe, Purgatory had achieved both a doctrinal and a social success (p.14). In other words, it not only concerned the religious side and the idea of existence, but was also associated with society and its attitude towards reality. In the sixteenth century there were two religious groups in Britain – Catholics and Protestants; the first group maintained the idea of Purgatory, while the second group opposed it. Although during the Renaissance period Protestants made everything to eliminate the principles of Purgatory, Shakespeare demonstrates that Purgatory was also closely connected with cultural beliefs of British people. In this regard, the Ghost of King Hamlet confirms to the dogma of Purgatory, as he appears as a creature that suffers much because of his murder and that demands revenge. In fact, the very image of the Ghost brings up the question of death and supernatural elements, simultaneously demonstrating an ambiguous attitude of Renaissance literature towards the issue of death. On the one hand, on the example of his principal character Shakespeare reveals people’s wish to communicate with dead people, but, on the other hand, he shows the wish of the dead to communicate with human beings. Thus, the Ghost in the play seems to ask not only for revenge, but also for recollection. Despite the fact that Shakespeare does not utilise the word ‘purgatory’ in regard to the Ghost, the dramatist implicitly mentions that the Ghost comes back from this particular place. As Shakespeare (1985) states, Doomed for a certain term to walk the night / And for the day confined to fast in fires, / Till the foul crimes done in days of nature / Are burnt and purged away (1.5.11-14). Purgatory, mystery plays and various medieval rituals were prohibited by the Church of England in the era of Reformation, destroying many important aspects of English culture. Purgatory was closely connected with the beliefs in phantoms, that is why the Church made everything to suppress the spread of these beliefs. However, Renaissance tragedy seems to revive some earlier traditions and customs associated with the dead, and Shakespeare is considered to be one of the principal Renaissance dramatists who combine medieval and Renaissance cultural traditions. Making the Ghost come back from Purgatory, Shakespeare simultaneously signifies the revival of the very concept of Purgatory, although in a changed form. In this regard, William Sh>GET ANSWER