Describe how you would ensure data security

Assignment Help PL-SQL Programming
Reference no: EM131182177

Corporate Proposal for SQL Server

ESL Inc. is a large company that has been using a series of spreadsheets, access databases, and manual records to keep track of the majority of the organization's internal and customer data. They have grown significantly over the years and are now looking to you to provide a comprehensive solution for all their data storage needs. While they are willing to hire staff to maintain whatever system you propose, they have an expectation that data will be able to be mined and made useful for various areas within the company.

For this portfolio project, you will create a proposal that addresses the organization's needs by recommending the use of Microsoft SQL Server 2012.

This project will require you to reflect on and use knowledge gained not only in Module 8, but also in all of the previous module lectures and reading assignments.

I. Overview:

Provide a brief abstract in narrative form of the contents of this proposal.

II. Proposal :

Describe what type of SQL Server you recommend, your suggestion for installing it, and the minimum system requirements.

Describe how you would ensure data security.

Explain how you would monitor the performance of the database.

Describe what type of backup plan you would recommend for the proposed SQL Server.

Identify which process/tool you would use to integrate the new SQL database with their existing systems and how you would use this process/tool.

Explain the biggest risk to the proposed system and how you would address this risk.

III. Conclusion (1 page):

After laying out your proposal, describe the three main reasons why you would recommend SQL Server 2012 as the solution for ESL, Inc.

IV. Reference Page (1 Page):

Your proposal should include five references from credible sources; these sources may include the course textbook or recommended readings. The CSU-Global Library is a good place to find these sources.

Your APA-formatted proposal should be 7-9 pages in length, not including the title and reference page(s).

Reference no: EM131182177

Questions Cloud

Calculate the default risk premium on nikkig : The maturity risk premium is 0.40 percent on 2-year securities and increases by 0.07 percent for each additional year to maturity. Calculate the default risk premium on NikkiG's 10-year bonds. (Round your answer to 2 decimal places.)
Analyze the types of people that work at google : Analyze the types of people that work at Google, with respect to the business culture of the organization. Indicate one to two (1-2) qualities that define a leader at Google, and determine the typical background of a Google employee
President can control the price of gasoline : Find the minimum sample size needed, using a prior study that found that 42% of the respondents said they think their president can control the price of gasoline.c) Compare the results from parts (a) and (b).
Grams of pyridoxine : The amount of pyridoxine (in grams) in a multiple vitamin is normally distributed with mean = 110 grams and standard deviation = 25 grams. What is the probability that a randomly selected vitamin will contain between 82 and 100 grams of pyridoxine..
Describe how you would ensure data security : Describe what type of SQL Server you recommend, your suggestion for installing it, and the minimum system requirements - Describe how you would ensure data security.
Purchased something from them in the last year : An online store contacts 1000 customers from its list of customers who have purchased something from them in the last year. In all, 696 of the 1000 say that they are very satisfied with the store's Web site. The population in this setting is
Analyze extensive research data : Survey professional journals, magazines, books and other texts for topic source validity, Analyze extensive research data and Combine two specialized areas of expertise with a well-rounded understanding of the sociological and cultural implications o..
Eveluate and provide the annual sales revenues and costs : Calculate and provide the annual sales revenues and costs (other than depreciation). Why is it important to include inflation when estimating cash flows?
Write a function that returns the nth fibonacci value : Write the function delete_first(a, obj) that deletes from a only its first item that is equal to obj, if any. The function returns the modified array.

Reviews

Write a Review

PL-SQL Programming Questions & Answers

  You may want to build a database with the required tables

In order to test your program, you may want to build a database with the required tables.  However, the database is not part of the assessment of the assignment.

  Write sql queries to answer the following questions

Double the capacity of each DC-10 airplane.

  Fetech the details from database

Delete the NON_SP_GOOD table from the Premiere Products database.

  Write the code for the triggers

Write the code for the following triggers following the style shown in the text. a. When adding a customer, add the customer's balance times the sales rep's commission rate to the commission for the corresponding sales rep.

  Assess emerging cyber security approaches

Write an 18 page (or longer) paper in which you identify and assess emerging cyber security approaches and technologies as well as discuss government efforts to nurture the development of these emerging technologies.

  Advanced sql and pl sql

Extracting and interpreting data can be very valuable to an organization. Describe the importance of using sub queries in a database system. Provide at least two business case scenarios to support your response.

  Initial radioisotope power supply

A satellite has an initial radioisotope power supply of 70 watts (W). The power output in watts is given by P = 70e-t/250 where t is the time in days. Solve for t to find the time when the power supply is 60 W. (Round your answer to the nearest da..

  Design a query to display details of customers

Design a query to display details of customers from "Albert Park". Sort data according to the alphabetical order of customer's last name and write a query to show details of EmployeeNo.

  Show a structured query language query

Show a Structured Query Language (SQL) query, and screenshot your results in a Microsoft Word document. For Part 2, provide explanations and screenshots documenting

  Addressed using the perl scripting language

addressed using the Perl Scripting Language.

  Propose a cloud-based storage service

For this assignment, imagine that you have been hired by ABC, Inc., a global company, to propose a cloud-based storage service appropriate for a globalized company to use to back up their machines.

  Display all employees names last name first

Display all employees' names, last name first, and then first name, and hire date. Order the results by employee name, last name first, and then first name.

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!

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