Q:
How to implement a "is a"/generalization relationship in an ERD?
I'm using SQL Server 2005 Developer edition.
ASKED:
Apr 18 2009 2:19 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
A:
RATE THIS ANSWER
0
Click to Vote:
0
Click to Vote:
- 0
0
But if you want to implement it in a database, I think this could be an example:
-Create a table EMPLOYEES, with columns to store all general information for an employee.
-Create a table TEMPORARY_EMPLOYEES, with columns to store information that is specific to temporary employees, such as contract duration or others.
-Create a table PERMANENT_EMPLOYEES with columns to store information that is specific to permanent employees.
But this kind of relations can't be completely enforced by the RDBMS. At most you can define foreign keys to ensure that every permanent and temporary employee exist in the main employees table.
