Fourth Normal Form (4NF)

When attributes in a relation have multi-valued dependency, further Normalization to 4NF and 5NF are needed. Let us first find out what multi-valued dependency is.

A multi-valued dependency is a typical type of dependency in which each and every attribute within a relation depends upon the other, yet none of them is a unique primary key.

 

Posted Date: 7/26/2013 6:38:59 AM | Location : United States

Ask an Expert

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

Write discussion on Explain the fourth normal form
Your posts are moderated

Write your message here..

Related Questions

Concurrency control, discuss the purpose of the concurrency control? discuss the purpose of the concurrency control?

Give the relational calculus queries of players in sql, An orchestra databa... An orchestra database consists of the following relations: CONDUCTS (conductor, composition) REQUIRES (composition, Instrument) PLAYS (Player, Instrument) Give the relational

What is a transaction? , What is a transaction ? The Transaction is a un... What is a transaction ? The Transaction is a unit of data processing. For instance, many of the transactions at a bank may be withdrawal or deposit of money; transfer of money f

Describe hashing in dbms, Describe Hashing in DBMS? Hashing: Hashing ... Describe Hashing in DBMS? Hashing: Hashing is a technique to store data within an array so which storing, searching, inserting and deleting data is fast (in theory it's O(1))

What is disadvantage of multiple inheritances, What is disadvantage of mult... What is disadvantage of multiple inheritances? There is potential ambiguity if the similar variable or method can be inherited from more than one superclass.eg: student class m

Describe the ways for selecting data structure, Ways for Selecting Data Str... Ways for Selecting Data Structure Algorithms operate on data structure. Therefore, selection of the best algorithm means selecting the best data structure from whole bunch. Th

Create a customer database and apply queries, For the question given below,... For the question given below, you are required to submit design and implementation documentation as described over the page. Design, implement (in Java), test and document a set of

Hashing techniques, folding method and mid square method using visual basic... folding method and mid square method using visual basic

A set of possible data values is called, A set of possible data values is c... A set of possible data values is called? A set of possible data values is called as domain.

Explain heap file with advantages, Explain heap file with advantages? H... Explain heap file with advantages? Heap File is an unordered set or a group of records, stored on a set of pages. This class gives basic support for inserting, updating, select