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
What are the two distinct aspects to the implementation of associations? i) It is required to define data declarations which will enable details of actual links to be stored. I

What is a checkpoint? List the operations to be performed by the system when a checkpoint is to be taken. What does the recovery system do if there is a crash? There is large n

CREATE TABLE prodtrans ( pno number (4) ptype char (1) CHECK (ptype in ('I','R','S')), qty number (5) FOREIGN KEY pno REFERENCES product (pno) ON DELETE CASCADE);

The Third Normal Form (3NF) Even though, transforming a relation that is not in 2NF into a number of relations that are in 2NF take out many of the anomalies, it does not neces

Determine the Objectives of object oriented design provide an overview of object oriented design; partitioning system to subsystems; describe how a software desig

What is meant by normalization of data? It is a process of examining the given relation schemas based on their Functional Dependencies (FDs) and primary key to achieve the prop


Locks: Serialisabilty is just a test whether a given interleaved schedule is ok or has a concurrency related trouble. Though, it does not make sure that the interleaved concurrent

how to submit answers softcopy

With the help of a diagram defines the typical element modules of a DBMS? The functional elements of a database system can be widely divided into: 1) Storage manager and 2) q