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
What are the parameters that we can pass through a stored procedure?
What is key preserved table?
What are data pump export and import modes?
How to manage transaction isolation level?
what are actual and formal parameters?
How is it different from a normal table?
How view is different from a table?
How to create a temporary table in oracle?
How to convert numbers to characters in oracle?
What is proxy method?
How to estimate disk space needed for an export job?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
does the query needs a hint to access a materialized view?
How can you use check constraints for self referential integrity?