Ask a question to Desklib · AI bot


Answer.1). A transaction failure is a method where tran

5 Pages681 Words166 Views

Added on  2019-10-09

BookmarkShareRelated Documents
Answer.1)A transaction failure is a method where transaction needs to be stopped when it neglects to execute, and put an incorrect input , deadlock or where it can’t move further after reaching a point. It causes a transaction to fail.It has two types:-Logical Error: When transaction can no longer finish with the execution if ithas some internal condition like no data found, incorrect input etc., and it also gives wrong result. It is a logical error.Eg : Any student data, employee dataSystem Error: when system enters in unpleasant state, it itself aborts the transaction with the execution because of this system condition the database is also not ready to do further execution. It’s called system Error.Eg : deadlock state.Answer 2) Part A:Part B:Horizontal fragmentation for employee tableFragment 1:Fragment 2:Minimal Predicates:pr = {Sex = 'M' ,Sex = 'F', Salary <= 45000, Salary >= 50000, deptNo = 11, DeptNo = 10}There could not be any mininmal predicate possible in this manner.Project table:pr = {contractPrice = 100000, contractPrice = 100000}This is the minimal pridacts.
Answer.1). A transaction failure is a method where tran_1
Answer.3)<?xmlversion="1.0"encoding="UTF-8"?><Department><Dnumber ="5"> <Dname>Research</Dname><Mgr_ssn>333445555</Mgr_ssn><Mgr_start_date>1988-05-22</Mgr_start_date></Dnumber ><Dnumber ="4"> <Dname>Administration</Dname><Mgr_ssn>987654321</Mgr_ssn><Mgr_start_date>1995-01-01</Mgr_start_date></Dnumber><Dnumber="1"> <Dname>Headquarters</Dname><Mgr_ssn>988665565</Mgr_ssn><Mgr_start_date>1981-06-19</Mgr_start_date></Dnumber></Department><DEPT_LOCATION><Dnumber="1"> <Dlocation>Houstan</Dlocation></Dnumber><Dept ID ="4">
Answer.1). A transaction failure is a method where tran_2

Found this document preview useful?