Conferences in Research and Practice in Information Technology
  

Online Version - Last Updated - 20 Jan 2012

 

 
Home
 

 
Procedures and Resources for Authors

 
Information and Resources for Volume Editors
 

 
Orders and Subscriptions
 

 
Published Articles

 
Upcoming Volumes
 

 
Contact Us
 

 
Useful External Links
 

 
CRPIT Site Search
 
    

Incorporating Business Requirements and Constraints in Database Conceptual Model

Khan, K.M., Kapurubandara, M. and Chadha, U.

    Entity relationship (ER) approach is predominantly used for conceptual modelling of database systems in terms of entities and their relationships. The approach does not provide sufficient support for incorporating business constraints and their impact on the entity relationships, thus leaving a gap between the requirements elicitation and database implementation. This paper makes an attempt to bridge this gap by proposing a construct that would enable the system architects to illustrate business requirements and constraints at the conceptual model with minimal effort. To do this, we have proposed an approach called attribute-oriented business requirements and constraints (BRCs). We classify five different categories of attribute-oriented BRCs for binary relationships. Based on this approach, we propose a construct to enhance the modelling capabilities and expressiveness of the ER approach without introducing any conflict with the current features. Our main contribution in this paper is a new construct to specify the business rules and constraints along with the systems requirements in database conceptual modelling.
Cite as: Khan, K.M., Kapurubandara, M. and Chadha, U. (2004). Incorporating Business Requirements and Constraints in Database Conceptual Model. In Proc. First Asia-Pacific Conference on Conceptual Modelling (APCCM2004), Dunedin, New Zealand. CRPIT, 31. Hartmann, S. and Roddick, J. F., Eds. ACS. 59-64.
pdf (from crpit.com) pdf (local if available) BibTeX EndNote GS
 

 

ACS Logo© Copyright Australian Computer Society Inc. 2001-2014.
Comments should be sent to the webmaster at crpit@scem.uws.edu.au.
This page last updated 16 Nov 2007