answersLogoWhite

0


Best Answer

Define normalization explain the conditions under which a relation need to be normalized to 2nf and 3nf with the help of an example ?

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is Normalization Explain the condition under which a relation needs to be normalized to 3 NF fro3 2 NF with the help of an example?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is the purpose of using joins in database is normalization the only purpose of it?

The purpose of using Normalization is to avoid the data redundancy in tables. The normalized schema is much faster in performance so you can get a quick response from the database. OLTP database designers follow the Normalization rules but the tables in Data warehousing(OLAP) data bases are in the De normalized form, they won't follow the Normalization technique. For this reason we are using more complex queries in Data warehouses which uses more system resources. Some one might explain you better way......... Thanks Blueberry


Explain physics in relation to matter and energy?

explain how matter and energy are interrelated


Explain the relation between innate behaviors and genetics?

ok


Explain what is meant by repetition of information and inability to represent information Explain why each of these properties may indicate a bad relational database design?

Repetition of Information is a condition in a relational database where the values of one attribute are determined by the values of another attribute in the same relation, and both values are repeated throughout the relation. This is a bad relational database design because it increases the storage required for the relation and it makes updating the relation more difficult. - Inability to represent information is a condition where a relationship exists among only a proper subset of the attributes in a relation. This is bad relational database design because all the unrelated attributes must be filled with null values otherwise a tuple without the unrelated information cannot be inserted into the relation. Regards, Jose Deleep. S


What are the gas laws explain briefly?

Gas laws explain how the property of a gas changes in relation to other properties under varying conditions.


What is the relation between ethics and public relations?

ethics is the core concept of the society need for affection and relation .it explain how human should live in this world.public relation satisfy the same need in professional way.


How to explain environmental theory in relation to internet retailing?

Discus the environmental theory of retailing?


Explain the functions of legments in relation to movement?

free movemnt of bones without dislocaton


Explain s the application of relation and mapping in areas of ICT?

sjhsy umjd


Can you explain Statue law in relation to occupational healh and safety?

Statute law in occupational health and safety refers to regulations and laws enacted by a government that set out the requirements and standards for workplace safety. These laws typically establish the legal obligations of employers to ensure a safe workplace, including guidelines for hazard identification, risk assessment, and worker training. Statute law helps to protect workers from occupational hazards and ensure compliance with safety standards.


Can you explain what pneumonoultramicroscopicsilicovolcanoconiosis is?

It is a condition caused by inhaling dust from a volcanic eruption


How accurate was the transformation of the roman empire in the west?

You need to explain what transformation you refer to. The transformation of the empire in the west relation to what? You also need to explain why it would need to be accurate/inaccurate.