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
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.

is Chipo carrying his baby

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 is relationally complete-justify

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.


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. Ans: Two-phase locking is significance in the context of ensuring that schedules are serializable. The two-phase locking protocol defines a p

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

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