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
What is row level locking?
What are the functions of commit and rollback statements?
What is dump in mysql?
What is acid in mysql?
What are federated tables?
Why use stored procedures in mysql?
How to make a copy values from one column to another in mysql?
What is use command in mysql?
What is data in mysql?
What is append query?
What are the technical features of MySQL?
Can we store videos in mysql database?
Where the database is stored in mysql?
How to display odd rows in student table in mysql?
What are the advantages of MySQL when compared with Oracle?
