Dear All,
Database: Oracle Database 11gR2 11.2.0.1
DB Version: SE1
Can we design a database without foreign key constraints? Is it a good design?
Do we face problem in future, if so?
With Foreign Key:
I have one parent table and many child tables.
If I have to delete the parent data? then I need to consider child tables also.
Ex:
Table 1: ENG_BOOK (ISBN(pk), BOOK_DETAIL, DELETE_FLAG)
Table 2: CUSTOMER_ORDER (ORDER_NO(pk), ISBN(fk), QTY, UNIT_PRICE)