Reference no: EM132622128
COMP 1011 Database Systems Administration - 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. Submit a work proposal for this assignment on or before 02/09/2020, 23:59 Hrs. which must include:
• Understanding of deliverables - a detail description of deliverables.
• General overview of proposed plan - initial understanding of solution to task2 to task-4.
• Timeline for completion of the given tasks.
Task 2:
a. Discuss about the transaction processing in Distributed Database Architecture and identify the roles of various processes associated with a remote transaction.
b. Discuss briefly, the series of transaction happen during a typical Online Food Ordering System. The solution must discusses the various process that are with the user and systems and also various levels of update process.
Task 3:
a. "The Oracle Database Security Assessment Tool is a stand-alone command line tool that accelerates the assessment and regulatory compliance process by collecting relevant types of configuration information from the database and evaluating the current security state to provide recommendations on how to mitigate the identified risks."
In view of the above statement, critically discuss and identify the various security assessment tools and their features that are supported by Oracle. The critical discussion must cover security configuration issues and their solutions, location, type, quantity of data, user privileges and so on.
b. "Dynamic CMS sites are often powered by a database, which is a critical component to secure. This is where your customers' information is stored. Any time a site visitor clicks an image, fills out a contact form, or makes a purchase on your website, that information is stored in the database. As a digital storage room full of important customer information, a database is invaluable to your online business."
With reference to the context cited above, write a reflective report/summary containing a critical discussion on the database security assessment checklist to ensure/guarantee the protection of data.
Developing a performance measurement system
: Question 1: How can an organisation justify spending considerable time and resources developing a performance measurement system?
|
Illustrate online collaborative learning
: Describes four scenarios that illustrate online collaborative learning (OCL).
|
Create ratio analysis word problem
: Create ratio analysis word problem. Answer one of the word problems created by one of your classmates. Show your solutions
|
Ethical obligations associated with classroom management
: How will I comply with the legal, professional, and ethical obligations associated with classroom management?
|
COMP 1011 Database Systems Administration Assignment
: COMP 1011 Database Systems Administration Assignment Help and Solution, Middle East College - Assessment Writing Service
|
What was the direct material price variance for the month
: Direct material quantity variance was $22,800 Favorable. If $215,421 was paid for the direct material, what was the direct material price variance for the month
|
What is effect of transactions on accounting equation
: What is Effect of transactions on accounting equation. Assume that the seller owes $80,000 on a loan for the land. After receiving the $298,000 cash
|
Analyze present organization
: Analyze a present organization where sound leadership principles are necessary for the organization to operate ethically and most effectively
|
What is the effect of the payment on the total amount
: After receiving the $298,000 cash in (a), the seller pays the $80,000 owed. What is the effect of the payment on the total amount of the seller's
|