Answer Posted / amarnath

The formal classifications describing the level of database
normalization in a data model are called Normal Forms (NF)
and the process of doing this is Normalization.

First normal form :
· A table is in first normal form when it contains no
repeating groups.
· The repeating column or fields in an un normalized table
are removed from the table and put in to tables of their own.
· Such a table becomes dependent on the parent table from
which it is derived.
· The key to this table is called concatenated key, with the
key of the parent table forming a part it.

Second normal form:
· A table is in second normal form if all its non_key fields
fully dependent on the whole key.
· This means that each field in a table ,must depend on the
entire key.
· Those that do not depend upon the combination key, are
moved to another table on whose key they depend on.
· Structures which do not contain combination keys are
automatically in second normal form.
Third normal form:
· A table is said to be in third normal form , if all the
non key fields of the table are independent of all other non
key fields of the same table.

How a tablespace is related to data files?

1160

---

Why does Oracle not permit the use of PCTUSED with indexes?

2477

---

How to store pictures on to the database?

1030

---

What are the advantages of oracle?

1066

---

how to join query for one source type is oracle another source type is sql server ?

2475

---

How to build data dictionary view an new database?

1044

---

What are the attributes of cursor?

1104

---

How to retrieve data from an explicit cursor?

1105

---

Explain oracle instance.

1226

---

How to pass parameters to procedures in oracle?

1077

---

Explain do view contain data?

1045

---

How do I connect to oracle?

1075

---

 How to use an oracle sequence generator in a mapping?

1128

---

How to get maxsal , minsal, ename department wise in single query

1599

---

What is Reduced List of Values?

2240

---