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 are the advantages of using database?

953

---

What is database server and how it works?

958

---

What is aws documentdb?

979

---

What are the disadvantages of views in a database?

971

---

Explain inner and outer joins with examples.

1102

---

how to reject duplicates in source sequential file and if by filter option then where is that filter option in the sequential file.

1515

---

How to shrink a database?

901

---

what is rcp,if rcp disabled what happen?

2137

---

What is database schema name?

965

---

diff b/w inter process and in process

1966

---

Data structure used to implements a menu:

1056

---

Why do we need distributed database?

910

---

can we delete autodiff back up that we have set through sql server agent.

2123

---

Explain various types of locks in a transaction? Which is better and why?

957

---

Should I store images in database?

938

---