Answer Posted / j geor

Database normalization is a technique for designing
relational database tables to minimize duplication of
information and, in so doing, to safeguard the database
against certain types of logical or structural problems,
namely data anomalies.
1NF Eliminate Repeating Groups - Make a separate table for
each set of related attributes, and give each table a
primary key.
2NF Eliminate Redundant Data - If an attribute depends on
only part of a multi-valued key, remove it to a separate table.
3NF Eliminate Columns Not Dependent On Key - If attributes
do not contribute to a description of the key, remove them
to a separate table.
BCNF Boyce-Codd Normal Form - If there are non-trivial
dependencies between candidate key attributes, separate them
out into distinct tables.
4NF Isolate Independent Multiple Relationships - No table
may contain two or more 1:n or n:m relationships that are
not directly related.
5NF Isolate Semantically Related Multiple Relationships -
There may be practical constrains on information that
justify separating logically related many-to-many relationships.
ONF Optimal Normal Form - a model limited to only simple
(elemental) facts, as expressed in Object Role Model notation.
DKNF Domain-Key Normal Form - a model free from all
modification anomalies.

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1064

---

what does the t-sql command ident_current does? : Transact sql

982

---

What are variables in pl sql?

1167

---

Why do you partition data?

1021

---

What is dml statement?

956

---

What is sequence in sql?

1021

---

What is equi join in sql?

1076

---

When do we use triggers?

1080

---

What is compound trigger?

1038

---

How to write html code in pl sql?

1119

---

what is a control file ? : Sql dba

1042

---

explain the delete statements in sql

1060

---

Is time a data type in sql?

909

---

Which normal form is best?

948

---

How many sql statements are used? Define them.

1038

---