Basics of Database Management System

Data:

Data is a raw and isolated facts about an entity. Most importantly, it is able to recorded.
For example: Text, Audio, Video, Image etc.

Information:

In short Information is a processed, meaning full and usable data.

Data Base:

Database is a collection of similar or related data.
For example: YouTube for video, Instagram for image, Music player for audio etc.

Database Management System:

Database Management System is a software or tools. In addition, it allow to create, manipulate and delete database.
For example: MySQL, Oracle etc.

Why Database is important:

Database overcomes disadvantages of file system.
Disadvantages of file system:
1. Data redundancy: Data redundancy means same data or information present in different file.

2. Data inconsistency: Data redundancy means same data or information present in different file and each information or data having different values.
For example: i=50 in a file and i=5 in another file.

3. Concurrent-access anomalies: It means issue in multiple operations at a time.
4. Difficulty in accessing data.
5. Security problem.
6. Integrity problem.
7. Atomicity problem.

OLAP vs OLTP:

Large database divided into two different parts (OLAP and OLTP) for fast memory access.

Online Analytical Processing (OLAP):

Online Transaction Processing (OLTP):

Applications of database:

E-commerce: Database is used in e-commerce web sites to manage user profile data, order details, sellers details, product details etc.

Banking system: Database is used in banking system to manage customers details (withdraw, deposit, loan etc).

And also used in university, railway, airlines etc.

---

Download Handwritten Notes: Click Me

---

Another Topics of DBMS:
1.Entity Relationship Diagram or ER Diagram
2.Normalization in DBMS

---