Explain the fourth normal form, Database Management System

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







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
Related Questions
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 The file-based system has some limitations. The limitations are listed as follows: Isolation and separation of data: When the data is

(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

how to implement mid square hashing?

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

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



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

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