Answer Posted / kumaresan chandran

Normalization:
Normalization is the process of designing a data
model to efficiently store data in a database. The end
result is that redundant data is eliminated, and only data
related to the attribute is stored within the table.

First normal form (1NF):
An entity type is in 1NF when it contains no repeating
groups of data.

Second normal form (2NF):
An entity type is in 2NF when it is in 1NF and when all of
its non-key attributes are fully dependent on its primary key.

Third normal form (3NF):
An entity type is in 3NF when it is in 2NF and when all of
its attributes are directly dependent on the primary key.

Explain about the database management systems.

969

---

Who are naive users?

1001

---

How to use online Backups?

2200

---

Explain what a database is?

1046

---

explain detail about ftp in datastage?

2244

---

How you can make a parameterized view?

1012

---

What are the constraints on severity level in raiseerror?

986

---

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 about normal forms?

1056

---

What are the main phases of database development?

980

---

Explain the role of indexing in databases?

1132

---

There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?

2421

---

What is the physical representation for a many-to-many relationship?

1077

---

fact table and dimension table containg one to many relationship or many to one relastionship

2497

---

What are the key features of dbms?

996

---