Answer Posted / tumaini katobe

Is the process of assigning attributies to entities or is
the technique of designiing database with the least
redunducy and duplicancy of data.
There are five types of normalization, these are:
First Normal form
Second Normal form
Third Normal form
Fourth Normal form
Firth fourth form

How to return multiple rows from the stored procedure?

1016

---

Why functions are used in sql?

1044

---

What is a loop in sql?

1037

---

What is dense_rank in sql?

1045

---

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1134

---

What is latest version of sql?

1102

---

Where can I learn sql for free?

1049

---

i have 2 table table one 4 columns respective values a1 7,a2 6,a3 8 ,a4 12 & table two 4 colums respective values a1 7,a2 6,a3 8,a4 15.if table one & table two 3 colums same then 4th column values 1)Qes diff >5 then print 5 * diff value 2)Que diff <5 print 5

4099

---

Can we use join in subquery?

1150

---

What is not null in sql?

1109

---

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

1303

---

What mean sql?

1054

---

What are local and global variables and their differences?

1143

---

Can you selectively load only those records that you need? : aql loader

1095

---

What is normalization in sql?

1067

---