CoderFunda
  • Home
  • About us
    • Contact Us
    • Disclaimer
    • Privacy Policy
    • About us
  • Home
  • Php
  • HTML
  • CSS
  • JavaScript
    • JavaScript
    • Jquery
    • JqueryUI
    • Stock
  • SQL
  • Vue.Js
  • Python
  • Wordpress
  • C++
    • C++
    • C
  • Laravel
    • Laravel
      • Overview
      • Namespaces
      • Middleware
      • Routing
      • Configuration
      • Application Structure
      • Installation
    • Overview
  • DBMS
    • DBMS
      • PL/SQL
      • SQLite
      • MongoDB
      • Cassandra
      • MySQL
      • Oracle
      • CouchDB
      • Neo4j
      • DB2
      • Quiz
    • Overview
  • Entertainment
    • TV Series Update
    • Movie Review
    • Movie Review
  • More
    • Vue. Js
    • Php Question
    • Php Interview Question
    • Laravel Interview Question
    • SQL Interview Question
    • IAS Interview Question
    • PCS Interview Question
    • Technology
    • Other

08 April, 2022

First Normal Form

 Programing Coderfunda     April 08, 2022     DBMS     No comments   

First Normal Form (1NF)

  • A relation will be 1NF if it contains an atomic value.
  • It states that an attribute of a table cannot hold multiple values. It must hold only The first single-valued attribute.
  • First normal form disallows the multi-valued attribute, composite attribute, and their combinations.

Example: Relation EMPLOYEE is not in 1NF because of the multi-valued attribute EMP_PHONE.

EMPLOYEE table:

EMP_IDEMP_NAMEEMP_PHONEEMP_STATE
14John7272826385,
9064738238
UP
20Harry8574783832Bihar
12Sam7390372389,
8589830302
Punjab

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

EMP_IDEMP_NAMEEMP_PHONEEMP_STATE
14John7272826385UP
14John9064738238UP
20Harry8574783832Bihar
12Sam7390372389Punjab
12Sam8589830302Punjab
    • Share This:  
    •  Facebook
    •  Twitter
    •  Google+
    •  Stumble
    •  Digg
    Email ThisBlogThis!Share to XShare to Facebook
    Newer Post Older Post Home

    0 comments:

    Post a Comment

    Thanks

    Meta

    Popular Posts

    • Writing and debugging Eloquent queries with Tinkerwell
      In this article, let's look into the options that you can use with Tinkerwell to write and debug Eloquent queries easier. The post Wr...
    • Sitaare Zameen Par Full Movie Review
       Here’s a  complete Vue.js tutorial for beginners to master level , structured in a progressive and simple way. It covers all essential topi...
    • The token request was rejected by the remote server
      error:invalid_granterror_description:The token request was rejected by the remote server.error_uri: https://documentation.openiddict.com/err...
    • Vue.js Tutorial
        Vue.js Installation Compatibility Check Before going to install and use Vue.js in your project, you should check the compatibility issues....
    • JqueryUI Tutorial
      JqueryUI Tutorial    JqueryUI is the most popular front end frameworks currently. It is sleek, intuitive, and powerful mobile first fr...

    Categories

    • Ajax (26)
    • Bootstrap (30)
    • DBMS (42)
    • HTML (12)
    • HTML5 (45)
    • JavaScript (10)
    • Jquery (34)
    • Jquery UI (2)
    • JqueryUI (32)
    • Laravel (1017)
    • Laravel Tutorials (23)
    • Laravel-Question (6)
    • Magento (9)
    • Magento 2 (95)
    • MariaDB (1)
    • MySql Tutorial (2)
    • PHP-Interview-Questions (3)
    • Php Question (13)
    • Python (36)
    • RDBMS (13)
    • SQL Tutorial (79)
    • Vue.js Tutorial (69)
    • Wordpress (150)
    • Wordpress Theme (3)
    • codeigniter (108)
    • oops (4)
    • php (853)

    Social Media Links

    • Follow on Twitter
    • Like on Facebook
    • Subscribe on Youtube
    • Follow on Instagram

    Pages

    • Home
    • Contact Us
    • Privacy Policy
    • About us

    Blog Archive

    • July (4)
    • September (100)
    • August (50)
    • July (56)
    • June (46)
    • May (59)
    • April (50)
    • March (60)
    • February (42)
    • January (53)
    • December (58)
    • November (61)
    • October (39)
    • September (36)
    • August (36)
    • July (34)
    • June (34)
    • May (36)
    • April (29)
    • March (82)
    • February (1)
    • January (8)
    • December (14)
    • November (41)
    • October (13)
    • September (5)
    • August (48)
    • July (9)
    • June (6)
    • May (119)
    • April (259)
    • March (122)
    • February (368)
    • January (33)
    • October (2)
    • July (11)
    • June (29)
    • May (25)
    • April (168)
    • March (93)
    • February (60)
    • January (28)
    • December (195)
    • November (24)
    • October (40)
    • September (55)
    • August (6)
    • July (48)
    • May (2)
    • January (2)
    • July (6)
    • June (6)
    • February (17)
    • January (69)
    • December (122)
    • November (56)
    • October (92)
    • September (76)
    • August (6)

    Loading...

    Laravel News

    Loading...

    Copyright © CoderFunda | Powered by Blogger
    Design by Coderfunda | Blogger Theme by Coderfunda | Distributed By Coderfunda