You are going to simulate a logging and rollback system for a simple database that encompasses individuals, their salary, department to which they are affiliated to in the corporation, and their civil status.

As we are focusing on the conceptual side and will be running a simulation, we will not be using any specific RDBMS$.$ After all, every RDBMS includes among their capabilities this logging and rollback functionality.

To simplify the problem, we will focus on the attributes 'Salary', 'Department' and Civil$\_$status' of three individuals: the transaction list in the starting code will specify the update transactions that will be processed.

Below you'll find an image of the DB $($ a simple $.$csv file$)$:

$[\text{'}$Unique$\_$ID$\text{'},$ 'First$\_$name', 'Last$\_$name', 'Salary', 'Department', 'Civil$\_$status'$]$

$[\text{'}1\text{'},$ 'John', 'Lennon', $\text{'}230000\text{'},$ 'Projects', 'Married'$]$

$[\text{'}2\text{'},$ 'Joan', 'Doe', $\text{'}100000\text{'},$ 'Human Resources', 'Single'$]$

$[\text{'}3\text{'},$ 'Mary', 'Carpenter', $\text{'}250000\text{'},$ 'Projects', 'Separated'$]$

$[\text{'}4\text{'},$ 'John', 'Ingham', $\text{'}125000\text{'},$ 'Projects', 'Separated'$]$

$[\text{'}5\text{'},$ 'Rachel', 'Sturgeon', $\text{'}197000\text{'},$ 'Engineering', 'Married'$]$

$[\text{'}6\text{'},$ 'Hanifa', 'Salima', $\text{'}50000\text{'},$ 'Engineering', 'Married'$]$

$[\text{'}7\text{'},\text{'}$ 'Femi', 'Okeke', $\text{'}425000\text{'},$ 'Industries', 'Married'$]$

$[\text{'}8\text{'},$ 'Moe', 'Khalifa', $\text{'}325000\text{'},$ 'Industries', 'Married'$]$

$[\text{'}9\text{'},$ 'Katy', 'Jones', $\text{'}475000\text{'},$ 'Management', 'Single'$]$

$[\text{'}10\text{'},$ 'Lin', 'Wang', $\text{'}435000\text{'},$ 'Engineering', 'Married'$]$

$[\text{'}11\text{'},$ 'Art', 'Blanket', $\text{'}137000\text{'},$ 'Projects', 'Single'$]$

$[\text{'}12\text{'},$ 'Vivek', 'Singh', $\text{'}231000\text{'},$ 'Industries', 'Married'$]$

$[\text{'}13\text{'}\text{'},$ 'Amal', 'Khan', $\text{'}230000\text{'},$ 'Projects', 'Single'$]$

$[\text{'}14\text{'},$ 'Richard', 'Carpenter', $\text{'}123000\text{'},$ 'Human Resources', 'Single'$]$

$[\text{'}15\text{'},$ 'Ryuichi', 'Sakamoto', $\text{'}321000\text{'},$ 'Processing Facilities', 'Single'$]$