Title :
Entity-relationship logical design of database systems: relational normal forms and extended regular ERDs
Author :
Springsteel, Frederick N.
Author_Institution :
Dept. of Comput. Sci., Missouri Univ., Columbia, MO, USA
Abstract :
The design of the logical structure of databases using the entity-relationship (E-R) model is considered. The goal is to focus on E-R conditions for desirable logical design, using an extended translation of the full E-R model into the more easily implementable relational database model; all entity sets in a regular E-R diagram will map to relation schemes that are in the very desirable Boyce-Codd normal form (BCNF). Conditions under which extended E-R relationship sets translate to BCNF schemes are found. These results extend to both types of weak entity sets, subset and dependent entity sets, and contribute to the logical design of robust database systems. An E-R-diagram-based design system currently under development enforces the conditions that ensure BCNF by ensuring extended regularity and other measures of well-behaved E-R models.<>
Keywords :
relational databases; Boyce-Codd normal form; dependent entity sets; extended entity relationship model; extended regular ERDs; logical design; relational normal forms; robust database systems; weak entity sets; Algorithm design and analysis; Buildings; Computer science; Current measurement; Data models; Database systems; Information systems; Instruction sets; Relational databases; Robustness;
Conference_Titel :
System Sciences, 1988. Vol.II. Software Track, Proceedings of the Twenty-First Annual Hawaii International Conference on
Conference_Location :
Kailua-Kona, HI, USA
Print_ISBN :
0-8186-0842-0
DOI :
10.1109/HICSS.1988.11854
