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.

Ads

Tutorials   
JDBC Video Tutorial: Create, Read, Update and Delete (CRUD) Operation examples JDBC Video tutorial - How to read Data from MySQL Database? JDBC Video tutorial - How to delete Data in a MySQL Database? Solving java.lang.ClassNotFoundException: com.mysql.jdbc.Driver exception JDBC Video tutorial - How to update Data in a MySQL Database? JDBC Video Tutorial- How to insert data into MySQL database table? JDBC Video Tutorial: How to download JDBC Driver for MySQL? JDBC Tutorial - Writing first JDBC example and running in Eclipse Java Cross Join MySQL Database Connectivity Example In Java Change Column Name in MySQL Java Mysql Connection Example JDBC ODBC Connection In Java ResultSet In Java Prepared Statement Example JdbcRowSet interface Java JdbcRowSet Example First Step towards JDBC! JDBC Training, Learn JDBC yourself Jdbc Get Column Names JDBC Example with MySQL JDBC Prepared Statement Update JDBC Prepared Statement Insert JDBC Prepared Statement Example JDBC Prepared statement Close JDBC Prepared Statement Addbatch JDBC Nested Resultset JDBC-Odbc Connection JDBC-Odbc Connectivity JDBC Insert Preparedstatement JDBC Insert Null JDBC Get Metadata JDBC Insert Record Jdbc Insert Statement JDBC Meta Data Get tables Jdbc Mysql Connection String Jdbc Mysql Connection Url JDBC Next Jdbc Get Connection JDBC Get Int JDBC Exception JDBC Get Row Count JDBC Functions JDBC Fetch JDBC Execute Update Example JDBC Execute Statement JDBC Execute Query JDBC Drive For Mysql JDBC Connectivity Code In Java JDBC connection timeout
Ads

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.

Advertisements

Share on Google+Share on Google+

Relational Database Concepts

Posted on: April 13, 2007 If you enjoyed this post then why not add us on Google+? Add us to your Circles

Advertisements

 

Discuss: Relational Database Concepts   View All Comments

Post your Comment


Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
 
 
Comments:6
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

Ads

 

Ads