University of South Florida Database Systems Administration Discussion

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.

Each task is 1000 words max, each task must be within (+/- 50 words)

check the file below for the requirements