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

Define aggregate functions, Define Aggregate functions and what aggregate f... Define Aggregate functions and what aggregate functions supported by the MySQL To calculate a summary value from a set of individual values and uses one of the functions known

Limitations of file based system, Limitations of File Based System The... Limitations of File Based System The file-based system has some limitations. The limitations are listed as follows: Isolation and separation of data: When the data is

What is a sub-query, (a) What is a Sub-Query? (b) What is the differen... (a) What is a Sub-Query? (b) What is the difference between a scalar sub-query and a tabular sub-query? (c) Write an equivalent SQL statement to get the Name of Product wh

Hashing, how to implement mid square hashing? how to implement mid square hashing?

Why we use delegation to share implementation, Use Delegation to Share Impl... Use Delegation to Share Implementation The delegation " Delegation comprises of catching an operation on one object and sending it to other object which is part, or related to

Customer service, as a customer service employee, explain five measures you... as a customer service employee, explain five measures you would recommend a displeased student to patronise a school canteen

File and system structure, Hierarchical Hierarchical

Three level architecture, explain external view explain external view

What is a view, What is a view? A view is a logical view on one or more... What is a view? A view is a logical view on one or more tables.  A view on one or more tables i.e., the data from a view is not actually physically kept instead being derived f

What is E-R model, E-R Model This data model is based on real world th... E-R Model This data model is based on real world that consists of basic objects named entities and of relationship among these objects. Entities are illustrated in a database