Explain 1st, 2nd, 3rd normalization form of data base

Answer Posted / misam ami

1st normal: A relvar is in 1NF if and only if,in every every legal value of that relavar,every tuple contains exactly one value for each attribute.
3rd normal: A relvar is in 3NF if and only if for all time,each tuple consist of a primary key value that identifies some entity,together with a set of zero or more mutually independent attribute values that describes values that describe that entity in some way.

Is This Answer Correct ?    5 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

is there a tool to trace queries, like profiler for sql server?

587


What is a subquery?

609


Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

1856


Does facebook use oracle?

564


What is open database communication (odbc) in oracle?

540






What to do if the binary spfile is wrong for the default instance?

558


What are the limitations oracle database 10g xe?

566


Explain an index?

656


How to apply filtering criteria at group level in oracle?

577


What are the data types in oracle?

548


what is the dual table in oracle?

549


How many data types are supported?

610


How many types of database triggers exist?

564


What is a nvl function? How can it be used?

554


What are the original export and import utilities?

567