Modifying the Entity relationship modelling notation: towards high\n quality relational databases from better notated ER models

2013/06/21 by Dhammika Pieris, Pieris, Dhammika
Business, Management and Accounting · Computer Science · #Advanced Database Systems and Queries #Business Process Modeling and Analysis #Databases (cs.DB) #FOS: Computer and information sciences #Semantic Web and Ontologies #Service-Oriented Architecture and Web Services

paper · pdf · doi:10.48550/arxiv.1306.5690

openalex publication_date 2013/06/21 · openalex created_date 2023/03/20 · openalex updated_date 2026/07/28

Abstract

The entity relationship modelling using the original ER notation has been\napplauded providing a natural view of data in conceptual modelling of\ninformation systems. However, the current ER to relational model transformation\nalgorithm is known to be insufficient in providing a complete and accurate\nrepresentation of the ER model undertaken for transformation. In an effort to\nderive better transformations from ER models, we have understood that\nmodifications should be introduced to both of the existing transformation\nalgorithm as well as to the ER notation. Introducing some new concepts, we have\nadapted the original ER notation and developed a new transformation algorithm\nbased on the existing one. This paper presents the modified ER notation with an\nER diagram drawn based on the new notation.\n

Related

• A novel ER model to relational model transformation algorithm for semantically clear high quality database design
• An Improved Generic ER Schema for Conceptual Modeling of Information Systems
• ER model Partitioning: Towards Trustworthy Automated Systems Development
• Extending the ER Model to relational Model novel transformation\n Algorithm: transforming relationship Types among Subtypes
• Conceptual Entity-Relationship Model: Underneath the Simplicity and Staticity