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

  Explain process for coding and categorizing qualitative data

Explain your process for coding and categorizing the qualitative data. What patterns and/or themes did you discover?

  First - second or third normal form

How many entities are shown by this relation?

  Purpose of the database

Complete Entity-Relationship Diagram (ERD) for the database design. Include all maximum and minimum cardinalities on your diagram.

  Database management challenge than relational database

What is it about a 200 MB video or audio file which makes it so much more of database management challenge than relational database the same size?

  Applying data mining techniques to available data

Applying Data Mining techniques to publically available data produced by both Transpower and the National Institute of Water and Atmospheric Research (NIWA), from which a range of visualizations will be generated.

  Creation of a data classification scheme

Creation of a data classification scheme. A discussion about the sensitivity and mapping of the data into the data classification scheme

  Create a new table in which to store publisher information

In the following project, you will open a database containing the inventory of a bookstore, create a new table in which to store publisher information, add records, and then sort the table

  Create microsoft access database

Create a Microsoft Access database. Create the tables, fi elds, data types, and primary key(s) for the database. Create the relationship(s) needed between the tables.

  Assignment related to er diagram

Question 1: How clear andwell-presented your submission is. Question 2: E-R diagram:adherence too your standard,assumptions made,in clusion of correct primary and foreign keys,appropriate entities,relationships,and attributes.

  Explaining cardinality of a relationship

What is meant by cardinality of a relationship? Your answer requires to be thorough and specific. Be sure to include the two types of cardinality

  Describe discretionary access control

Database security expert to train the database administration team.At the first training session,you ask the trainees to perform the following tasks using Microsoft SQL Server Management Studio. Describe what you expect your trainees to produce.

  Yrace history of the development of databases

In 500 words or less, trace the history of the development of databases beginning with pre-computer days to the present.

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