First Normal Form in DBMS in Hindi (1NF)

  • First Normal Form in DBMS in Hindi, 1st normal form in hindi, 1nf in hindi,

First Normal Form in DBMS in Hindi,database normalization in hindi pdf, 1nf 2nf 3nf normalization examples in hindi, bcnf in dbms in hindi, functional dependency in dbms in hindi, normalization in database with example tables, types of normalization in dbms, step by step normalization example, 1nf example in hindi,

First Normal Form in DBMS in Hindi (1NF)

  • एक संबंध 1NF होगा यदि इसमें atomic value होता है।
  • यह बताता है कि एक table की attribute कई values नहीं रख सकती है। यह केवल single-valued attribute रखता है।
  • पहला normal form, multi-valued attribute, composite attribute और उनके combinations को अस्वीकार करता है।

Example: multi-valued attribute EMP_PHONE के कारण relation EMPLOYEE 1NF में नहीं है।

EMPLOYEE table:

EMP_ID EMP_NAME EMP_PHONE EMP_STATE
14 John 7272826385,

9064738238

UP
20 Harry 8574783832 Bihar
12 Sam 7390372389,

8589830302

Punjab

The decomposition of the EMPLOYEE table into 1NF has been shown below:

EMP_ID EMP_NAME EMP_PHONE EMP_STATE
14 John 7272826385 UP
14 John 9064738238 UP
20 Harry 8574783832 Bihar
12 Sam 7390372389 Punjab
12 Sam 8589830302 Punjab

 

Leave a Reply

DMCA.com Protection Status