I want to implement inheritance from a supertype table to a subtype. I know that is in the logical model.
Creating a table for each supertype and subtype and using the subtype's primary key as the primary key of the subtypes the inheritance is implemented BUT it is an overllaped one. What about created a disjoint inheritance? suppose you have an EMPLOYEE supertype, and HOURLY , SALARIED as it's two subclasses.
EMPLOYEE table has employeeID, name, phone
HOURLY table has employeeID, hoursworked
SALARIED table has employeeID, sallary
this model works fine for an overlapped relation(e.g. an employee can be both Hourly-paid and Sallary-paid). But if I want to have a disjoint relation(e.g. an employee can be either HOURLY or SALARIED, but cannot be both).
how can this be implemented in Access?