Explain Steps of normalization?
Submitted by: AdministratorFirst Normal form
Entities of the table must have unique identifier or entity key.
Second Normal Form
All the attributes of the table must depend on the entity key for that entity.
Third Normal Form
All attributes that are not part of the key must not depend on any other non-key attributes.
Submitted by: Administrator
Entities of the table must have unique identifier or entity key.
Second Normal Form
All the attributes of the table must depend on the entity key for that entity.
Third Normal Form
All attributes that are not part of the key must not depend on any other non-key attributes.
Submitted by: Administrator
Read Online SQL Server Functions Job Interview Questions And Answers
Top SQL Server Functions Questions
☺ | Explain Steps of normalization? |
☺ | What is De-normalization? |
☺ | Explain how DTS is used to extract, transform and consolidate data? |
☺ | Do you know exporting and importing utility? |
☺ | What are scalar functions? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |