User Account

All Pages

Assignments of sql programming

Assignment Help PL-SQL Programming
Reference no: EM13725279

Technical Paper: Database Administrator for Department Store Due Week 10 and worth 150 points

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:

Question 1: Identify the potential sales and department store transactions that can be stored within the database.

Question 2: Design a database solution and the potential business rules that could be used to house the sales transactions of the department store.

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

Question 4: Research the Internet for best practices of how retail stores use databases for retaining customers and increasing sales and complete the following:

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

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

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

d. Provide a copy of your working SQL code as part of the paper.

Question 5: 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.

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

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

CIS 515 - Assignments and Rubrics

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

Question 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:

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

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

Question 10: Use at least six (6) quality resources in this assignment.

Reference no: EM13725279

Questions Cloud

Evaluating a project-what is the npv of the project : Monroe, Inc., is evaluating a project. The company uses a 13.8 percent discount rate for this project. Cost and cash flows are shown in the table. What is the NPV of the project?
Apply the tools and techniques in research : Project objective:1.Apply the tools and techniques in research and analysis required to evaluate computer and information science products.2.Describe how pipelining and superscalar processing improve the speed at which a computer program is executed...
Concepts in the development : Select, read and analyze one (1) comprehensive case presented in the text. Please apply all aspects of the course concepts in the development of your case solution.
Write an essay on martin luther : If Martin Luther King was alive today, do you think he would say his dream of racial equality in the United States has been realized? Why or why not?
Assignments of sql programming : Question 1: Identify the potential sales and department store transactions that can be stored within the database. Question 2: Design a database solution and the potential business rules that could be used to house the sales transactions of the depa..
Write an essay on policemen of the world final : Write an essay on Policemen of the World Final Paper and Introduce your paper with your previously crafted thesis statement. Identify two to three (2-3) international events from the past five years.
Determine the primary and secondary target markets : Determine the primary and secondary target markets for your company. Next, analyze the primary and secondary target markets that you identified for your company. Be sure to cover the 4Ps, 5Cs and STP
Personal experiences-failures of change : Organizational change is not always successful. Identify factors that can cause change initiatives to fail and the five pillars that can cause them to succeed. Highlight an organization that failed to adapt and evaluate which of these factors an..
Implication for developing effective oil and gas contracts : Supply Chain Management Factors and their Implication for Developing Effective Oil and Gas Contracts:

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  Question 1 write a query to display the last name

question 1 write a query to display the last name department number and salary of any employee whose department number

  An er diagram for the system

An ER diagram for the system. Show all entities, relationships, cardinalities and optionalities. Also, include all intersection entities. You must use the Finkelstein methodology as per the study book and tutorials.

  Find the sum of the elements of a

A is an ArrayList of size N. The elements of A are integers, they are in sorted order increasing from the low end of the array, and no two integers are the same. Variable x is an integer. Which of the following operations takes time that is less t..

  Write select statement to return those rows with due balance

Write SELECT statement which returns those rows with the balance due greater than 1000. Sort result set by InvoiceTotal, with largest invoice first.

  Write a select statement that returns these column names

Write a SELECT statement that returns these column names and data from the Products table:

  Perform the tasks below by using the correct sql statements

Create a view so that supplier 'ASP' can only see his information from the l_foods table.  Call this view_l_foods_ASP.  Show columns supplier_id, product_code, menu_item, description, and price in your view.

  Create report to display scr courses in alphabetical order

Create the detail report which will display all SCR courses in alphabetical order, with a course name and instructor name in the group header.

  Display all the columns from the orders table

Display all the columns from the Orders table that were paid with a Visa Card and have been shipped to the customer (hint: not a null). Order results by the Item Price in descending order.

  Provide sql statements to create the database

Provide SQL statements to create the database and populate it with sample data (at least four rows per table).

  Create a plsql block to achieve the following using the hr

create a plsql block to achieve the following using the hr schemaselect the name salary and department of the employee

  Produce a diagram showing schema

Produce a diagram showing schema and the partial and transitive dependencies in your 1NF. b. Produce a diagram showing table schema and any transitive dependencies in your 2NF

  Write sql statement to create user defined function

Write SQL statement which creates user defined function which returns int value. This int return value is obtained by deducting the lowest Count field value from the highest Count field value of Part table.

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