Overview: For your final project, you will provide recommendations to a given organization (here AdventureWorks is an organization) looking to expand their client/server system. You have been hired by the company as a consultant and are asked to make recommendations regarding their expansion. For Milestone Two, you will offer recommendations and information to the organization regarding security measures that should be taken and strategies that should be used to monitor client activity on their system.
Prompt: Recommend measures that should be taken to mitigate common security vulnerabilities.
draft the data security and integrity section of your project report (Prompt I, Section II).
Prompt I, Section II – The administration and maintenance of a database management system (DBMS) is something that a database administrator is responsible for. This includes monitoring the performance of a DBMS to ensure that it is operating effectively; scheduling updates for the databases associated with the DBMS; capacity planning, installation, configuration, database design, migration, performance monitoring, security, and troubleshooting; and backup and data recovery. Security concerns involve not only the protection of the data, but also the assigning of proper rights and permissions within the organization for personnel to access the data.
When we refer to the maintenance of a database, we are planning changes to the tables or schema. Databases are updated with organizational data on a regular basis, so maintenance is typically scheduled for off-hours.
When designing a database, a goal is to limit data redundancy (i.e., limiting the same data that appears on more than one table). This is where normalization comes in. Normalizing a database means organizing the data within tables in such a way that data redundancy is minimized.
Offer recommendations and information to the organization regarding security measures that should be taken and strategies that should be used to monitor client activity on their system.
Specifically, the following critical elements must be addressed:
II. Data Security and Integrity: In this section, you will offer recommendations and information to the organization regarding security measures that should be taken and strategies that should be used to monitor client activity on their system.
A. Describe common security vulnerabilities for both client-side applications and server-side databases that the organization should be aware of.
B. Recommend strategies the organization should implement regarding data encryption that would help mitigate common security vulnerabilities.
C. Recommend authentication and authorization procedures that the organization should implement that would mitigate common security vulnerabilities.
D. Recommend data validation measures on client-side applications and server-side databases that will ensure the integrity of organizational data.
this assignment is continuation of milestone 1 assignment, here am attaching milestone 1 assignment file :
