Answer / arun anoop m

1)1NF
->it has a primary key.
->Each column is atomic.
2)2NF
->It is in 1NF
-> Every non-key column is fully functinally dependend on
primary key.
3)3NF
->It is in 2NF
->Every non-key column is functinally dependend only on
primary key.
->non-key column cant be dependend on another non-key colum.

Suggest a method of joining two tables.

0 Answers   Ernst Young, Thomson Reuters,

---

What is the difference between composite index and covering index?

0 Answers  

---

How to modify existing triggers using "alter trigger"?

0 Answers  

---

Can you create a logon trigger in sql server 2005 express edition?

0 Answers  

---

What do I need to start working with sql studio? : sql server management studio

0 Answers  

---

---

What are the properties of the transactions?

0 Answers  

---

Characterize join and name diverse sorts of joins?

0 Answers  

---

Where to find ntwdblib.dll version 2000.80.194.0?

0 Answers  

---

Can we rewrite subqueries into simple select statements or with joins? Example?

2 Answers   ASD Lab,

---

Explain the concepts and capabilities of sql server?

0 Answers  

---

What are the system database in sql server 2008?

0 Answers  

---

What do you mean by authentication modes in sql server?

0 Answers  

---