An Improved Generic ER Schema for Conceptual Modeling of Information Systems

by   Dhammika Pieris, et al.

The Entity-Relationship (ER) model is widely used for creating ER schemas for modeling application domains in the field of Information Systems development. However, when an ER schema is transformed to a Relational Database Schema (RDS), some important information on the ER schema may not be represented meaningfully on the RDS. This causes a loss of information during the transformation process. Although, several previous researches have proposed solutions to remedy the situation, the problem still exists. Thus, in this on-going research, we wish to improve the proposed solutions and maximize information preservation in the ER to relational transformation process. Cardinality ratio constraints, role names, composite attributes, and certain relationship types are among the information frequently lost in the transformation process. Deficiencies in the ER model and the transformation method seems to cause this situation. We take the view that if the information lost is resolved; a one-to-one mapping should exist from the ER schema to its RDS. We modified the ER model and the transformation algorithm following a heuristic research method with a view to eliminating the deficiencies and thereby achieving a one-to-one mapping. We should show that the mapping exists for any real-world application. We create a generic ER schema - an ER schema that represents any phenomena in symbolic form - and use it to show that a one-to-one mapping exists for any real-world application. In this paper, we explore our generic ER schema and its advantages over its predecessors in view of representing any real-world application.



page 1

page 2

page 3

page 4


ER model Partitioning: Towards Trustworthy Automated Systems Development

In database development, a conceptual model is created, in the form of a...

SkiQL: A Unified Schema Query Language

Most NoSQL systems are schema-on-read: data can be stored without first ...

Graph Based Proactive Secure Decomposition Algorithm for Context Dependent Attribute Based Inference Control Problem

Relational DBMSs continue to dominate the database market, and inference...

Demonstration of a Multiresolution Schema Mapping System

Enterprise databases usually contain large and complex schemas. Authorin...

Toward Co-existing Database Schemas based on Bidirectional Transformation

According to strong demands for rapid and reliable software delivery, co...

Assessing Achievability of Queries and Constraints

Assessing and improving the quality of data in data-intensive systems ar...

Generating Significant Examples for Conceptual Schema Validation

This report bases itself on the idea of using concrete examples to verif...
This week in AI

Get the week's most popular data science and artificial intelligence research sent straight to your inbox every Saturday.