Ullman Database Book

Exe. 6.6.3

Use the following format for your answers: (a) when T is the READ ONLY transaction from 6.6.1(a) If another READ ONLY transaction runs concurrently 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is deleteModel from 6.6.1 (b), 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is updatePCPrice from 6.6.1(c), 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is insertPC from 6.6.1 (d), 1) Under read uncommitted, . 2) Under serializable, . (b) when T is the deleteModel transaction from 6.6.1(b) If the other concurrent transaction is deleteModel from 6.6.1 (b), 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is updatePCPrice from 6.6.1(c), 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is insertPC from 6.6.1 (d), 1) Under read uncommitted, . 2) Under serializable, . (c) when T is the updatePCPrice transaction from 6.6.1(c) If the other concurrent transaction is updatePCPrice from 6.6.1(c), 1) Under read uncommitted, . 2) Under serializable, . If the other concurrent transaction is insertPC from 6.6.1 (d), 1) Under read uncommitted, . 2) Under serializable, . (d) when T is the insertPC transaction from 6.6.1(d) If the other concurrent transaction is insertPC from 6.6.1 (d), 1) Under read uncommitted, . 2) Under serializable, .