When is a database in 1NF?

Answer

A database is said to be in first normal form, or 1NF if it has a candidate key present.

A default relationaal Database or RDBMS is in 1NF. But, in the first normal form, level of redundancy is too high. 

For a relational schema to be in 1NF, R must ensure that there are no multivalued attributes present. Which means, that all the attributes need to be atomicin the relation R.

All dbms Questions

Ask your interview questions on dbms

Write Your comment or Questions if you want the answers on dbms from dbms Experts
Name* :
Email Id* :
Mob no* :
Question
Or
Comment* :
 





Disclimer: PCDS.CO.IN not responsible for any content, information, data or any feature of website. If you are using this website then its your own responsibility to understand the content of the website

--------- Tutorials ---