Why to extend names of foreign keys. We can keep domain for both the tables same. Like this:

Department

=========

Dept_ID (PK)

DName

Employee

=======

ID (PK)

Name

Dept_ID (FK)

Here Dept_ID in Employee table is a foreign key to Dept_ID in Department table.

Suggestions/Comments most welcomed.

- Lokesh