Interested to Buy Any Domain ? << Click Here >> for more details...
Explain Normalization concept?
- 2 Answers
- 10269 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 triggers are possible in mysql?
How do I view data in mysql workbench?
Explain TIMESTAMP DEFAULT ?2006:09:02 17:38:44′ ON UPDATE CURRENT_TIMESTAMP.
How do I find users in mysql?
How do I fix a crashed mysql database?
Does insert statement lock the table?
What is mysql primary key?
How do I find the size of a mysql database?
How do I find the database name in mysql?
How do I flush privileges in mysql?
What is mysql used for?
Do while loop in mysql procedure?
-
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)
