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)

How do I view stored procedures?

543

---

How to select all records from the table?

608

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

809

---

How to take user input in pl sql?

705

---

What is trigger types in sql?

535

---

---

What is foreign key sql?

554

---

Does sql view stored data?

536

---

what is a composite primary key ? : Sql dba

583

---

What is identity column in sql server?

530

---

Can two tables have same primary key?

531

---

How delete all data from all tables in sql?

538

---

What is dialect in sql?

527

---

What is %s in sql?

564

---

What is the difference between microsoft sql and mysql?

512

---

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

547

---