Inheritance, different DataTypes IdentificationUsefulness

Demonstration of inheritance, how a person may be either a Physical person or a Juridical Person.
In both cases it is natural to store Contact information and Notes, while date of birth for instance is only natural to register for a Physical person.
Date of birth is specified as DataType Date.
Note also the use of Essential to specify the most important characteristics of an entity.

Try out this schema now! (please allow a few seconds for your new database to be initialized.)

Person                                   

   Name                                  Essential 

   Physical_person                       Type 

      Date_of_birth                      Date 

      Gender                             Essential 

         Male, Female, Unknown

      Employers                          

         Employment_relationship         RelationMany 

   Juridical_person                      Type 

      RegistrationNumber                 

      Type_of_incorporation              Essential 

         Limited, Partnership

      Employees                          

         Employment_relationship         RelationMany 

   Contact_information                   Many 

      Type_of_contact_information        

         Phone, Mobil_phone, EMail_address, Facsimile

      Value                              

   Note                                  Many 

   Changes                               Log

ER-diagram (beta)

Note that in addition to generation of ER-Diagram the panSL Implementation AgoRapide may also be used to also generate database-schema (SQL) and source code for a variety of programming languages, tools and development architectures.

Last updated 2012-05-02