Answer / swapna

Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminate redundant data (for example, storing the
same data in more than one table) and ensure data
dependencies make sense (only storing related data in a
table). Both of these are worthy goals as they reduce the
amount of space a database consumes and ensure that data is
logically stored.

First normal form (1NF) sets the very basic rules for an
organized database:
? Eliminate duplicative columns from the same table.
? Create separate tables for each group of related data and
identify each row with a unique column or set of columns
(the primary key).
Second normal form (2NF) further addresses the concept of
removing duplicative data:
? Meet all the requirements of the first normal form.
? Remove subsets of data that apply to multiple rows of a
table and place them in separate tables.
? Create relationships between these new tables and their
predecessors through the use of foreign keys.
Third normal form (3NF) goes one large step further:
? Meet all the requirements of the second normal form.
? Remove columns that are not dependent upon the primary
key.
Finally, fourth normal form (4NF) has one additional
requirement:
? Meet all the requirements of the third normal form.
? A relation is in 4NF if it has no multi-valued
dependencies

Answer / asif nadeem

Normalization is simply a process which is use to store
data efficiently on data base but in this it is
underestimated rules that must be performed.
1) Delete the data which repeating again and again
2) Maintain data of rows and columns into their releated
tables and columns.
there are some types of Normalization
1) 1N
2) 2N
3) 3N
4) 4N
1N:it is known as first normalization and in thsi we
transfer data towards the releated columns and subsets in
which data is repeating is deleated
2N:in this form the 1N steps are implimented and after it
data is maintain in the same table and in columns
3N:in this 2N steps are performed and the subsets of
predcessors are deletd or they are arranged into the
different but of same tables, releation ship is built b/w
the data so that it can be easily accessable.
4N:in this type the 3N steps are performed and main thing
which extra in this is no repeated is present in the 4N

What do you mean by recursive stored procedure?

0 Answers  

---

What area unit the various kinds of info compression introduced in sql server 2008?

0 Answers  

---

What is function of ROLLUP ?

0 Answers   HCL,

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

How to enable/disable indexes?

0 Answers  

---

How do I install only the client tools of sql server 2000?

0 Answers  

---

What are the steps to follow to configure SQL*Net?

0 Answers   Tech Mahindra,

---

What is difference between Triggers and store procedure?

2 Answers  

---

how to update a null value field in sql server eg a table contains 3 fields id,name,salary and 3 records salary of 1 record is null i want update the nullfield 111 arun 300 112 ddd 200 113 ttt null i want to update table with add 100 to every record include null after updation the recrds should be 111 arun 400 112 ddd 300 113 ttt 100

6 Answers   ABC, HCL,

---

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

---

what is hash nonclustered index

0 Answers  

---

1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  

---