A New Approach for Semantic Integrity Constraints Representation in Enhanced Entity-Relationship and Relational Database Schemas
Islam Hassan AlTarawneh · International Journal of Database Theory and Application · 2016
In this paper Semantic-Enhanced Entity Relationship (SEER) and Semantic -Relational Database (SRD) diagrams are proposed.SEER and SRD are extensions of Enhanced Entity Relationship (EER) and Relational Database (RD) diagrams respectively that are based on dealing with Semantic Integrity Constraints.EER and RD do not take semantic constraints in matter.A lots of information are lost because of the shortage of documentations.The proposed SEER and SRD models embed the semantic constraints using a new notations and pseudo code to give a full diagram for a database system.The proposed models handle the documentation shortage problem.