Welcome to WebmasterServe!

FREE TO JOIN! Join us now to engage in informative and friendly discussions about Webmastering, SEO, SEM, Internet Marketing, Programming, Graphic Design, Online Jobs and more. What are you waiting for? Ready to join our friendly community? It takes just one minute to register.

Dismiss Notice

Join WebmasterServe Forums 
Join the discussion! Have a better idea or an opinion? It takes just one minute to register Click Here to Join

Help Me/Question What Is 1 Nf (normal Form)?

Discussion in 'Database Management' started by steve taylor, Feb 26, 2016.

  1. steve taylor

    Yellow Belt

    Joined:
    Feb 12, 2016
    Messages:
    769
    Ratings:
    +25 / -0
    The first normal form is the first and the simplest type of normalization that can be implemented in a database. The main rules of the first normal forms are :-
    1.Remove duplicate columns from the same table.
    2.Create separate table for each group of related data and each row have unique column (primary key)
     
  2. Prasoon Arora

    Yellow Belt

    Joined:
    Feb 1, 2016
    Messages:
    472
    Ratings:
    +24 / -0
    First normal form sets the fundamental rules for database normalization and relates to a single table within a relational database system. Normalization follows three basic steps, each building on the last.

    Rules for first normal form
    • There are no columns with repeated or similar data
    • Each data item cannot be broken down any further.
    • Each row is unique i.e. it has a primary key
    • Each field has an unique name
     
  3. krishatg

    Yellow Belt

    Joined:
    Jan 16, 2016
    Messages:
    240
    Ratings:
    +14 / -0
    Noramalization is the process of breaking the relation into the smaller relations so as to minimize the problem of redundancy that leads to various types of anamolies..
    Any relation can undergo through 5 normal forms.

    In First normal form it is ensured that every column in a relation is atomic i.e here we remove the repeating groups by:
    1. Dividing a relation into 2 new tables
    2. Each table will have its own primary key.
    3. Remove all the repeating groups from the same table.
     
  4. VIVEK KUMAR

    Yellow Belt

    Joined:
    Mar 8, 2016
    Messages:
    300
    Ratings:
    +2 / -0
    Normalization of the table means remove the redundancy from the table. In first normal form no multi valued attributes are allowed. Example - Multi valued attribute like phone number of the employee. Employee may have more the one phone number so it is the multi valued attribute it is not allowed in first normal form.
     
  5. Swati Mishra

    Yellow Belt

    Joined:
    Dec 28, 2015
    Messages:
    644
    Ratings:
    +105 / -0
    1 normal form is to remove the duplicacy in the table and this is the simple form of normalization
     
  6. saurabh mathur

    Yellow Belt

    Joined:
    Nov 8, 2017
    Messages:
    130
    Ratings:
    +2 / -0
    The 1NF states that no two rows of data must contain repeating groups of information. This means each of the set must have unique value and multiple columns cannot be used to fetch out the same row. Each of the table should be organized into rows and each of the row should have primary key as unique.

    web hosting
     
  7. durgamatha

    Yellow Belt

    Joined:
    Nov 3, 2017
    Messages:
    45
    Ratings:
    +2 / -0
    First normal form (1NF) is a property of a relation in a relational database. A relation is in first normal form if and only if the domain of each attribute contains only atomic values, and the value of each attribute contains only a single value from that domain.
     

Share This Page