answersLogoWhite

0

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

13y ago

What else can I help you with?

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


Can you please explain the significance of the keyword "cboueinstnoahbruegmblapp" in relation to your research?

The keyword "cboueinstnoahbruegmblapp" is not significant in relation to my research.


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.


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


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.


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

sjhsy umjd


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.