Welcome to the InfoSci Platform
Reference Hub1
Normalization of Relations with Nulls in Candidate Keys

Normalization of Relations with Nulls in Candidate Keys

George C. Philip
Copyright: © 2002 |Volume: 13 |Issue: 3 |Pages: 11
ISSN: 1063-8016|EISSN: 1533-8010|ISSN: 1063-8016|EISBN13: 9781615200658|EISSN: 1533-8010|DOI: 10.4018/jdm.2002070103
Cite Article Cite Article

MLA

Philip, George C. "Normalization of Relations with Nulls in Candidate Keys." JDM vol.13, no.3 2002: pp.35-45. http://doi.org/10.4018/jdm.2002070103

APA

Philip, G. C. (2002). Normalization of Relations with Nulls in Candidate Keys. Journal of Database Management (JDM), 13(3), 35-45. http://doi.org/10.4018/jdm.2002070103

Chicago

Philip, George C. "Normalization of Relations with Nulls in Candidate Keys," Journal of Database Management (JDM) 13, no.3: 35-45. http://doi.org/10.4018/jdm.2002070103

Export Reference

Mendeley
Favorite Full-Issue Download

Abstract

This paper discusses normalization of relations when the candidate keys of a relation have missing information represented by nulls. The paper shows that when the missing information is of the type “not applicable” or “does not exist,” problems and confusion can arise in normalizing relations. 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. It is shown that the above problem can be corrected by incorporating the concept of entity integrity rule into the definition of BCNF. This paper 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.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.