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
Where are the settings stored for each instance in oracle?
Describe varray?
Is there a combination of "like" and "in" in sql?
How to update values on multiple rows in oracle?
What do you mean by a database transaction & what all tcl statements are available in oracle?
What is oracle used for?
What do database buffers contain?
What are the logical operations?
How will you identify oracle database software release?
What are a query and state the different types of queries and their uses?
what is the scenario where you take the database to NoArchivelog mode?
How to end the current transaction in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
How to upsert (update or insert into a table)?
What is the sid in oracle?