Database question

[LilShieste]

It's been a little while since I've created a database from scratch. Can someone tell me how I can implement "IsA hierarchy" (i.e. "Attribute inheritance") in a database?

For example: If Person is a table in the database, employee has an IsA relationship to Person (employee has all of the attributes that person does, and more)

I'm working with MS Access right now, but if someone could let me know how they would implement it in Oracle, it would be just as helpful.


LilShieste

[Athena]

Most relational databases don't support this kind of inheritance. Look for a OO database if you really need it.

[LilShieste]

Ahh, ok. Thanks Athena. I can work around it, it just would have been nicer to have some kind of inheritance.



LilShieste

[ultrafilter]

Undoubtedly, there is a workaround, but it's going to be very complicated. See if you can find an OO database product.