In my application employee table has many fields are optional but when present has to be from some other tables, example department-id, the employee can be created with out a department, but when assigning a department it should be a department from DEPARTMENT table. Shall I force the foreign key? though it's nullable. any hidden issues when going for a nullable foreign key? I am using Oracle 10g.