Suppose that we have access to the world database, on the server something.com with username "Jim123" and password is K@$t0r1@. We need to create in any programming language, an application that will be connected to the above database and will perform the following actions. The user, that is you, will choose from an appropriate menu like the one shown in the picture. 1. Connect to the system of the database. 2. Display of data 3. Data entry 4. Update data 5. Start transaction 6. Exit the System. In the meantime you will have created appropriate triggers that will inform appropriate table for the actions that have been taken. The names of the triggers will be formed with the name that you as a user have followed from the trN with N (1,2,3,...), example jsinatkas_tr4. Also in the transaction process you will make sure to lock, if needed the the table or tables in which you are going to enter or update data them. This lock will last as long as it is necessary to complete your action. This will be ascertained by a parallel related action that will be performed simultaneously by two users
Suppose that we have access to the world
We need to create in any programming language, an application that will be connected to the above database and will perform the following actions.
The user, that is you, will choose from an appropriate menu like the one shown in the picture.
1. Connect to the system of the database.
2. Display of data
3. Data entry
4. Update data
5. Start transaction
6. Exit the System.
In the meantime you will have created appropriate triggers that will inform appropriate table for the actions that have been taken. The names of the triggers will be formed with the name that you as a user have followed from the
trN with N (1,2,3,...), example jsinatkas_tr4. Also in the transaction process you will make sure to lock, if needed the the table or tables in which you are going to enter or update data them. This lock will last as long as it is necessary to complete your action. This will be ascertained by a parallel related action that will be performed
simultaneously by two users.
Step by step
Solved in 3 steps with 2 images
