wht is normalization?can u explain me in detail?
- 9 Answers
- 16671 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / hari
Normalization is the process of designing the datamodel and
effocientely store the data in database.to reduce the
redundancy.
1Normal form: Elimanate the repeating groups for individual
table
-Create sepeare table for each set of related data
-identify the each set of related data with a primary key
2nd normal form : create separate table for set of values
that apply the multipule records.
--Releate these tables with a forgign key
3rd Normal Form : Eliminate fields that do not depend on
the key
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
List down some advantages of sql stored procedure?
Can sql servers link to other servers?
Define indexes?
What is the Control Flow in SSIS
Why we use functions in sql server?
What are the authentication modes in sql server? How can it be changed?
What is cube dimension? : sql server analysis services, ssas
What is the server name for sql management studio?
What is sql server replication? : sql server replication
What is primary key, unique key, and foreign key?
How do I find the sql server database version?
How does normalization work?
Which language is supported by sql server?
How to download and install the scaled-down database adventureworkslt?
How much memory that we are using in Logshipping Concept?
