Illustrate the fifth normal form, Database Management System

Fifth Normal Form (5NF)

These relations still have a difficulty. While defining the 4NF we mentioned that all the attributes depend upon each other. Whereas creating the two tables in the 4NF, although we have preserved the dependencies among Vendor Code and Item code in the first table and Vendor Code and Item code in the second table, we have lost the relationship among Item Code and Project No. If there were a primary key then this loss of dependency would not have happened..

 

Posted Date: 7/26/2013 6:39:34 AM | Location : United States







Related Discussions:- Illustrate the fifth normal form, Assignment Help, Ask Question on Illustrate the fifth normal form, Get Answer, Expert's Help, Illustrate the fifth normal form Discussions

Write discussion on Illustrate the fifth normal form
Your posts are moderated
Related Questions
The physical location of a record is determined by which mathematical formula that transforms a file key into a record location? The physical location of a record is determined

Explain the dependency relationship of object oriented A dependency is a relationship which states that a change in specification of one thing can affect another thing, but n

DML Precompiler All the DBMS have two basic sets of Languages - Data Definition Language (DDL) that have the set of commands needed to define the format of the data that is b

Use again the GE Flight Quest Data and build on the work done for homework 1 and 2. The goal is to create a classification model which classifies flights into "on-time" (you can de

What is the difference among a primary index and a secondary index? Primary Index: A primary index is an ordered file whose records are of fixed length along with two fields.

need to get answer for questions 3&4 on this page in part 1

What are the states of transaction? The states of transaction are:- a) Active b) Partially committed c) Failed d) Aborted e )Committed   f) Terminated

what is cascading? what is rollback cascading? please explain in detail


If R1 and R2 are two relations or functions, then the result of R3 = R1 × R2 is the combination of tuples that are in R1 and R2. The product is associative and commutative. Degr