What is a Relational Database | what is relational database with example

What is a Relational Database | what is relational database with example

create database on localhost how to import mysql database importance of database what is a relational database what is relational database with example

What is a Relational Database | what is relational database with example

What is a Relational Database  what is a relational database with example

Introduction:

It was 1970 when E. F. Codd purposed a new term relational database. In a relational database, data is accessed in tables. It based on SQL (Standard Query Language). It was 1970 when E. F. Codd in IBM introduced an organizing relational database management system (RDBMS) in columns and rows. And this organizing table consists of relation, attributes, row, tuple, foreign key, and primary key, etc. 

This database is classified into other types. This article will explain all the above information. This article focused on the relational Database management system instead of Database management System. 

RDBMS Rational Database Management System:

Just as a database management system, relational database have own management system, We can define it as “Software, online server or the website used for the management of database is called relational database management system”. It is shown in tabular form.

Structure of RDBMS:

According to the definition, it consists of columns and rows. For example, you have an order-taking company you should be creating a relational Database. You will create four basic columns, Name of customer, Order of customer, the number of products and Address or phone number. Then in rows, you will put information.

Let’s discuss some terminologies:

1. Database store in the table that is called “relation”.
2. Columns are “Field”. Information stores in rows called “record”.
3. The primary key is an identifier key which identify the record,
4. Foreign key act as a bridge and create a link between to tables.

“Domain” is an area of information on the computer. It is used for commercial purposes.

Some most important examples of rational database management systems are given below:

1. MySQL
2. Oracle
3. Microsoft Access
4. MS SQL server
5. IBM DB2

These software and websites provide us the opportunity to store rational database

Do you know there is a difference between DBMS and RDBMS?

DBMS and RDBMS are not the same terms but we consider these terms are the same and mix both in exams. 

     So the difference between both DBMS and RDBMS is given below:

DBMS	RDBMS
·         It store information in files.	·         It store information in tables.

Components of the relational database management system:

Each database consists of several components in which it works accurately, easily, and we can manage it. RDBMS also consists of three components:

1. Data structure
2. Data integrity
3. Data Manipulation

Data Structure:

It is the first component of the relational database, and we can define it as “Structure that is designed to store and organize data is called Data Structure”. It includes:

1. Table: It consists of rows and columns; it is the structure of the database.
2. Record: it store information, these are rows of the table.
3. File: it is used in data processing, and used to store all records.
4. Array: It is used to store data; SSDs and HHDs are used to store and describe data.
5. Algorithms: it deals with SQL, to solve problems.

Data Integrity:

It is the second component of RDBMS; it deals with the accuracy and security of data. It includes:

1. Data Encryption
2. Access Control
3. Data Backup
4. Data Validation
5. Input Validation

Data Manipulating:

It is the third component of data, it deals with programing, Or SQL language, it includes:

1. Inserting-Information
2. Deleting-Data
3. Modifying Or Updating data etc.

Advantages of RDB:

1. It stores data in the table.
2. It gives Accuracy feature.
3. It is flexible and can deal with Complex SQL.

Conclusion:

After seeing Structure of RDBMS, Some features of RDBMS, Component of RDBMS and advantages of rational database we can say that it is more easy, flexible and efficient than a simple database. Rational database management system is used in many pharmaceutical and business relating companies. The most important feature of this system is the tabular form, it is easy to use and store accurate data.

Author. Siti R

What is database | What is a DBMS | Importance of a database

What is database | What is a DBMS | Importance of a database

dbms importance of database uses of database what is database what is dbms

What is database | What is a DBMS | Importance of a database

what is database

In this article, I will discuss with details about What is database? what are a DBMS and the importance of a database in our life? I will also discuss with details about the Database Administrator. How to create a database on the Xampp server. Uses of database and many more.

Introduction to the database:

In the age of the 21^st century, networking has been increased, this age have a lot of knowledge, information, and data. To store this data on the computer is called a database. DBMS is a system used to manage data in the computer. Much software, online servers, websites provide Database Management System. This article will explain what is a database, Importance of database, DBMS Database management system, Examples of the database, how to use the database, How to install Xamp server. The database can store all of your information. It is a basic necessity of this IT world.

What is the database?

I have a question for you. How many pictures are saved on your phone? I am Damon sure that your answer will so many. How many contact numbers are saved on your phone? Your answer will the same? It’s a miracle that a simple device can store a lot of information. The database helps to store this information. The database is a set of information stored in a computer or another device is called a database.

Importance of database:

The database plays an important role in our informative life. Let’s consider you are the owner of a company. You want to store information about your customers, clients, employers, products, and profit. Then what will you do? If your answer is copy paper or accounting register like an old concept, then you are 100 years before then the 21^st century. You should be managing a database in your computer, and store all of this information. So in the era of IT database is the basic necessity of any business.

DBMS Database Management system:

DBMS is a system that collects data, store it, update it, and give accessibility. There are many free software and online servers that provide the opportunity to store data.

Some types of database management systems are given below:

1. Rational database
2. Object database
3. Graph database
4. Network database

Examples of database management systems are followings:

1. MySQL
2. SQL server
3. PostgreSQL
4. Microsoft Access
5. dBASE
6. Clipper
7. Oracle
8. Xampp

Database	DBMS
·         It is just information stored on the computer.	·         It gives storage as well as management.

Database Administrator:

A database administrator is a person who performs tasks like installation, configuration, upgrade, administration, monitoring, and maintenance of databases in an organization. He is a person who someone who uses software and programming to store and organize data, such as banking information and all other types of office records.

How to create a database on xampp server:

I will tell you how to download, install, and create a database in xampp server, so let’s start:

       Downloading of Xampp:

1.  

            Click on this link https://www.apachefriends.org/index.html

2. Select your operating system
3. Click on download
4. When .exe file download

Installation of xampp:

1. Double click on .exe file

2. Give access
3. Then just click on next
4. Some checkbox will appear
5. Check all these checkboxes
6. Then click on next and so on.

Apache server:

1. Go to the window search panel
2. Search for “Xampp Controler”
3. Open this controller
4. Start MySQL and Apache

Now, the localhost creates for the storage of your data.

How excel stores data:

1. When we enter information in cells of the worksheet, then they store all of this information.
2. After the formulation
3. Coding
4. And button creating
5. Excel used as a database

Uses of the database:

• Today’s Database is used in micro or mega projects.

• It is using a lot of companies
• This is using in many industries
• It is using at household
• It is using in Libraries, Schools, and Student management system.

Conclusion:

In the end, we can conclude that: in the era of IT database is a basic necessity, it is using form small businesses to megaprojects, and DBMS the database management system provides management of the database. Many software, websites, and online servers provide management of the database.

Feedback is important to me. 

Please don't forget to give me feedback on how you find this article? If this is helpful for you then give a good comment otherwise let me know how I can improve this article? I hope you find something good about this topic of useful content.

Author. Siti R