Answer / muralidharan

Normalization was introduced in RDBMS by IBM, and the use
of normalization is to check the database consistency of a
table.There are three types of normalization forms
1 First normalization
2.second normalization
3. third normalization

Murlaidharan
dharanmu@yahoo.com

Answer / hari

Normalization is the process of designing a datamodel and
effociently store the data in a database. to reduce the
redundecny.

Answer / nivedita

Normalization is the process of designing a datamodel and
effociently store the data in a databaseFirst normal form
(1NF) lays the groundwork for an organised database design:
Ensure that each table has a primary key: minimal set of
attributes which can uniquely identify a record.

Eliminate repeating groups (categories of data which would
seem to be required a different number of times on
different records) by defining keyed and non-keyed
attributes appropriately.

Atomicity: Each attribute must contain a single value, not
a set of values.

'First normal form' depends on functional dependency
formula f(x)=y. For every value of x there is value for y.
Second normal form
Second normal form (2NF) If a table has a composite key,
all attributes must be related to the whole key:
The database must meet all the requirements of the first
normal form.
The relational schema should not have any partial
functional dependency i.e. No proper subset of the primary
key should derive a functional dependency belonging to the
same schema. For example, consider functional dependencies
FD:{AB->C, A->D, C->D} here AB is the primary key, as A->D
this relational schema is not in 2NF.
Third normal form
Third normal form (3NF) requires that data stored in a
table be dependent only on the primary key, and not on any
other field in the table.
The database must meet all the requirements of the first
and second normal form.
All fields must be directly dependent on the primary key
field. Any field which is dependent on a non-key field
which is in turn dependent on the Primary Key (ie a
transitive dependency) is moved out to a separate database
table.

Answer / jerry joseph

Normalization is the process of removing redundant data and
avoiding anomalies due to updates and delete.

any one can explain Self mapping Delegation Remote Credentials

1 Answers  

---

SYNTAX FOR VIEWS WITH EXAMPLE HOW TO LINK TWO TABLES

1 Answers   Microsoft,

---

i use few third party softwares. they r all having their own databases . but the data is repeated in all these databases - say a person is in all the three databases, but his name is stoared in diff format in all databases i want to create a centralised database ,and i dont want to re-enter the records . using the exisating records how can i build a centralised database?

1 Answers   Fidelity,

---

how would you improve etl (extract, transform, load) throughput?

0 Answers   LinkedIn,

---

What’s the distinction between dropping a info and taking a info offline?

0 Answers  

---

---

what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

---

What are the disadvantages of using the stored procedures?

0 Answers  

---

What is an indice?

0 Answers  

---

You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

0 Answers  

---

Can someone suggest me the best institute to learn SQL Server... I want to gain in depth knowledge on SQL Server Development. I have been to naresh, peers, sql school,mind q systems... Any idea about best faculty....

3 Answers  

---

Explain about Views?

0 Answers   Infosys,

---

Can group functions be mixed with non-group selection fields in ms sql server?

0 Answers  

---