Reference no: EM133045012
COMP 1011.1 Database Systems - Middle East College
Learning Outcome 1: Manage database instances and database storage
Learning Outcome 2: Devise and implement database security policies
Assignment Objective
As a Database Administrator, to configure the database server, choose and apply skills relevant client/server environment and manage the data in an organization's business processes.
Assignment Tasks
1) Task 1 -which must include:
• Understanding of deliverables - a detail description of deliverables.
• General overview of proposed plan - initial understanding of solution to all the tasks.
• Timeline for completion of the given tasks.
• References to be used.
2) Task 2 -"Even though data breaches are becoming more common, upholding vigorous security protocols pulls down the threat of being targeted and aids to escape a effective breach attempt. Boost your database security to moderate the jeopardies of a data breach." Discuss at least 10 best practices that a database administrator should be practicing to secure the databases. Support your answer with relevant literature and in-text citations.
3) Task 3: Discuss the correlation between the roles and profiles that are created for the database users. Give one example to support your discussion.
4) Task 4: Discuss in detail the need of query optimization, its impact on the performance of the database server and the effect on resource utilization by the server. Support your answer with relevant literature and in-text citations.
5) Task 5: Complete the given MOOC course and give reflection about the course covering the details on how it helped in enhancing your knowledge about the contents covered in the Module including your suggestions if any. The evidence of course completion indicating your name and progress report/ completion certificate needs to be provided for this task. The link is given below:
Rules & Regulations:
- All resources should be included in the references and cited using CU Harvard style.
Attachment:- Database Systems.rar