Answer Posted / 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 |
Post New Answer View All Answers
How do I edit a database in mysql workbench?
How many tables we can create in mysql database?
Is mysql deprecated?
What is federated tables in mysql?
What is logs in mysql?
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
In mysql, what is joins? Explain
How do I disable mysql?
In which language it is written?
What is meant by mysqli?
How can I connect mysql database?
can you tell the order of sql select statement? : Mysql dba
What is the phantom problem?
How can you create and drop view in mysql?
What is the purpose of using timestamp data type?