CYB 200 Module Four Activity Template_KOCH

....

this is an ITSE 2356 course we use Bob Bryla and Iggy Fernandes as a reference: the assignment as below. As a result of the corporate technology assessment initiative, your position has been elevated to a Senior Database Administrator.  As a result of this promotion, you have been tasked with establishing the new corporate wide Standard Operating Policy Manual for the new Data Asset Division you now lead.  As such, your task now is to establish/write new policies-procedures for the following topics:   - - Establishing the Corporate Database Backup Plan Policy 3pages - - Establishing the Corporate Database Restore Policy – 3 pages - - Establishing an SQL Query Performance tuning Policy Benchmark 3 pages - - Establishing a Database Maintenance Policy Process 3 pages - - Establishing the new “Security” Policy for  password protection.3 pages

What is a database audit trail, and how does it work? Explain in no more than 60 words what you mean.

Domain Integrity     Entity Integrity     Referential Integrity

Discuss the importance of data security and access control in data warehousing.

Discuss the importance of data normalization and integrity.

I need some help with a little mysql coding. Here is the short description... A Database Story: Backup then Recovery [NG] Author: Daniel KillamFramework Category: Operate and MaintainSpecialty Area: Network ServicesWork Role: Network Operations SpecialistTask Description: Develop and implement network backup and recovery procedures. (T0065)Scenario It seems that our new intern has deleted some important database files needed for an upcoming project. This incident has caused us to realize that we are severely lacking in our standard recovery and backup procedures. As such , we need you to design and implement a plan for backing up and restoring data critical to our business. After designing these procedures, they need to be tested in order to ensure their functionality. Additional Information More details and objectives about this challenge will be introduced during the challenge meeting, which will start once you begin deploying the challenge.You will be able to check your progress…

Security is identified as the processes or features in the system that ensure data integrity. What type of requirement is security? Select one.   Question 6 options: A Functional Requirement B Nonfunctional Requirement

What are the potential choices for field-level data integrity control?

One tip for effective virtual meetings is to establish norms for file naming conventions. 4 True False

Kindly explain the flow of data on the diagram