Interested to Buy Any Domain ? << Click Here >> for more details...
when normalization is required
- 3 Answers
- 7804 Views
- HCL, I also Faced
- E-Mail Answers
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 |
What is data type in database?
What are the 3 types of behavioral triggers?
What action do you have to perform before retrieving data from the next result set of a stored procedure ?
Why do we use cursors?
how can we find the select statement is indexed or not?
What is gpt format?
Can a trigger call a stored procedure?
What does count (*) mean in sql?
Is left join faster than join?
what is the difference between delete and truncate commands? : Sql dba
Is sql pronounced sequel or sql?
what is meant by DML?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
