This content has been marked as final. Show 2 replies
Foreign Key establishes relationship between a primary key or a unique key in the same table or different table.In your example emp table have only composite primary key.that means composite value must unique.so that dept number may or may not unique value.if you try to set foreign key,it will throw error.
ORA-02270: no matching unique or primary key for this column-list
Edited by: Neelan on Jan 1, 2013 10:05 PM
You can do this in Data Modeler by including the foreign key column(s) in the list of columns for the primary key.