Interested to Buy Any Domain ? << Click Here >> for more details...
What is normalization? Explain different levels of
normalization?
- 8 Answers
- 62734 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
What is dbms and its application?
Write short notes on manual refreshes.
How long can an error message be in raiseerror function?
fact table and dimension table containg one to many relationship or many to one relastionship
Explain the role of indexing in databases?
Hi my program is accesing data from two db2 databases.what is the bind card for this program to genarate plan? how to specify the two owners and two qualifiers in bind card
What is a database development?
How to generate OIDS
Explain about normal forms?
Who are end users in dbms?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
How to use online Backups?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
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.
