Answer Posted / udhaya kumar

Normal forms in SQL are given below.

First Normal form (1NF): A relation is said to be in 1NF if
it has only single valued attributes, neither repeating nor
arrays are permitted.

Second Normal Form (2NF): A relation is said to be in 2NF if
it is in 1NF and every non key attribute is fully functional
dependent on the primary
key.

Third Normal Form (3NF): We say that a relation is in 3NF if
it is in 2NF and has no transitive dependencies.

Boyce-Codd Normal Form (BCNF): A relation is said to be in
BCNF if and only if every determinant in the relation is a
candidate key.

Fourth Normal Form (4NF): A relation is said to be in 4NF if
it is in BCNF and contains no multi valued attributes.

Fifth Normal Form (5NF): A relation is said to be in 5NF if
and only if every join dependency in relation is implied by
the candidate keys of relation.

Domain-Key Normal Form (DKNF): We say that a relation is in
DKNF if it is free of all modification anomalies. Insertion,
Deletion, and update anomalies come under modification
anomalies.
--- *********************---

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1195

---

how to calculate the difference between two dates? : Sql dba

755

---

Do we need to rebuild index after truncate?

734

---

explain the advantages and disadvantages of stored procedure? : Sql dba

742

---

What is the difference between inner join and outer join?

745

---

What is the difference between distinct and unique in sql?

689

---

Why do we use set serveroutput on?

715

---

Explain the difference between 'between' & 'and' operators in sql

760

---

How many unique keys can a table have?

768

---

What is pl sql architecture?

720

---

What is difference between my sql and sql?

750

---

Why is pl sql used?

722

---

How can use stored procedures in sql?

819

---

what are set operators in sql? : Sql dba

753

---

Is primary key always clustered index?

764

---