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

Database for Managers, I have to create a database about anything of my cho... I have to create a database about anything of my choice. It has to contain 4 queries, and 4 forms. It can be anything as simple as a shoe inventory with numbers - is this a service

Explain the data access protocol, (a) Explain the three types of potentia... (a) Explain the three types of potential mistake which could occur if concurrency control is not properly enforced in the database system. Support your answer with appropriate ex

Need for client server computing, Need for Client Server Computing- Client/... Need for Client Server Computing- Client/Server (C/S) architecture includes running the application on multiple machines in which every machine with its component software tackles

What is a homogeneous distributed database, What is a homogeneous distribut... What is a homogeneous distributed database? In homogeneous distributed databases, all sites have the same database management system software, are aware of one another, and agr

Single valued normalisation, Single Valued Normalisation  Codd in the y... Single Valued Normalisation  Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati

Er model, explain the steps for reduction of er model into relational model... explain the steps for reduction of er model into relational model?

Data base model, why are older data base model are being replaced by new da... why are older data base model are being replaced by new data model

Consistency, what do you mean by consistency in rdbms? what do you mean by consistency in rdbms?

Create a subroutine, 1. Create a subroutine that does the remote blast on t... 1. Create a subroutine that does the remote blast on the file protein.fa. 2. Pass that returned files from the blast to another subroutine that parses the output and sends it to

Which data manipulation command combines the records, Which data manipulati... Which data manipulation command combines the records from one or more tables ? JOIN data manipulation command combines the records from one or more tables.