Could theoretically be used for administering the hiring process for new positions.
The schema is belived to work best when relatively few persons apply for a position.
Person
Name Essential
Designation / Designations Many
Applicant, Employee, Reference
Address
EMail_address EMail
Education
Responsibilities | Is_responsible_for | _
Position_responsibility RelationMany
Applications | Has_applied | Application_person RelationMany
Evaluations | Is_involved_in | Evaluation_person RelationMany
Position
Name Essential
Responsible_person | Has_responsible_person | _
Position_responsibility RelationOne
Announcements | Has_been_announced | _
Position_announcement RelationMany
Applications | Has_applications | Application_position RelationMany
Announcement
Announced_date Date Essential
Application_limit Date
Position | Is_about | Position_announcement RelationOne Essential
Applications | Has_applications | _
Application_announcement RelationMany
Application
Received_date Date Essential
Applicant | Made_by | Application_person RelationOne Essential
Position | Is_about | Application_position RelationOne Essential
Announcement | Is_about | Application_announcement RelationOne
Evaluations | Has | Evaluation_application RelationMany
Evaluation
Text
Evaluation_date Date Essential
Application | Is_about | Evaluation_application RelationOne
Persons | Involves | Evaluation_person RelationMany Essential
Type_of_evaluation Essential
Evaluation_of_education, Reference, Interview, _
General
Result_evaluation Essential
Nothing, Not_qualified, Qualified, Offered_position, _
Denied_position, Accepted_offer, Hired
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
