Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Civilstatus' 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:
UniqueID 'Firstname', 'Lastname', 'Salary', 'Department', 'Civilstatus'
'John', 'Lennon', 'Projects', 'Married'
'Joan', 'Doe', 'Human Resources', 'Single'
'Mary', 'Carpenter', 'Projects', 'Separated'
'John', 'Ingham', 'Projects', 'Separated'
'Rachel', 'Sturgeon', 'Engineering', 'Married'
'Hanifa', 'Salima', 'Engineering', 'Married'
'Femi', 'Okeke', 'Industries', 'Married'
'Moe', 'Khalifa', 'Industries', 'Married'
'Katy', 'Jones', 'Management', 'Single'
'Lin', 'Wang', 'Engineering', 'Married'
'Art', 'Blanket', 'Projects', 'Single'
'Vivek', 'Singh', 'Industries', 'Married'
'Amal', 'Khan', 'Projects', 'Single'
'Richard', 'Carpenter', 'Human Resources', 'Single'
'Ryuichi', 'Sakamoto', 'Processing Facilities', 'Single'
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started