Explain Normalization concept?
- 2 Answers
- 9288 Views
- Inuva, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / prasadhari_m@yahoo.com
Noramalization is process of desinnig the datamodel to
effentionley store the data in a database. to reduce the
redundancey.
1st normal form : Elimanate repating groups in individual
tables
Create separate table for ecah set of related data
Identify each set of related data with a primary key.
2nd normal form : Create separate tables for sets of values
that apply to multiply records
->relate these tables with a forgien key
3rd normal form : Elimanate fields that do not depend on
the key
| Is This Answer Correct ? | 29 Yes | 2 No |
Answer / neha keshri
The usual approach in normalization in database
applications is to ensure that the data is divided into two
or more tables, such that when the data in one of them is
updated, it does not lead to anamolies of data.
| Is This Answer Correct ? | 5 Yes | 1 No |
How many services is running in sql server?
What is the use of mysql_fetch_array () function in php?
What is database in php mysql?
Which is best pdo or mysqli?
What is the maximum length of a table name, a database name, or a field name in MySQL?
How do I create a database in mysql workbench?
In which language mysql has been written?
What is dbms in mysql?
What is the limit of mysql database?
Is mysql good for big data?
How do you control the max size of a HEAP table?
How to control the max size of a heap table?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
