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

What information is needed to connect sql*plus an oracle server?

583

---

What is the unique index?

525

---

Explain how can you save or place your msg in a table?

593

---

Is left join same as join?

517

---

What is tuple in sql?

539

---

---

is mysql query is case sensitive? : Sql dba

558

---

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3102

---

How do you take the union of two tables in sql?

511

---

What is a behavioral trigger?

513

---

how to select unique records from a table? : Sql dba

626

---

What is attribute indicator in pl sql?

519

---

Is ms sql is free?

526

---

What is faster join or subquery?

505

---

Is sql injection illegal?

595

---

what are tables and fields? : Sql dba

575

---