Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

What are the parameters that we can pass through a stored procedure?

1047


What is key preserved table?

1001


What are data pump export and import modes?

1048


How to manage transaction isolation level?

981


what are actual and formal parameters?

1097


How is it different from a normal table?

1009


How view is different from a table?

1017


How to create a temporary table in oracle?

1251


How to convert numbers to characters in oracle?

1023


What is proxy method?

959


How to estimate disk space needed for an export job?

1032


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?

1030


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)

2304


does the query needs a hint to access a materialized view?

1844


How can you use check constraints for self referential integrity?

948