What is normalization and types of normalization?
Answer Posted / aa
Normalization is the process of efficiently organizing data
in a database. There are two goals of the normalization
process: eliminating redundant data (for example, storing
the same data in more than one table) and ensuring data
dependencies make sense (only storing related data in a
table). Both of these are worthy goals as they reduce the
amount of space a database consumes and ensure that data is
logically stored.
| Is This Answer Correct ? | 204 Yes | 40 No |
Post New Answer View All Answers
Why do we use procedures in sql?
How much does sql certification cost?
Differentiate between syntax and runtime errors.
Which is faster count (*) or count 1?
Name three sql operations that perform a sort.
How to run sql functions in pl/sql?
What is the use of count (*) in sql?
Is inner join faster than left join?
How many columns should be in an index?
What are triggers in sql?
What is the size of partition table?
What is memory optimized?
Why do we need cursors in pl sql?
Explain ttitle and btitle.
Can we alter stored procedure?