Contact Us

About Easik 2.0

A variety of software is available to provide a graphical environment for designing entity-relational diagrams (ERDs), and for translating these into a database description in a database language such as SQL. See http://en.wikipedia.org/wiki/Entity-relationship_model for some examples.

The Easik application implements an enhancement of the ERA design paradigm by using the Sketch Data Model (see next paragraph). The enhancement provides simple and precise expressiveness of constraints, and it automatically enforces constraints in models. The visual design is also cleaner since there are fewer graphical element types than in ERA.

The Sketch Data Model (SkDM) is a new data model under development by Michael Johnson, Robert Rosebrugh and others. It is related to the Entity Relation Attribute (ERA) model and uses the category-theoretic concept of Sketch.

Version 2.0 of Easik adds several new features. With a database connection established, data entry and manipulation via the graphical interface is available. An overview canvass allows several sketches to be edited simultaneously, and provides a simple mechanism for views.

Easik has been developed since 2005 at Mount Allison University under the supervision of Robert Rosebrugh . Programming and design work is by: Rob Fletcher (2005), Kevin Green (2006), Vera Ranieri(2006), Jason Rhinelander (2008), and Andrew Wood (2008).

For the previous version of the project, see Easik-1.0