A CASE tool for conceptual database design

• Main Authors: SIAU, Keng, TAN, Kok Phuang, CHAN, Hock Chuan
• Format: text
• Language: English
• Published: Institutional Knowledge at Singapore Management University 1992
• Subjects: CASE tool; conceptual database modelling; enhanced-ER diagram; Databases and Information Systems; Software Engineering
• Online Access: https://ink.library.smu.edu.sg/sis_research/9663; https://ink.library.smu.edu.sg/context/sis_research/article/10663/viewcontent/PII__0950_5849_92_90120_E.pdf
• Institution: Singapore Management University

The paper describes a Computer Aided Software Engineering (CASE) tool to support conceptual database modelling. One popular approach for conceptual database modelling is use of the Entity-Relationship (ER) model. The paper proposes the use of an Enhanced Entity-Relationship (EER) model for conceptual database modelling. This Enhanced Entity-Relationship model extends the Entity-Relationship model by incorporating the generalization/specialization, aggregation and categorization abstractions. The CASE tool, which is based on the Enhanced Entity-Relationship model, is known as the Enhanced Entity-Relationship Diagrammer (EERD). In addition, the CASE tool supports direct visual query and update based on the EERM.