panSL main page
All panSL samples
This schema has been made for a sports club where it is desired to register contact information about children and guardians, and to divide the children into various groups.
Note how Access in general is specified as Everyone, meaning that a log in is required in order to use the database. But a child's First name, and information about groups of children is public (accessible anonymously). This makes it feasible to create public links on your ordinary website with non-sensitive information without requiring a log in.
This should increase the take-up rate of your users.
This schema is in real world use.
Guardian| Guardian_child RelationMany GivingOwner Everyone
Member_of| Group_child RelationMany Everyone
Children| Guardian_child RelationMany
Member_of| Group_guardian RelationMany
Administrator_status| Administrator_guardian RelationMany
Members_children| Group_child RelationMany
Members_guardians| Group_guardian RelationMany
Administrators| Administrator_guardian RelationMany GivingAdministrator
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