Answer Posted / amresh

In simple words process of replacing a relation with more
than one relation so as to come round with problems of bad
database design(i.e redundancy,insertion,updation,deletion
anomalies_---
The three primitive normal forms r
1> 1-nf:asserts that relation with
atomic values.
2> 2-nf:asserts with eliminating partial
dependency.
3> 3-nf:asserts at eliminating
transitive dependency.

What is the difference between specialization and generalization?

1032

---

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

1844

---

What will happen non-clustered index will be created on clustered index?

1047

---

wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..

3096

---

A lowest level of security by most RDBMS is

1180

---

Is hive a database?

949

---

List the properties of a transaction.

1062

---

How default key is different from primary key?

1045

---

what are wrappers and build ups and what it's use?

2166

---

Can we use redis as database?

990

---

A design problem was given in which I was supposed to make a design for the data base for a given problem.

1090

---

define primary key index, bitmap index, hash index,virtual indwx

3319

---

How does database replication work?

1005

---

What is the difference between primary key, foreign key and candidate key?

1112

---

Which database is best to store images?

1047

---