Home Jdbc Relational Database Concepts
Questions:Ask|Latest


 
 

Share on Google+Share on Google+

Relational Database Concepts

Advertisement
An important part of every business is to keep records. We need to keep records of our customers, the employees of our company, the emails etc.

Relational Database Concepts

     

An important part of every business is to keep records. We need to keep records of our customers, the employees of our company, the emails etc. To keep all the data indivually is quite difficult and hectic job, because whenever if we need the record of a particular customer or an employee we need to search manually. It takes lot of time and still not reliable. Here comes the concept of databases.

What is database?

A database is an organized collection of information. A simple example of a database are like your telephone directory, recipe book etc.
A Relational model is the basis for any relational database management system (RDBMS). A relational model has mainly three components:

  1. A collection of objects or relations,.

  2. Operators that act on the objects or relations.

  3. Data integrity methods.

To design a database we need three things:

  1. Table

  2. Rows

  3. Columns

A table is one of the most important ingredient to design the database. It is also known as a relation, is a two dimensional structure used to hold related information. A database consists of one or more tables.

A table contains rows : Rows is a collection of instance of one thing, such as the information of one employee.

A table contains the columns: Columns contains all the information of a single type. Each column in a table is a category of information referred to as a field.

One item of data, such as single phone number of a person is called as a Data Value.

ACID Properties:

ACID properties are one of the important concept for databases. ACID stands for Atomicity, Consistency, Isolation, and Durability. These properties of a DBMS allow safe sharing of data. Without these properties the inaccuracy in the data will be huge. With the help of the ACID properties the accuracy can be maintained.

Normalization:

Normalization is a design technique which helps the to design the relational databases. Normalization is essentially a two step process that puts data into tabular form by removing redundant data from the relational tables. A basic goal of normalization is to create a set of relational tables that are free of redundant data and the data should be consistent. Normalization has been divided into following forms.

  1. First Normal Form: A relational table, by definition are in first normal form. All values of the columns are atomic. It means that it contains no repeating values.
  2. A relationl table is in second normal form if it is in 1NF and every non- key column is fully dependent upon the primary key.
  3. A relational table is in third normal form (3NF) if it is already in 2NF and every non- key column is non transitively dependent upon its primary key. The advantage of having table in 3NF is that it eliminates redundant data which in turn saves space and reduces manipulation anomalies.
Advertisement

Liked it!  Share this Tutorial


Follow us on Twitter, or add us on Facebook or Google Plus to keep you updated with the recent trends of Java and other open source platforms.

Posted on: April 13, 2007

Ask Questions?    Discuss: Relational Database Concepts   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments
Ayyanarpandian
October 12, 2011
relational database concept

i want detail information
shashikumar
October 17, 2011
database

i doing a project it's frontend will be javascript and backend will be oracle(sql) in this project how to create a database connectivity frontend to backend .and pls send me step by step procedures
divya
January 13, 2012
hiiiiiiiiii

tnx for nice information
k.KARTHIK
February 16, 2012
database

database concepts
lalit
June 27, 2012
java

nice
senthil kumar
September 24, 2012
comments about advertisement still

ofeten i use your site for learning java topics. some times your are posting some hot advertisement still.it disturb me to open your site on office time. so i kindly request u to avoid those type of still to post. advance thanks
DMCA.com