answersLogoWhite

0


Best Answer

Normalization is a process to reduce redundancy.

By using normalization we can easily remove duplicate entries..

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Normalization form in details in points and examples?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Discuss the following concepts of normalization with examples need for normalization first normal form second normal form third normal form?

discussed


What are the examples of normalization upto 3nf?

3rd normal form can remove transitive dependencies. for example, group city and group supervisor are depending on a non.key field group number.


Exaplain three types of normalization with example?

normal form 1 normal form 2 normal form 3


What is bCnf in rdbms?

It is boyce-codd normal form IN NORMALIZATION WHICH SHOULD BE IN 3NF and EVERY DETERMINAT IS A CANDIDATE KEY .


What are the three primary components of a form in Modern database management?

the three forms of database are in normalization called 1NF, 2NF, and 3NF


What is a third normal form?

Third normal form is used to describe a database that has been normalized. Normalization is a process of removing redundant data. A third normal form is a database that has no transitive dependencies and has all the characteristics of the second normal form.


What is 1NF?

Eliminate duplicate columns from the same table. 1NF is a normalization form in which each column in a row contains a single value. "Himanshu Joshi"


1st to 5th normalization form in database?

the inventor of the relational model, introduced the concept of normalization and what we now know as the First Normal Form (1NF) in 1970.[1] Codd went on to define the Second Normal Form (2NF) and Third Normal Form (3NF) in 1971,[2] and Codd and Raymond F. Boyce defined the Boyce-Codd Normal Form (BCNF) in 1974.[3] Informally, a relational database table is often described as "normalized" if it is in the Third Normal Form.[4] Most 3NF tables are free of insertion, update, and deletion anomalies.


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


What are Boiling points and freezing points examples of?

boiling points are when a substance starts to boil. example- water 32degrees F A boiling point is when a liquid evaporates to form a gas. freezing points are when a substance starts to freeze. example- water 212degrees F A liquid freezes to a solid below its freezing point.


Do a plane and a ray intersection form a line?

no 2 points form a line, 3 points form a plane


What is the points to form a line?

two points form a line. (x1,y1)(x2,y2)