Database Management System

is a software package where you maintain and control the information to run the business and to do the day to day operations in an organized and user friendly method. In the DBMS we can back up the data, implement the security so that certain information can be modified or viewed by certain people working in the organization. In this section we learn the main concepts which we must follow while working in DBMS. 

In simple words, a Database Management System is a Software program which makes the task easier, the task being adding, deleting, modifying and maintain the
information.

Here are some database terms and concepts.

Database Concepts

  1. Data
  2. Databases
  3. Entity, Attribute and Data
  4. Entity Relationships
  5. Data Models

Data
Data is information about some thing. Data gets differed from business to business,FOR EXAMPLE:- For a bus transportation company BUS, DRIVERS, CITY, SEATS OCCUPIED are data, for a computer hardware company MONITOR, CPU, HARD DISK are data.

Databases
Database is an area where you save the data needed to run the business. Database provides the following features like Sharing Data,enforcing Business rules,Data security which can be applied centrally

Entity, Attribute and Data
An Entity is an object which has some attributes, FOR EXAMPLE:- A employee in an organization has a name and a particular Job.Here EMPLOYEE is an ENTITY, NAME and JOB are ATTRIBUTES.
Entity - EMPLOYEE
Attribute - EMP_NAME and JOB
Data - Name of Employee like (Mike Modano) , his Job is like (Marketing).

Entity Relationships
Database contains many Entities (Tables), we can relate an entity to another,FOR EXAMPLE:- In an organization we have many departments and many employees working , here we have two entities one is EMPLOYEE and the other is DEPARTMENT. So how do we relate these two entities?We can RELATE these two entities as:-
In one department there can be many employees.

The relationship between two different entities can be classified as:

1.ONE to ONE example PERSON - PASSPORT ( one individual can have only one passport)

2.ONE to MANY example DEPARTMENT - EMPLOYEE ( In one department there can be many employees working)

3.MANY to MANY example DOCTOR - PATIENT ( A doctor can have many patients and a patient can have many doctors )