when normalization is required

Answer Posted / dhivya

when large amount of data required in database we need to find important data.
In normalization there will be important primary keys that must merge together so that we kind find the relations of the keys.
Eg. trans Id,video,cust ID
cust ID be the primary key in customer table
eg. cust ID, name, address, phone no, mail id 

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a constraint?

574


What are different types of queries in sql?

534


Mention what are different methods to trace the pl/sql code?

570


What is a unique key and primary key and foreign key?

577


How to use distinct and count in sql query? Explain

619






What is a primary key example?

526


What are the 3 types of behavioral triggers?

688


Is nosql faster than sql?

552


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

788


List and explain the different types of join clauses supported in ansi-standard sql?

831


Should I use mbr or gpt?

554


Explain raise_application_error.

651


What are the most important characteristics of pl/sql?

592


What are some predefined exceptions in pl/sql?

562


What is the difference between joins?

546