You have been tasked to analyze and assess the security posture of your organiza

Question

You have been tasked to analyze and assess the security posture of your organization’s database. Throughout this course, the assignments will have you review and analyze the policies and processes procedures that are implemented to ensure the security of one of an organization’s most important assets: Data. You will learn and understand how data is stored in a database and what are some of the security concerns when dealing with a database.

To begin, you must identify the Database Management System (DBMS) that your organization uses or intends to use, you can choose or work with any database but this will be the database you will work with throughout this course. For this first Discussion Board you are to perform the following tasks:

Pick/list and describe the DBMS selected. You should pick a database you are already familiar with, as you will perform actions and run SQL against the Data Dictionary. Note: Access is not an acceptable choice.

Describe the security features offered by the DBMS and vendor.

Define the concept of a schema, and specify how your specific DBMS implemented the schema.

Explanation / Answer

I will choose SQL as the Database for work with.

Description and Introduction to SQL

What Can SQL perform?

Security Features Offered By DBMS

The security features of the Database are as follows:

Data Schema

A database schema is the structure that represents the logical view of the entire database. It is used to formulate all the constraints that are to be applied on the data.

It is totally depended on the views created by the database.

Implementing Schema in SQL

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.