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

how to increment dates by 1 in mysql? : Sql dba

936

---

What is the difference between between and in condition operators?

955

---

What is a primary key called that is made up of more than one field?

1300

---

What are the different types of functions in sql?

1014

---

how to add a new column to an existing table in mysql? : Sql dba

1016

---

What is the use of primary key?

968

---

What is sql table?

918

---

How many types of triggers exist in pl/sql?

1022

---

What is a schema? How is it useful in sql servers?

1052

---

What is a boolean in sql?

956

---

What are the different ddl commands in sql?

1083

---

What are triggers and its types?

1004

---

Is natural join and inner join same?

870

---

what is a scheduled jobs or what is a scheduled tasks? : Sql dba

920

---

How do you clear the screen in sql?

1023

---