Create a database and then secure it

Assignment Help Database Management System
Reference no: EM13831460

Assignment

Background

Now that you have a plan, it is time to implement it. Using WMWare Player (https://www.vmware.com/products/player) you should now install Server 2012 and SQL Server 2012 according to your plan. The goal is simple; you are to install the O/S, the Database Server and create a database and then secure it all as best you can.

Task Details

In assignment you will be installing Windows 2012 Standard Server and the MS SQL Standard database.

In order to do this, you should have a set approach that outlines what you need to do, how to do it, in what order and why you are doing it. You should already have this plan as the result of Assignment.

You are required to, using VMWare Player as your Virtual Environment, install Server 2012, MS SQL 2012 and the supplied database (You can get Microsoft software from the MSDNAA). You are then required to secure it in accordance with your plan.

Finally, you are asked to reflect on your task and write a summary. While it is not worth the most in terms of marks, it is probably the part that will benefit you the most.

• What happened as opposed to what you planned to happen?

• What did you do that you didn't plan for?

• What did you plan for that you didn't do?

• What part of your plan stayed the same and what changed?

• What did you learn from this exercise and what would you do differently next time?

This should be short but it is an important step none the less.

Reflection Length 1500+ Words

Submission Instructions

Virtual Image:

• 2 GB or Under: If the image is under 2GB or can be compressed to under 2GB, please submit to Blackboard.
• 2 GB or over (Blackboard will not play well with files over 2GB):

Referencing

All sources of references must be cited (in text citation) and listed (end reference list). For details about referencing and the required format, please refer to the ECU Referencing Guide, which can be found from the following URL: https://www.ecu.edu.au/LDS/pdf/refguide.pdf

O/S Security-

This will cover areas such as but not limited to:

• Have you enabled the security features in your plan?

• Have you enabled security features that were not in your plan?

• Are the essential features enabled? (lectures/guides/vulnerability scanners/ updates)

• Has the server been hardened?

• What auditing systems are in place?

MS SQL Database Security-

This will cover areas such as but not limited to:

• Have you enabled the security features in your plan?

• Have you enabled security features that were not in your plan?

• Are the essential features enabled? (lectures/guides/vulnerability scanners/ updates)

• Has the Database Server been hardened?

• What auditing systems are in place?

Database Security-

This will cover areas such as but not limited to:

• Have you enabled the security features in your plan?

• Have you enabled security features that were not in your plan?

• Are the essential features enabled? (lectures/guides/vulnerability scanners/ updates)

• Has the Database been hardened? (exploits have been considered, etc)

• What auditing systems are in place?

Reflection-

• What happened as opposed to what you planned to happen?

• What did you do that you didn't plan for?

• What did you plan for that you didn't do?

• What part of your plan stayed the same and what changed?

• What did you learn from this exercise and what would you do differently next time?

Presentation-

• Grammar, Spelling

• Report Format

• Overall Presentation

• Appropriate for intended audience.

Reference no: EM13831460

Questions Cloud

Write each ratio as a fraction in simplest form : write each ratio as a fraction in simplest form.
Treatment versus punishment : When looking at the relationship between social justice and juvenile justice, there are two over arching concepts when addressing juvenile delinquency - treatment and punishment.
Identify the company and give its website : For this discussion, post the website address for a well-known retail company that you consider to have a customer-friendly website. (You should spend some time reviewing and navigating the site before you post the address.) In your post, do the f..
Assignment-diagnostic case reports : Go to the Faces of Abnormal Psychology website. There, you will see twelve different disorders listed. For this module, view the following disorders:
Create a database and then secure it : The goal is simple; you are to install the O/S, the Database Server and create a database and then secure it all as best you can.
Calculate the focal length of the concave mirror : Calculate the focal length of the concave mirror
Problem regarding the borderline personalty : Who do you think would be the hardest to treat with Borderline personalty men or women? Two paragrapghs, APA with at least one reference.
Discussion on nonparametric : Explain what a nonparametric test is, and state one disadvantage of having to use a non-parametric test. Describe a research study where the outcome variable may warrant the use of nonparametric statistics over parametric statistics.
What happens when the price level rises : What happens when the price level rises? Which of the following best describes what happens when the price level rises? If a government started with a deficit and moved to a surplus, which of the following best describes the effects of these changes?

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehouse hi there i need to start the

hi there i need to start the assignment for data warehouse where i need to define assignmentyou are required to design

  Imagine that you work for a consulting firm that offers

imagine that you work for a consulting firm that offers information technology and database services. part of its core

  Draw e-r diagrams and state the relationship

Draw E-R diagrams demonstrating each of the following relationships (create three meaningful examples for each relationship): One-to-One, One-to-many, One-to-Optional Many, Optional Many-to-One, Optional Many-to-Optional Many

  What factors will influence how you design the database

The small publishing company you work for wants to create a new database for storing information about all of its author contracts. What factors will influence how you design the database?

  Which of the following windows commands will shutdown

Which of the following Windows commands will shutdown and restart your computer in 2 minutes? Which of the following Windows commands will shutdown and restart the computerFileServer in 2 minutes

  Explain business intelligence and data warehouses

Business Intelligence and Data Warehouses, Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a manner that optimizes processing large amo..

  Database management systems

An automotive service center or dealer wants to improve its services by using database management systems (DBMS) and data mining. What tables are needed in such a database and how could it help improve their services?

  Create an external dtd that dictates a relational model

Create an external DTD that dictates a relational model-like data structure for XML documents.

  Make the documentation of the organization''s sales database

Imagine that you work for a finance industry-based organization. Your organization is looking to submit its database design documentation to an evaluation team in order to meet Sarbanes-Oxley (SOX) compliance. You have been assigned to assist in p..

  Submit a consolidated word document with the diagram

Create and submit a screenshot of your database diagram based on the tables, and generate the data definition language (DDL) for each table.

  Normalisation

Normalisation of relations which identifies: Dependency diagram for each relation, The level of Normalisation achieved for each relation;, The reasons for any relation that is maintained NOT in 3NF.

  After a lengthy description he further challenged you to

you are the new chief information officer for acme widgets. the president of the company recently asked you what you

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