Please use this identifier to cite or link to this item:
|Title:||NORMAL FORM FOR ENTITY-RELATIONSHIP DIAGRAMS.||Authors:||Ling, Tok-Wang||Issue Date:||1985||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.||URI:||http://scholarbank.nus.edu.sg/handle/10635/99564||ISBN:||0818606452|
|Appears in Collections:||Staff Publications|
Show full item record
Files in This Item:
There are no files associated with this item.
checked on Feb 16, 2020
Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.