Database Systems Administration

Solve the question below:

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.