7.4. Categorisation

Categorisation is a process of modelling of a single subtype (or subclass) with a relationship that involves more than one distinct supertype (or superclass). Till now all the relationships that have been discussed, are a single distinct supertype. However, there could be need for modelling a single supertype/subtype relationship with more than one supertype, where the supertypes represent different entity set.

For example, let us assume that a vehicle is purchased in a company for transportation of goods from one department to another. Now, the owner of the vehicle can be a department, an employee or the company itself. This is a case of modelling a single supertype/subtype relationship with more than one supertype, where ...

Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.