Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization? Explain different levels of
normalization?
- 8 Answers
- 63408 Views
- CG-VAK, Choice Solutions, College School Exams Tests, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / kumaresan chandran
Normalization:
Normalization is the process of designing a data
model to efficiently store data in a database. The end
result is that redundant data is eliminated, and only data
related to the attribute is stored within the table.
First normal form (1NF):
An entity type is in 1NF when it contains no repeating
groups of data.
Second normal form (2NF):
An entity type is in 2NF when it is in 1NF and when all of
its non-key attributes are fully dependent on its primary key.
Third normal form (3NF):
An entity type is in 3NF when it is in 2NF and when all of
its attributes are directly dependent on the primary key.
| Is This Answer Correct ? | 57 Yes | 21 No |
Post New Answer View All Answers
Explain about a primary key?
How to use timestamp datatypes
Who are end users in dbms?
State the acid rules?
How long can an error message be in raiseerror function?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How to combine two function together?
What is database design and development?
Does QTP Support the Propjects which are running in Dot Net? As we are starting with new project in Dot net need to use automation tool?Please advice & let me know what would be the best.
How to customize error conditions.
If a column is an image value type, how you can compare column values? How can you use this column in join clause?
What you can do to remove data from the cache and query plans from memory for testing the performance of a query repeatedly?
What are the 18 schemas?
Can an extended stored procedure be called from inside a user-defined function?
In which table collections errors are stored.
