Please use this identifier to cite or link to this item:
|Title:||NORMAL FORM FOR ENTITY-RELATIONSHIP DIAGRAMS.|
|Citation:||Ling, Tok-Wang (1985). NORMAL FORM FOR ENTITY-RELATIONSHIP DIAGRAMS. : 24-35. ScholarBank@NUS Repository.|
|Abstract:||A normal form for entity-relationship diagrams and the objectives for such a normal form are presented. A normal form entity-relationship diagram may consist of composite attributes, multivalued attributes, and special types of relationship sets such as existence dependent, identifier dependent, ISA, UNION, INTERSECT, and DECOMPOSE relationships. A comprehensive algorithm is given to translate a normal form entity-relationship diagram to a set of relations. It is shown that all relations generated are either in third normal form or fifth normal form. General guidelines and detailed steps for converting an entity-relationship diagram to a normal form entity-relationship diagram are presented. These steps can also be used as guidelines for designing databases using the entity-relationship approach.|
|Appears in Collections:||Staff Publications|
Show full item record
Files in This Item:
There are no files associated with this item.
checked on Nov 16, 2018
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.