Authors: Alankar Kampoowale, Faiz Currim, Girish Mhatre, Nicholas Neidig
Tags: 2010, conceptual modeling
We describe a CASE tool (the CARD system) that allows users to represent and translate ER schemas, along with more advanced cardinality constraints (such as participation, co-occurrence and projection [1]). The CARD system supports previous research that proposes representing constraints at the conceptual design phase [1], and builds upon work presenting a framework for establishing completeness of cardinality and the associated SQL translation [2]. From a teaching perspective, instructors can choose to focus student efforts on data modeling and design, and leave the time-consuming and error-prone aspect of SQL script generation to the CARD system. Graduate-level classes can take advantage of support for more advanced constraints.Read the full paper here: https://link.springer.com/chapter/10.1007/978-3-642-16373-9_31
