Why am I asking is, we are working on health care domain project and designing ER diagram with plenty of tables. We have below doubts.
If we design ER to handle transaction constraints in database end it is difficult to handle insert, update, delete transactions from application layer which means obj-Save, rdb-Save operation sequence handling is difficult. With this approach how we can roll back if somthing goes wrong.
If we design ER same as PRPC OOTB ER, we can handle all the transaction from application end.
What is the best approach? Please let us know advantages and disadvantages as well.