Answer / nashiinformaticssolutions

Normalization is the process of organizing data to minimize redundancy and improve data integrity.
Normal Forms:
• 1NF: Eliminate repeating groups, ensure atomicity.
• 2NF: Ensure 1NF and remove partial dependencies.
• 3NF: Ensure 2NF and remove transitive dependencies.
• BCNF: Ensure every determinant is a candidate key.

Answer / glibwaresoftsolutions

Normalization is the process of organizing data to minimize redundancy and improve data integrity.
Normal Forms:
• 1NF: Eliminate repeating groups, ensure atomicity.
• 2NF: Ensure 1NF and remove partial dependencies.
• 3NF: Ensure 2NF and remove transitive dependencies.
• BCNF: Ensure every determinant is a candidate key.

Answer / hr@tgksolutions.com

Normalization is the process of organizing data to minimize redundancy and improve data integrity.
Normal Forms:
• 1NF: Eliminate repeating groups, ensure atomicity.
• 2NF: Ensure 1NF and remove partial dependencies.
• 3NF: Ensure 2NF and remove transitive dependencies.
• BCNF: Ensure every determinant is a candidate key.

How write primary and foreign key relationship between two tables without using constraints? u can use any of procedure/function/trigger and any sql?

1 Answers   Parexel,

---

what are Dynamic SQL statements?

9 Answers  

---

What are the datatypes a available in PL/SQL ?

2 Answers  

---

Can you inner join the same table?

0 Answers  

---

how to findout the 100th maximum salary

28 Answers   Amdocs,

---

---

Can we have exception part in trigger ?

1 Answers  

---

How can we find duplicate records in a table?

0 Answers  

---

Can we connect to postgresql using sql developer?

0 Answers  

---

what is rollback? : Sql dba

0 Answers  

---

Is trigger a stored procedure?

0 Answers  

---

What sql does db2 use?

0 Answers  

---

What is the basic difference between a sql and stored procedure ?

2 Answers   L&T,

---