VisualBuilder
  Home > Database > Tutorials > First Normal Form - Database Tutorial
Tell a friend
Link to us
Total Members
      Members: 84606
     
Sitemap Forum Chat
Home
Database Tutorial Home
1 . Introduction To Database
2 . Data Models
3 . Three-Schema Architecture of Database Systems
4 . Database System Architectures
5 . Codd\'s Rules for Relational Databases.
6 . Keys in DBMS
7 . Concept of Normalization
8 . First Normal Form
9 . Second Normal Form
10 . Third Normal Form
11 . Boyce-Codd Normal Form(BCNF)
12 . Fourth Normal Form
13 . Fifth Normal Form (Projection-Join Normal Form)
14 . Introduction TO SQL
15 . Transactions in DBMS
16 . Steps to Design Database for a System
 
Database Group Home
Database Discussion
Database Members (489)
Database Resources
Database Source Code (0)
Database Articles (0)
Database Blogs
Database Jobs
Database Components (0)
Database Books
Database Websites (0)
Database News (0)
Database Q & A (14)
- Database Ask Question
- Database Questions
- Database Unanswered Questions
 
GROUPS
.NET
ASP.NET
.NET
C#
ASP
Visual Basic
Java
Java
JSP
EJB
Other
Delphi
C++
Ajax
UML
JavaScript
PHP
Web Design
Web Hosting
SQL Server
Oracle
Project Management
More Groups

 
LEARNING CENTER
TUTORIALS
.NET
.NET Tutorial
ASP Tutorial
ASP.NET Database Tutorial
ASP.NET Development Tips
ASP.Net Security,Internationalisation And Deployment
ASP.NET Server Controls Tips
ASP.NET Tutorial
C Sharp Tutorial
Web Development
Flex Tutorial
HTML Tutorial
Learn AJAX Tutorial
PHP Tutorial
Software Development
Database Tutorial
SQL Tutorial
UML Tutorial
Java
Ant Tutorial
EJB 3 Tutorial
Hibernate Tutorial
Java Tutorial
Java Web Component Tutorial
Java XML Tutorial
JDBC Tutorial
JDK1.5 Tutorial
JSF Tutorial
JSP And J2EE Design Tutorial
JSP Tutorial
Spring Tutorial
Struts Tutorial

RESOURCES
Q & A (432 )
Source Code (3217 )
Articles (11 )
Components (1589 )
News (880 )
Websites (1207 )

SUBMISSIONS
Submit Article
Submit Website
Submit News
Submit Source Code
Submit Component

COMMUNITY
Members Directory
Discussion Forum
Chat

SITE
About Us
Sitemap
Search
Contact Us
Link To Us
Feedback
Tell a Friend
Partners
Advertise


Database Tutorial
 First Normal Form
  << Prev: Concept of Normalization Next: Second Normal Form >>

The only attribute values permitted by 1 NF are single atomic (or indivisible) values. If there is no value present for the column, then it should be denoted as null.


Example to understand 1NF


Lets take an example for the following table data named as Student.
























Student_ID


First_Name


Last_Name


Telephone_No


A102


Ram


Sinha


A103


Tom


Joseph


224-504-2803,
224-728-2403


This table is not in First Normal Form because field Telephone_No containing more than one value. Also the first record is not having any values. To make the table in the first normal form we need to split the A103 rows into two and supply the blank value with null. So the resultant table is as follows:-






























Student_ID


First_Name


Last_Name


Telephone_No


A102


Ram


Sinha


null


A103


Tom


Joseph


224-504-2803


A103


Tom


Joseph


224-728-2403


  << Prev: Concept of Normalization Next: Second Normal Form >>
Database Tutorial Home
Give feedback and win a prize.

 
   Printer Friendly
   Email to a friend
   Add to my Favourites    
  Download PDF version
   Report Bad Submissions
   Submit Feedback
 
  Delicious   Digg   Technorati   Blink   Furl   Reddit   Newsvine   Google Click each image to add
this page to each site.
 
 
Welcome Guest Signup
MEMBER'S PANEL
EMAIL
PASSWORD
Forgot your password?
New User? Click Here!
 
Resend Activation Email!
 
SEARCH
 
 
LINKS
MSN
Video Surveillance
Skype vs. sipcall
Gift to Pakistan
 
ADVERTISEMENT
 
PARTNER LIST

More
 
 
 

Home | Login | About Us | Contact Us | Privacy Policy | Advertising