Friday, 30 March 2012

DBMS



In DBMS, there could be a question on different steps in normalization and what is achieved at the end of every step in it.You need to be knowing the following things very clearly and without any ambiguity.The question would be based on these terms.

A table is in 1NF if there and no duplicate rows in the table. Each cell is single-valued.

A table is in 2NF if it is in 1NF and if all non-key attributes are dependent on all of the key. A table is in 2NF if it is in 1NF and if it has no partial dependencies

A table is in 3NF if it is in 2NF and if it has no transitive dependencies

A table is in BCNF if it is in 3NF and if every determinant is a candiate key.

A table is in 4NF if it is in BCNF and it it has no multi-valued dependencies.

A table is in 5NF if it is in 4NF and it has no join dependency.

Superkey,Candidate key,Primary key

A superkey is any set of attributes such that the values of the attributes(taken together)uniquely identify one entity in the entity set.

A candidate key is a minimal superkey.

A primary key is one of the candidate keys, designated by the Database designer.



8 comments:

  1. thanks for valuable comments and material

    ReplyDelete
  2. Thanks dev for your valuable comments....

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. I am expecting one Question from this page in UGC, 2014 . Thanx admin :)

    ReplyDelete
  5. where is questions related to DBMS?

    ReplyDelete
  6. Direct Admissions Into Bvsc -2015

    Veterinary science is the application of medical, diagnostic, and therapeutic principles to companion, domestic, exotic, wildlife,
    and production animals.Veterinary schools are distinct to departments of animal science, which usually offer a pre-veterinary school
    and provides graduate veterinary education in disciplines such as microbiology, virology, and molecular biology.

    Contact for more information : 9492066112, 8977368354,040-66443636
    website: www.way2universities.com

    ReplyDelete
  7. very good site for ugc net aspirants. thank you very much :-)

    ReplyDelete