Foreign Keys or Delete Trigger?

Foreign Keys or Delete Trigger?

References

Reference NO 1

http://www.postgresql.org/message-id/5d0f60990601111456m136aff2se77e354354a1c6aa@mail.gmail.com

Reference NO 2

http://stackoverflow.com/questions/15474046/why-oracle-trigger-on-delete-is-executed-when-foreign-key-is-set-to-null

Reference NO 3

http://dev.mysql.com/tech-resources/articles/mysql-enforcing-foreign-keys.html

Reference NO 4

http://www.mssqltips.com/sqlservertip/1508/foreign-key-vs-trigger-referential-integrity-in-sql-server/

Reference NO 5

http://www.sqlservercentral.com/Forums/FindPost522075.aspx

Reference NO 6

https://forums.oracle.com/thread/887170

Reference NO 7

http://pivotallabs.com/using-mysql-foreign-keys-procedures-and-triggers-with-rails/

Reference NO 8

http://connect.microsoft.com/SQLServer/feedback/details/676293/after-trigger-on-table-with-a-foreign-key-relationship-and-cascading-delete-showing-an-error-message