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

Dirty reads-problems of concurrent transactions, Dirty Reads: T10 reads a ... Dirty Reads: T10 reads a value which is updated by T9. This update has not been committed and T9 aborts. T9 T10 Value of x old value = 200

Explain the three data anomalies, What are the three data anomalies that ar... What are the three data anomalies that are similarly to take place as a result of data redundancy?  Can data redundancy be completely eliminated in database approach?  Why or why n

Describe domain constraints, Describe domain constraints. Domain constr... Describe domain constraints. Domain constraints contain entity integrity and referential integrity. The domain is a set of values that might be assigned to an attribute. The en

Explain p command in the respect of qbe, Explain P command in the respect o... Explain P command in the respect of QBE? P: It is the command in which is used to print (logically display) the value of the attribute in whose cell it is writ

Having clause-data manipulation language, Having clause This clause... Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

State the process of inheritance adjustment, Inheritance Adjustment As... Inheritance Adjustment As in object oriented analysis and design terms inheritance defines a relationship between classes, where as one class shares structure or behaviour def

Create database for car application, The Database MySQL scripts cars_f... The Database MySQL scripts cars_for_sale.sql and car_details.sql containing the data to use for this task have been supplied. To complete this task, you need to first create

Define specialisation and generalization in brief, Define Specialisation an... Define Specialisation and generalization in brief? Specialisation / generalization: Generalization or Specialization represents the is a relationship set, an necessary element

Explain the timestamp ordering protocol, Timestamp Ordering Protocol A ... Timestamp Ordering Protocol A timestamp is a tag that can be attached to any transaction or any data item, which indicates a specific time on which the transaction or data item

Case snerio, each publisher has uniqe name a mial addrs are also kept on ea... each publisher has uniqe name a mial addrs are also kept on each pubisher.a publisher publish one book.a book publish y one publisher.book identified by isbn.each book writn by one