What database is ?

Database 

Database is basically what ? 

As we know that place where our any information or data can be store that place is known as database.

data can be private ('from any company or organization') and public ('like normal people's data on google') . and if database is storing data that means any type of data structure used on that place because it is not possible to store data without schema.

Now , Here we can say that a collection of data structure like -

Array

link list

stack

tree 

list  

tuple

dict etc , make a database which can store data in these data structures. Or we can say when data transfer from client side by these above data structure through any database management application then before reaching to the database it converts in any standard data structure form  like (xml,string,object) for storing into the database.

that was all basic about the database .

database server

Note:- We all used "Microsoft SQL Server" in our college or on our system for learning the SQL(Structure query language) .

It's not a database , it just a user friendly application of that database by which u can easily sent or retrieve data from the database.

that was all about the database . but with database we should also know about the RDBMS which is currently in working.

Database was good in use but it was very slow due to of independent tables . but in relational database we can perform any operation on multiple related table at a time.

RDBMS (Relational Database Management System) : 

DBMS and RDBMS are not the different things but In RDBMS we can design relational database . Now what is relational database is ?

So , don't worry about that because the mean's of relational database is that in which we can connect two tables by using key concept .

let me take and example to explore the relational database.

Suppose , we have create two tables

1. student   -> first table name

    (student_id, student_name) -> column name in student table 

2. Faculty  -> second table name

    (student_id , faculty_name, faculty_id) -> column name in faculty table

In both table we have created a common name called student_id because in relational database common column name is used to concatenate both table to each other and by which we can perform any operation on both table at a time.

If , There is any relation exists in two table into the database and we create at least one common column name then this database is called relational database.

As we know we make tables for storing our data in form of rows and columns but physically into the data structure it can't be store in the form of row and column so, be aware about that table are useful for the client site not for the machine. For machine database schema is required .

Relational database

In the above image u can see by the product_id , customer_id,and by other keys these tables are connected to each other and this combination of table is making a relational database here.

Now, we hope u have a basic idea about the DBMS and RDBMS  after reading this article.