On keys and normal forms
β Scribed by Wai Yin Mok
- Publisher
- Elsevier Science
- Year
- 1997
- Tongue
- English
- Weight
- 313 KB
- Volume
- 62
- Category
- Article
- ISSN
- 0020-0190
No coin nor oath required. For personal study only.
β¦ Synopsis
In. this paper, we give a necessary and sufficient condition for a Boyce-Co$d Normal Form (BCNF) relation scheme to be in Fourth Normal Form (4NF). We also give a necessary and sufficient condition for a 4NF relation scheme to be in Projection-Join Normal Form (PJNF). From these results, we derive necessary and sufficient conditions for a BCNF relation scheme to be in PJNF. In addition, we give a less stringent condition for a Third Normal Form (3NF) relation scheme to be in BCNF. Finally, we show that our theorems generalize the results by Date and Fagin (1992).
π SIMILAR VOLUMES
The method of averaging has long been an important method for the analysis of nonlinear systems. One method using normal forms has more recently become a tool in applied mathematics. Both methods convert systems of ordinary differential equations to simpler equations by using a sequence of change of