Master table should have a primary key which is used as a foreign key in the transaction table.

• Create a primary key in the master table

• Create a foreign key in the transaction table that references the...read more