I have two tables having 1 to 0 , 1 to many relationship.
also the structure is as follows:
contract no. (PK) smallint,
account no. smallint,
contract creation date timestamp
contract id (PK) smallint,
contract no. (FK) smallint
how to insert /delete data into these tables should i first enter data into child table and then parent table or vice versa.
Does the condition remain the same during deletion as well?
Kindly help me out.I have always had this confusion between tables having parent child relation