Answer Posted / vikram

The task of a database designer is to structure the data in
a way that eliminates unnecessary duplication and provides a
rapid search path to all necessary information. The process
of refining tables, keys, columns, and relationships to
create an efficient database is called normalization

because there is no redundant, neglected data and normalized
tables produce rapid, efficient joins.

There are 5 different normalization methods.

First Normal Form (1NF): Each field in a table must contain
different information.

Second Normal Form (2NF): All attributes that are not
dependent upon the primary key in a database table must be
eliminated.

Third Normal Form (3NF): No duplicate information is
permitted. So, for example, if two tables both require a
common field, this common field information should be
separated into a different table.

There are 2 more normalization forms, fourth normal form
(4NF) and fifth normal form (5NF), but they are rarely used.
Normalization makes databases more efficient and easier to
maintain.

Write the fastest query to find out how many rows exist in a table?

1169

---

Where is dbms used?

1126

---

What is dbms and its application?

1052

---

explain detail about ftp in datastage?

2289

---

What are the key features of dbms?

1042

---

How can you log an error to the server event log from a stored procedure?

1171

---

What is the database development process?

1265

---

When installing the datastage7.5x2 edtion iam getting aproblem i.e the cpu count is 2 but the cpu count in installation is one . how can i install in my p.c (system is dual core).

2277

---

In which table collections errors are stored.

2459

---

Explain the cube operator?

1059

---

What is database design and development?

1063

---

State the acid rules?

1179

---

How to generate OIDS

2330

---

Explain the process of the user request and data generating?

1141

---

Explain the role of indexing in databases?

1185

---