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

What is a primary key, What is a primary key? Primary key is chosen by ... What is a primary key? Primary key is chosen by the database designer as the principal means of identifying an entity in the entity set.

HRM, is Chipo carrying his baby is Chipo carrying his baby

The average amount of their orders , Make SQL statements for the following ... Make SQL statements for the following scenarios. Your response should contain SQL statement, output and any other assumptions you have made to arrive at the answer. For Colorado cu

Sql, sql is relationally complete-justify sql is relationally complete-justify

Complete replication-data replication, Complete replication: It implies ma... Complete replication: It implies maintaining of a whole copy of the database at every site. Thus, the reliability & availability and performance for query response are maximized.

Aggregation, aggregation aggregation

What create when a primary key combined with a foreign key, What will be cr... What will be create when a primary key if combined with a foreign key? A primary key if combined with a foreign key it creates Parent-Child relationship between the tables that

Define two-phase locking protocol, Define two-phase locking protocol. A... Define two-phase locking protocol. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

Reasons for the growing popularity of data mining, Question: Data Minin... Question: Data Mining is the process of extracting knowledge hidden from large volumes of raw data. (a) Using a suitable example, illustrate how Data Mining can be useful t

What is repository?, Problem 1 Why are the operational system keys not ... Problem 1 Why are the operational system keys not recommended for forming data warehouse primary keys? Give any two examples 2 Explain the following performance tuning techn