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.
--- *********************---

What is view? Can we update view

1081

---

what are the other commands to know the structure of table using mysql commands except explain command? : Sql dba

751

---

When are we going to use truncate and delete?

718

---

Explain the types of joins in sql?

737

---

Which join condition can be specified using on clause?

702

---

---

what does myisamchk do? : Sql dba

742

---

What are the commands used in sql?

739

---

how to analyze tables with 'mysqlcheck'? : Sql dba

720

---

Can unique keys be null?

663

---

How can we make an if statement within a select statement?

736

---

What is the purpose of cursors in pl/sql?

798

---

Is inner join same as self join?

787

---

Why is pl sql needed?

678

---

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2299

---

Can we join two tables without common column?

699

---