Answer Posted / 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 |
Post New Answer View All Answers
Explain the working of foreign key?
What is attribute indicator in pl sql?
Can we rollback delete command?
How do you drop a trigger?
What is numeric function sql?
How many sql are there?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What does where 1 1 mean in sql?
Explain dml and ddl?
How can we link a sql database to an existing android app?
Is truncate ddl or dml?
Can we use having without group by in sql?
What is the use of procedures?
Can we use ddl statements in stored procedure?
What is sql entity?