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
What is temporary table in sql server? Why we use temp table?
What are the different types of replication you can set up in sql server?
What is difference between Datepart() and Datename() in SqlServer?
What does normalization do to data?
what is normalization? : Sql server database administration
If no size is defined while creating the database, what size will the database have?
What is the difference between lock, block and deadlock? : sql server database administration
What is etl - extraction, transformation, and loading?
Why do we backup Active Directory ?
How to use the inserted and deleted pseudo tables?
Write a query to find 5th highest amount paid from the customer table.
What is a non-clustered index?
What is the difference between local and global temporary tables?
What is thr feature of change data capture?
In which tcp/ip port does sql server run? Can it be changed?
