I have the need to reduce the number of tables in the database being used as the base for Entity Framework 4.0. So we need to use a single the activity table, for example, even though there are four tables which have entities: Manager, Employee, Department and Division.
The activity table holds the activity_id and activity_description for those four categories even though they have nothing in common. So we are trying to use EF4 to have a single column point to any of four tables, differentiated only by their foreign keys.
Here are sample primary keys for the 4 tables.
Is there a way for EF4 to know that the MAN2011001 is a foreign key to the Managers table?
I am having a hard time with this test since it seems like this will NOT be a normalized database.
Please chime in.