Matches in SemOpenAlex for { <https://semopenalex.org/work/W2050154246> ?p ?o ?g. }
Showing items 1 to 62 of
62
with 100 items per page.
- W2050154246 endingPage "45" @default.
- W2050154246 startingPage "35" @default.
- W2050154246 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 from your librarian to read this article's full text." @default.
- W2050154246 created "2016-06-24" @default.
- W2050154246 creator A5018090250 @default.
- W2050154246 date "2002-07-01" @default.
- W2050154246 modified "2023-09-23" @default.
- W2050154246 title "Normalization of Relations with Nulls in Candidate Keys" @default.
- W2050154246 doi "https://doi.org/10.4018/jdm.2002070103" @default.
- W2050154246 hasPublicationYear "2002" @default.
- W2050154246 type Work @default.
- W2050154246 sameAs 2050154246 @default.
- W2050154246 citedByCount "2" @default.
- W2050154246 crossrefType "journal-article" @default.
- W2050154246 hasAuthorship W2050154246A5018090250 @default.
- W2050154246 hasConcept C11171543 @default.
- W2050154246 hasConcept C124101348 @default.
- W2050154246 hasConcept C136886441 @default.
- W2050154246 hasConcept C144024400 @default.
- W2050154246 hasConcept C15744967 @default.
- W2050154246 hasConcept C19165224 @default.
- W2050154246 hasConcept C25343380 @default.
- W2050154246 hasConcept C26320393 @default.
- W2050154246 hasConcept C2781140086 @default.
- W2050154246 hasConcept C33762810 @default.
- W2050154246 hasConcept C38652104 @default.
- W2050154246 hasConcept C41008148 @default.
- W2050154246 hasConcept C5655090 @default.
- W2050154246 hasConcept C80444323 @default.
- W2050154246 hasConceptScore W2050154246C11171543 @default.
- W2050154246 hasConceptScore W2050154246C124101348 @default.
- W2050154246 hasConceptScore W2050154246C136886441 @default.
- W2050154246 hasConceptScore W2050154246C144024400 @default.
- W2050154246 hasConceptScore W2050154246C15744967 @default.
- W2050154246 hasConceptScore W2050154246C19165224 @default.
- W2050154246 hasConceptScore W2050154246C25343380 @default.
- W2050154246 hasConceptScore W2050154246C26320393 @default.
- W2050154246 hasConceptScore W2050154246C2781140086 @default.
- W2050154246 hasConceptScore W2050154246C33762810 @default.
- W2050154246 hasConceptScore W2050154246C38652104 @default.
- W2050154246 hasConceptScore W2050154246C41008148 @default.
- W2050154246 hasConceptScore W2050154246C5655090 @default.
- W2050154246 hasConceptScore W2050154246C80444323 @default.
- W2050154246 hasIssue "3" @default.
- W2050154246 hasLocation W20501542461 @default.
- W2050154246 hasOpenAccess W2050154246 @default.
- W2050154246 hasPrimaryLocation W20501542461 @default.
- W2050154246 hasRelatedWork W156498211 @default.
- W2050154246 hasRelatedWork W2002296815 @default.
- W2050154246 hasRelatedWork W2050154246 @default.
- W2050154246 hasRelatedWork W2145346822 @default.
- W2050154246 hasRelatedWork W2166131714 @default.
- W2050154246 hasRelatedWork W2307616866 @default.
- W2050154246 hasRelatedWork W2330963852 @default.
- W2050154246 hasRelatedWork W26271068 @default.
- W2050154246 hasRelatedWork W4240380820 @default.
- W2050154246 hasRelatedWork W64058425 @default.
- W2050154246 hasVolume "13" @default.
- W2050154246 isParatext "false" @default.
- W2050154246 isRetracted "false" @default.
- W2050154246 magId "2050154246" @default.
- W2050154246 workType "article" @default.