Answer Posted / jasmine

Normalization is a process of designing the table(relation)
with the reduced redundancy and making clear whether the
attributes in a table is depend on the primary key or
dependencies make sense(ie:storing only the related datas
ito the table). This is achieved by normal forms.
Basic types of normal forms are,
1NF-first normal form(Eliminates duplicate or
repeating values)

2NF-second normal form(Eliminates redundant datas in
one or more tables)

3NF-Third normal form(Removing the columns that are
not truely depending on the primary key)

Describe sql comments?

740

---

What is file based approach?

672

---

What is the purpose of the primary key?

768

---

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

3713

---

Explain table and field in sql?

793

---

Name three sql operations that perform a sort.

791

---

What is the difference between python and sql?

721

---

How do you truncate?

674

---

what is 'mysqlshow'? : Sql dba

769

---

How much does sql cost?

749

---

what are integrity rules?

764

---

What are the types of queries in sql?

753

---

Can we join tables without foreign key?

700

---

What is normalisation in sql?

791

---

Can we call stored procedure in function?

720

---