Question;Technical Paper: Database;Administrator for 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. 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;Thoroughly;identified the potential sales and department store transactions that can;be stored within the database.;Thoroughly;designed a database solution and the potential business rules that could;be used to house the sales transactions of the department;store.;Thoroughly;evaluated all relationships of each entity within your database solution;using the Crow?s Foot notation. Thoroughly included all data elements;entities, relationships (such as 1:M, 1:1, M:N), and cardinalities for the;department store database.;Thoroughly;justified how Big Data tools could be used for forecasting sales and;inventory of the department store.;Thoroughly;proposed two (2) SQL Stored Procedures that use SQL functions to help;sales associates perform explanatory or predictive analytics.;Thoroughly;gave your opinion on which of the two (2) mays you proposed in Question;four (4) b provide greater value to expanding their business within the;region.;Thoroughly;provided a copy of your working SQL code as part of the paper.;Thoroughly;estimated the types of costs involved or the pricing structure required;when implementing a cloud-hosted solution for a database.;Thoroughly;analyzed security considerations and pricing of the different cloud;implementation types.;Thoroughly;ranked 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.;Thoroughly compared how these cloud-based services fit within an;environment where users are mobile. Thoroughly determined the;technical provisions that would be required to ensure data integrity.;Thoroughly;evaluated whether the use of a distributed DBMS structure is appropriate.;Thoroughly identified the optimization techniques that should be factored;in, to enhance the operations of the database in your design.;Thoroughly;provided 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.;Thoroughly;determined the concurrency control factors that can be used to ensure;valid execution of transactions within the current multiuser environment.;Thoroughly;suggested at least two (2) options that could be made available to provide;disaster management functions for the database system within the retail;environment.;Thoroughly;assessed the types of security threats that may exist when managing the;department store database. Thoroughly suggested measure(s) that can be;performed to minimize these threats that are particular to retail.;Use at least eight (8) 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 format.;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.
Paper#36727 | Written in 18-Jul-2015Price : $22