TABLE 1: Contents of the Prod_log Table After the First Batch of Modifications
lsn log_date tran_type productid productname package namechg packagechg
1 2002-12-02 13:50:47.553 I 101 prod1 10 NULL NULL
2 2002-12-02 13:50:47.627 I 102 prod2 10 NULL NULL
3 2002-12-02 13:50:47.627 I 103 prod3 10 NULL NULL
4 2002-12-02 13:52:41.640 U 103 prod3 20 0 1
5 2002-12-02 13:52:41.980 D 102 prod2 10 NULL NULL