Answer Posted / subhash vandewar

Normalizatiin is the scientific method of breaking down
complex table sturcture into simple table structure by
using certain rules.using this method you can reduce
redundency in a table and eliminate the problem of
inconsisteny and disk space usage.

First Normal Form(1NF):
a table is said to be in first normal form when each
cell of the table prcisely contain one value.

Second Normal Form (2NF):
a table is said to be in second normal form when it is
in 1NF and every attribute in the row in functionaly
dependent upon whole key and not just a part of key.
Third Normal Form (3NF):
a table is said to be in second normal form when it is 2NF
and every non key attribute is functionaly dependent only
on the primary key.

Explain about relational database management systems?

966

---

What are the three basic rules which are to be followed for the relational model of the database?

1015

---

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

4008

---

Explain the rollup operator?

1076

---

Explain about the hierarchical model of the database?

1116

---

What are the three types of database design?

1025

---

Explain about query and reporting.

2090

---

On friday, you issued several insert statements using query analyzer. You then verified the data had been correctly entered with a select statement on monday, your users report that the data is not there what happened?

1001

---

Explain about the database management systems.

971

---

Explain the cube operator?

1010

---

How to customize error conditions.

2150

---

Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on

2207

---

explain detail about ftp in datastage?

2244

---

What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?

1017

---

How can you fix a poorly performing query?

1186

---