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 are partial, alternate,, artificial, compound and natural key? Partial Key: It is a set of attributes that can uniquely recognize weak entities and that are related to s

er diagram on cosmetics.

What is Derived and stored Attribute? Derived and Stored Attribute - In a few cases, two or more attribute values are associated, for example, Age and BirthDate attributes of a

You are required to write a report which evaluates two of the following issues in relation to your case study database: a. Security issues b. Performance issues c. Backup

Q.   Why would you choose a database system instead of simply storing data in operating system file? Define  at a base concept in details. Sol. Advantages of Database over Fil

What is a super key? A super key is a set of one or more attributes that collectively permits us to recognize uniquely an entity in the entity set.

Benefits of Sequential File Organisation It is quick and efficient when dealing with huge volumes of data that require being processed periodically (batch system). Dra

What are the three data anomalies that are likely to occur as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why not? A

difference between internal schema and external schema in DBMS

All edges of a cube are expanding at a rate of 6 centimeters per second. How fast is the surface area changing when each edge is (a) 2 centimeters and (b) 10 centimeters?