answersLogoWhite

0

Why is 4NF Useful?

Updated: 9/27/2023
User Avatar

Wiki User

6y ago

Want this question answered?

Be notified when an answer is posted

Add your answer:

Earn +20 pts
Q: Why is 4NF Useful?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Why 4NF is more desirable Normal Form than BCNF?

Because 4nf minimize the redundancy as well as make storage management..


What is 4NF?

a relation R is in 4NF if and only if,whenever there exist a MVD in R, say A->>B, then all attribute of R are also FD on A. C.J Date by zahir shah MSCSype your answer here...


What is the basic purpose of 4NF?

The purpose of 4NF, or the 4th Normal Form, is to remove multivalued dependencies. This means that by adding a new value to the database, multiple other values are not required to maintain consistency.


Why 4NF is preferable then bcnf .with example?

Normalization is a process to reduce the redundancy by removing function dependencies BCNF (Boyece code normal form) has all functional dependencies A to B are trivial of discriminator should be superkey. To get relation in BCNF, Splitting the relation schema not neccessarily preserve all functional dependency, Loss less decomposition and dependency are main points for the normalization sometime, it is not possible to get a BCNF decomposition that is dependency, preserving. While 4NF has very similar definition as BCNF. A relational Schema is in 4NF, if all multivalued dependencies A to B are trivial and determinate A is superkey of schema. If a relational schema is in 4nf, it is already in BCNF. and 4NF decomposition preserve the all functional dependency. so 4NF is preferable than to have BCNF.


What are 4nf and 5nf?

4th and 5th Normal Form - to do with databases. That's all I know sorry.


Different normalisation forms in database?

There are several normal forms are available in DBMS.those are1NF,2NF,3NF,BCNF,4NF,PJNF(project Join),DKNF(Domain Key).


What is the Superlative and comparative to the word useful?

Most useful and more useful.


What is the comparative and superlative forms of useful?

more useful, the most useful


What is a sentence with the word useful?

Computers are so useful to us.Bert is not a very useful person.I find that the phone is a useful invention.Make yourself useful and pass me the spanner.Hopefully these sentences are useful to you.


How are mirrors useful on roads?

how are mirrors useful ? how are mirrors useful ?


What is the Comparitive and superlative of useful?

more useful and most useful


What are the comparative and superlative of useful?

more useful, most useful