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 does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?
What is the use of pdo?
Can u give the example by taking an unnormalized table and make that 1nf and then 25nf, and then 3 nf?
How do you create a primary key?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
Explain about the architecture of MYSQL?
What is the default password for mysql?
Create table employee (eno int(2),ename varchar(10)) ?
Is mysql a server or database?
What is save point in mysql?
How do I connect to mysql database?
What is the default port for MySQL Server?
What is the default port for mysql and how it can change?
What is a heap table?
How do I know if mysql is installed on windows?