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)

name 3 ways to get an accurate count of the number of records in a table? : Sql dba

1067

---

How to display the current date in sql?

1077

---

What is secondary key?

934

---

What is form and report?

989

---

Why primary key is required?

1006

---

Why stored procedure is faster than query?

1062

---

Can you have more than one key in a database?

937

---

What is sql in java?

1090

---

When is the explicit cursor used ?

1035

---

what is a foreign key ? : Sql dba

1083

---

List the ways to get the count of records in a table?

900

---

Which operator is used in query for pattern matching?

1089

---

Why do we use sqlite?

979

---

How can I make sql query run faster?

1016

---

How to call a javascript function from pl sql?

1143

---