An ameliorated methodology to design normalized relations
- 1 January 2009
- conference paper
- Published by Institute of Electrical and Electronics Engineers (IEEE)
- p. 861-864
Abstract
In database design, the attributes and their functional dependencies are abstracted from the software requirements specification (SRS) by the forward engineering process. The abstracted attributes from a forward engineering process are structured depending on the functional requirements. Then, the database relations are composed, by the related attributes and their functional dependencies, based on the structures defined by Codd. Any random structural composition of relations leads to INSERT, DELETE and UPDATE anomalies. This paper presents a simple methodology that blends the analytical approach and the synthetic approach, to constitute the relations from a set of attributes and minimally covered functional dependencies, through the use of a dependency matrix to get the desired manipulation. The distinct attribute(s) from a set of functional dependencies is identified for a separate relation. All the dependencies are preserved and the lossless join is ensured by the framed algorithm. Further, the Boyce-Codd Normal Form (BCNF) is persuaded on each relation by revamping the determinant attributes to candidatekey.Keywords
This publication has 6 references indexed in Scilit:
- A CAI Tool for the Theory of Relation Normalization2007
- Eliminating process of normalization in relational database design2005
- A simple guide to five normal forms in relational database theoryCommunications of the ACM, 1983
- Synthesizing third normal form relations from functional dependenciesACM Transactions on Database Systems, 1976
- Normalized data base structure1971
- A relational model of data for large shared data banksCommunications of the ACM, 1970