Answer Posted / arun anoop m
1)1NF
->it has a primary key.
->Each column is atomic.
2)2NF
->It is in 1NF
-> Every non-key column is fully functinally dependend on
primary key.
3)3NF
->It is in 2NF
->Every non-key column is functinally dependend only on
primary key.
->non-key column cant be dependend on another non-key colum.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How to change the data type of an existing column with "alter table" statements in ms sql server?
What do you mean by table and field in sql?
what is bit datatype? : Sql server database administration
What are the different index configurations a table can have?
How to implement service broker?
What are the encryption mechanisms in sql server?
What is a primary key?
What is the difference between Triggers and Stored Procedure?
Write a SQL query to delete a table?
Explain primary key, foreign key and unique key?
Explain different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
why would you use sql agent? : Sql server database administration
Can you please explain the difference between function and stored procedure?
How to provide default values to stored procedure parameters?
Explain optimistic and pessimistic concurrency?
