Answer Posted / murtaza

normalization supports Atomicity which is one of d most impt
property in dbms.atomicity means there should be always one
record in a row.by this we can reduce the redundancy and
maintain consistency. as with this rule we go on normalizing
the tables depending upon the data dependency.
there r mainly 5 level of normalization
1.1NF(SUPPORTS ATOMICITY PROPERTY)
2.2NF(REDUCE REDUNDANCY)
3.3NF(FURTHER NORMALIZE D TABLES ACCORDING TO DATA DEPENDENCY)
4.BOYCE-CODD NF(SUPPORTS TRIVIAL DEPENDENCY)
5.5NF

how will add additional conditions in sql?

1012

---

Explain few examples of stored procedure over triggers?

959

---

can we have a nested transaction? : Sql server database administration

991

---

Explain “row_number()” in sql server with an example?

947

---

What are the new scripting capabilities of ssms? : sql server management studio

1000

---

How to generate create table script on an existing table in ms sql server?

1090

---

We need to perform what steps in the following order to work with a cursor?

1167

---

Why do we use functions?

852

---

Do you know what are the restrictions applicable while creating views? : SQL Server Architecture

945

---

What sql server means?

908

---

What happens when converting big values to integers?

955

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

974

---

What is the difference between SQL notification and SQL invalidation?

1070

---

What is an indice?

982

---

How many databases Microsoft SQL server provides?

1027

---