Answer Posted / rupa

Most often, Databases have bad designs and are not
normalized. This can greatly affect the speed of your
Database. As a general case, learn the 3 Normal Forms and
apply them at all times. The normal forms above 3rd Normal
Form are often called de-normalization forms but what this
really means is that they break some rules to make the
Database faster.

What I suggest is to stick to the 3rd normal form except if
you are a DBA (which means you know subsequent forms and
know what you're doing). Normalization after the 3rd NF is
often done at a later time, not during design.

for more information go Through below link
http://www.serverwatch.com/tutorials/article.php/2175621

Can a primary key be a foreign key?

1022

---

How exception is different from error?

1019

---

Can we use two order by clause in query?

967

---

what is offset-fetch filter in tsql? : Transact sql

949

---

what are the performance and scalability characteristics of mysql? : Sql dba

997

---

How much does sql cost?

1006

---

What is sql profiler in oracle?

1094

---

Does access use sql?

1045

---

Is oracel sql developer written in java?

1108

---

How do you truncate?

907

---

How would you convert date into julian date format?

1006

---

What are the advantages of pl sql?

1122

---

What are sql*plus environment variables?

1095

---

How is data stored in sql?

1061

---

Why query optimization is needed?

930

---