An introduction to database systems: vol. I (4th ed.)
An introduction to database systems: vol. I (4th ed.)
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)
On the semantics of the relational data model
SIGMOD '75 Proceedings of the 1975 ACM SIGMOD international conference on Management of data
A unified approach to functional dependencies and relations
SIGMOD '75 Proceedings of the 1975 ACM SIGMOD international conference on Management of data
Computer Database Organization, 2nd Ed
Computer Database Organization, 2nd Ed
Definition of database transactions by the casual user
AFIPS '80 Proceedings of the May 19-22, 1980, national computer conference
| Hi-index | 0.00 |
This paper proposes a semantic approach to data base design in the relational approach. The analysis on entity types, associations and attributes presented may be applied to data base design in other approaches too. Entity types, associations, and attributes in an operational environment are recognized and their semantic properties are studied. The attributes are categorized into simple and repeating, and the associations are categorized into atomic and molecular. Based on the analysis, relation schemas are established for the data base. These relation schemas are mostly in fourth normal form. Further normalization and optimization guarantees that optimal fourth normal form relation schemas are to be obtained. In this paper, the concept of semantically irrelevant functional dependency is also proposed. If this concept is adopted, then we may have a more optimal data model, which is semantically sound, than the optimal fourth normal form data model.