when normalization is required
Answers were Sorted based on User's Feedback
Answer / shahnaz
Normalization is used to improve the performance of database and is applied in the last step of logical database design.The Goal of Normalization is to
1.Eliminate the duplicate data from table
2.Ensure data dependency
we can achieve this by creating multiple tables for each set and by creating primary and foreign keys and building relationship between the newly created tables.
Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / rizwana
To decompose a large relation into two or more relations then we can use normalization
Is This Answer Correct ? | 0 Yes | 0 No |
Is merge a dml statement?
How to run sql commands in sql*plus?
What is loop in pl sql?
Mention what pl/sql package consists of?
HOW TO APPEAR FOR ONLINE EXAMS OF SQL & PL/SQL? WHICH BOOKS WILL BE BETTER FOR REFERENCE TO QUALIFY THESE EXAMS? ARE THERE ANY MODEL PAPERS AVAILABLE IN THE MARKET ABOUT SQL & PLSQL?
what is self join and why is it required? : Sql dba
If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????
What happens if a procedure that updates a column of table X is called in a database trigger of the same table ?
What is a merge query?
write a query to find 4th max salary
What are the types of index in sql?
what are the advantages of sql ? : Sql dba