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

  Create a database model

Create a database model and Submit the table creation statements for the Database Model.

  Write pl-sql procedures and functions

Write PL/SQL procedures and functions to populate and query that database

  Sql questions

Write a query to display using the employees table the EMPLOYEE_ID, FIRST_NAME, LAST_NAME and HIRE_DATE of every employee who was hired after to 1 January, 1995.

  Run the lab_03_01.sql script

Run the lab_03_01.sql script in the attached file to create the SAL_HISTORY table. Display the structure of the SAL_HISTORY table.

  Write sql queries

Write a query to display the last name, department number, and salary of any employee whose department number and salary both match the department number and salary of any employee who earns a commission.

  Explaining sql insert statement to insert new row in cds

Write down a SQL insert statement to insert new row in "CDS" table.

  Write down name of actors in ascending order

Write down actors (or actress, your choice, but not both) who have won at least two (2) Academy Awards for best actor/actress. Provide the actor name, movie title & year. Order the result by actor name."

  What is an sql injection attack

What is an SQL injection attack? Explain how it works, and what precautions must be taken to prevent SQL injection attacks.What are two advantages of encrypting data stored in the database?

  Determine resonant frequency in series rlc resonant circuit

Given the series RLC resonant circuit in the figure, operating at variable frequency, determine: The resonant frequency ω o ,  The circuit’s quality factor Q , The cut-off frequencies, f 1  & f 2  and the bandwidth BW

  Query that uses cube operator to return lineitemsum

Write summary query which uses CUBE operator to return LineItemSum (which is the sum of InvoiceLineItemAmount) group by Account(an alias for AccountDesciption).

  Query to show customers were missing for existing orders

As DBA, your manager called a meeting and asked why there are so many orders for customers that don't exist in the customer table. Write query which would shows which customers were missing for existing orders. Use a join or a subquery.

  Sql query into a relational algebra statement

Turn this SQL query into a relational algebra statement? SELECT Request.reqfor, Ordering.invamt, Ordering.invnbr, Ordering.invdat

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