Answer / ramesh

3NF is morethan enough.

Answer / praveen hattikal

It all depends on users aproach towards data
selec/inserts/updates
... Normelization affects data retrival severely.
we can go up to BCNF

Answer / shwetal

If possible It should be normalize upto BCNF but it completely depends on the data

Answer / jdfiji

dependent on application. Most transactional based
databases require this to avoid duplication etc. However,
OLAP, these type of databases (typically those used in data
warehouses etc.) are not necesarrily normalised as they are
built for performance of querying the data contained within.

If I delete a table and then rollback it, do the index on the table remains? What if I drop the table and roll back?Do index on the table remains? What if I truncate the table and roll back? Do the index on the table remains

2 Answers   Wipro,

---

What happens when my integer identity runs out of scope?

0 Answers  

---

What types of questions are asked in NIC(Natinal Informatics Centre)'s interview?If any one has any information about this,I would be very thankful to him/her.....

0 Answers   NIC,

---

How to tell firebird to only accept conections from xyz host or network?

0 Answers  

---

What is database management definition?

0 Answers  

---

What are Stored Procedures and When would we Use Them?

1 Answers  

---

Explain about the properties of cursors?

0 Answers  

---

From where the Transactions per rollback segment is derived ?

1 Answers  

---

Can A CONTROL BLOCK can sometimes refer to a Basetable ?

1 Answers  

---

Give us a non-computer example of preemptive and non-preemptive scheduling?

0 Answers  

---

What is bcnf?

0 Answers  

---

What are the disadvantages of a query?

0 Answers  

---