The CARD system

Authors:
Faiz Currim;Nicholas Neidig;Alankar Kampoowalec;Girish Mhatre
Affiliations:
Department of Management Sciences, Tippie College of Business, University of Iowa, Iowa City, IA;-;State Hygienic Lab, University of Iowa, Iowa City, IA;Department of Internal Medicine, Carver College of Medicine, University of Iowa, Iowa City, IA
Venue:
ER'10 Proceedings of the 29th international conference on Conceptual modeling
Year:
2010

Citing 5
Cited 1

Cardinality constraints in semantic data models

Data & Knowledge Engineering
Intelligent database design using the unifying semantic model

Information and Management
The entity-relationship model—toward a unified view of data

ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
A comprehensive framework for modeling set-based business rules during conceptual database design

Information Systems
Modeling Spatial and Temporal Set-Based Constraints During Conceptual Database Design

Information Systems Research

Efficiency frontiers of XML cardinality constraints

Data & Knowledge Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

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.