What is better - 2nd Normal form or 3rd normal form? Why?
- 2 Answers
- 10543 Views
- TCS, TPK, I also Faced
- E-Mail Answers
Answer Posted / pandian s
1.2nd Normal Form is the 'BEST' in real time scenario.
2.But, The 3rd Normal Form is good in theoritical ONLY not
in REAL TIME SCENARIO.
3.The 2nd Normal form tells "Eliminating Redundant of
Data" - The repeatition of data should be in seperate table
and mapped with parent table (PARENT - CHILD Relationship,
What we using in real scenario (Primary Key & Foreign Key).
4.The 3nd Normal form tells "Eliminating Data that is not
part of KEY" - The each and every columns' data should be a
part of KEY.
ie: We have Student(RollNo, StudName, Class, Phone,..)
table. Each columns' data should be referred from KEY
columns.
"RollNo" should be referred from Parent ROLL Table,
"StudName" should be referred from Parent NAME Table,
"Class" should be referred from Parent CLASS Table,
"Phone" should be referred from Parent PHONE Table
Finally, 2nd NF is BETTER than 3rd NF.
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How many types of local tables are there in sql server?
What is snapshot report?
How to create view in stored procedure sql server?
Explain the relational database management system (rdbms)?
What is the difference between varchar and nvarchar?
What are the rendering extensions of ssrs?
Can we use where clause in union?
What does asynchronous call backs means?
your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files? : Sql server administration
as a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this? : Sql server administration
How to write a query with a full outer join in ms sql server?
what information is maintained within the msdb database? : Sql server administration
What is update locks?
Which table keeps information about stored procedures?
What are the types of dml?
