The category concept: an extension to the entity-relationship model
Data & Knowledge Engineering
A logical design methodology for relational databases using the extended entity-relationship model
ACM Computing Surveys (CSUR)
Polynomial-time implication problems for unary inclusion dependencies
Journal of the ACM (JACM)
Towards a semantic view of an extended entity-relationship model
ACM Transactions on Database Systems (TODS)
Conceptual modelling of database applications using an extended ER model
Data & Knowledge Engineering
The entity-relationship model—toward a unified view of data
ACM Transactions on Database Systems (TODS) - Special issue: papers from the international conference on very large data bases: September 22–24, 1975, Framingham, MA
Multivalued dependencies and a new normal form for relational databases
ACM Transactions on Database Systems (TODS)
Principles of Database Systems
Principles of Database Systems
Fundamentals of Database Systems
Fundamentals of Database Systems
Entity-Relationship Modeling: Foundations of Database Technology
Entity-Relationship Modeling: Foundations of Database Technology
Improving Quality in Conceptual Modelling by the Use of Schema Transformations
ER '96 Proceedings of the 15th International Conference on Conceptual Modeling
Decomposition of a relation scheme into Boyce-Codd Normal Form
ACM SIGACT News
Schema transformations and dependency preservation
AIC'07 Proceedings of the 7th Conference on 7th WSEAS International Conference on Applied Informatics and Communications - Volume 7
Conceptual Modeling: Past, Present and the Continuum of the Future
Conceptual Modeling: Foundations and Applications
| Hi-index | 0.00 |
Quality of a conceptual model can be defined along three dimensions - syntax, semantics and pragmatic. Pragmatic quality has been improved in the literature through schema transformations. We suggest an approach that also improves the semantic quality by schema transformations. A semantic quality parameter 'extent of normalization' is defined. Based on this parameter and functional dependencies from problem domain, a set of rules is suggested to improve a given conceptual model. We also show that relational schema produced after these transformations is normalized up to 3NF at least.