COMP 1011 UC Transaction Server Processing System Architecture Discussion Module Learning Outcomes The following LOs are achieved by the student by comple

COMP 1011 UC Transaction Server Processing System Architecture Discussion Module Learning Outcomes

The following LOs are achieved by the student by completing the assignment successfully

1. Manage database instances and database storage

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.

Just task 2

Guidelines:

 Assignment must be computer typed.

 Font – Times New Roman

 Font – Style – Regular

 Font – Size – 12

 Heading should be with Font Size 14, Bold, Capital and Underline.

 Explain with suitable diagrams wherever required. Diagrams must be drawn using suitable

software or by pencil.

 You can refer books in eLibrary or use internet resource. But you should not cut and paste

material from internet nor provide photocopied material from books. The assignment answers

should be in your own words after understanding the matter from the above resources.

 Code should not be copy and paste from other resources. 2. Consider faculties (users) of a certain college, initiates remote database connections using the
college application and saves attendance of their students in the class. Students’ attendance details
are saved in the college database server.
Using the above context as an example, draw the diagram and briefly elaborate on the series of
actions done in a transaction server process architecture.
Your solution must include the use of user process, server process, log writer, database writer
process and checkpoint process in performing the transaction. Solution should also include the
shared memory areas (buffer pool, log buffer and query plan cache) and physical structures (data
files and log files).
Note: Solution should be written strictly in accordance with the given context of faculties as users
saving data in server. Simply writing theoretical points should be avoided.
(30 Marks)

Purchase answer to see full
attachment