Interested to Buy Any Domain ? << Click Here >> for more details...
what is Normalization means..?
- 8 Answers
- 32228 Views
- AZTEC, Bank Of America, Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / shivanibehere
Normalization is a design technique that is widely used as
a guide in designing relational databases. Normalization is
essentially a two step process that puts data into tabular
form by removing repeating groups and then removes
duplicated data from the relational tables.
Normalization theory is based on the concepts of normal
forms. A relational table is said to be a particular normal
form if it satisfied a certain set of constraints. There
are currently five normal forms that have been defined. In
this section, we will cover the first three normal forms
that were defined by E. F. Codd.
Basic Concepts
The goal of normalization is to create a set of relational
tables that are free of redundant data and that can be
consistently and correctly modified. This means that all
tables in a relational database should be in the third
normal form (3NF). A relational table is in 3NF if and only
if all non-key columns are (a) mutually independent and (b)
fully dependent upon the primary key. Mutual independence
means that no non-key column is dependent upon any
combination of the other columns. The first two normal
forms are intermediate steps to achieve the goal of having
all tables in 3NF. In order to better understand the 2NF
and higher forms, it is necessary to understand the
concepts of functional dependencies and lossless
decomposition.
| Is This Answer Correct ? | 26 Yes | 5 No |
Post New Answer View All Answers
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
Why do we need distributed database?
What is sharded database?
What are different types of resources?
What is Data Modelling?
What is Object Oriented model?
Hi, I want do a course in DWH Informatica Administrator and Abinito Administrator please tell me some institute in chennai and i am searching for a job,so please help me and my mail id : satty_rh@yahoo.co.in Thanks, Kumar
What is ole db used for?
how can you perform lookup range in lookup stage expalin in detail?
List some advantages of dbms.
what is the role of auditor in auditing data oriented applications?
Should I store images in database?
Explain data independence & its types.
Is hive a database?
Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.
