Interested to Buy Any Domain ? << Click Here >> for more details...
What is better - 2nd Normal form or 3rd normal form? Why?
- 2 Answers
- 11564 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
What do you understand by integration services in sql server?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
Explain what role entity and relationship play in an ER diagram.
How to see the event list of an existing trigger using sys.trigger_events?
What are the different types of collation sensitivity in sql server?
What is bit data type? What's the information that can be stored inside a bit column?
What are partitioned views and distributed partitioned views?
What area unit the various kinds of info compression introduced in sql server 2008?
What is view in sql?
Does sql server 2000 clustering support load balancing?
What is a collation?
Does the order of columns in update statements matter?
What is difference between joins and subqueries?
What do you understand by a view? What does the with check option clause for a view do?
Explain the truncate command? : SQL Server Architecture
