Normalization of Relations with Nulls in Candidate Keys: Traditional and Domain Key Normal Forms

View Sample PDF

Author(s): George C. Philip (University of Wisconsin Oshkosh, USA)
Copyright: 2004
Pages: 13
Source title: Advanced Topics in Database Research, Volume 3
Source Author(s)/Editor(s): Keng Siau (City University of Hong Kong, Hong Kong SAR)
DOI: 10.4018/978-1-59140-255-8.ch007

Keywords: Data Mining and Databases / Databases / Information Science Reference / Library & Information Science

Purchase

View Normalization of Relations with Nulls in Candidate Keys: Traditional and Domain Key Normal Forms on the publisher's website for pricing and purchasing information.

Abstract

This chapter discusses normalization of relations when the candidate keys of a relation have missing information represented by nulls. The chapter shows that problems and confusion can arise in normalizing relations with nulls in candidate keys. Candidate keys with missing information commonly are found in relations that represent information on two entities with a one-to-one relationship between them. The current definition of Boyce-Codd Normal Form (BCNF) is ineffective in identifying poor designs in such relations that may have insertion/deletion anomalies. Domain Key Normal Form (DKNF) also suffers from the same problem. It is shown that the above problem can be corrected by incorporating the concept of entity integrity rule into the definitions of BCNF and DKNF. This chapter also shows that incorporating the entity integrity rule into the definition of either a relation or a candidate key does not provide a satisfactory solution to the problem.

The IRMA Community

Research IRM

Normalization of Relations with Nulls in Candidate Keys: Traditional and Domain Key Normal Forms

Purchase

Abstract

Related Content

IRMA Sponsors