DBMS Concepts

DBMS Tutorial Components of DBMS. Applications of DBMS The difference between file system and DBMS. Types of DBMS DBMS Architecture DBMS Schema Three Schema Architecture. DBMS Languages.

DBMS ER Model

ER model: Entity Relationship Diagram (ERD) Components of ER Model. DBMS Generalization, Specialization and Aggregation.

DBMS Relational Model

Codd’s rule of DBMS Relational DBMS concepts Relational Integrity Constraints DBMS keys Convert ER model into Relational model Difference between DBMS and RDBMS Relational Algebra DBMS Joins

DBMS Normalization

Functional Dependency Inference Rules Multivalued Dependency Normalization in DBMS: 1NF, 2NF, 3NF, BCNF and 4NF

DBMS Transaction

What is Transaction? States of transaction ACID Properties in DBMS Concurrent execution and its problems DBMS schedule DBMS Serializability Conflict Serializability View Serializability Deadlock in DBMS Concurrency control Protocols

Difference

Difference between DFD and ERD

Misc

Advantages of DBMS Disadvantages of DBMS Data Models in DBMS Relational Algebra in DBMS Cardinality in DBMS Entity in DBMS Attributes in DBMS Data Independence in DBMS Primary Key in DBMS Foreign Key in DBMS Candidate Key in DBMS Super Key in DBMS Aggregation in DBMS Hashing in DBMS Generalization in DBMS Specialization in DBMS View in DBMS File Organization in DBMS What Is A Cloud Database What Is A Database Levels Of Locking In DBMS What is RDBMS Fragmentation in Distributed DBMS What is Advanced Database Management System Data Abstraction in DBMS Checkpoint In DBMS B Tree in DBMS BCNF in DBMS Advantages of Threaded Binary Tree in DBMS Advantages of Database Management System in DBMS Enforcing Integrity Constraints in DBMS B-Tree Insertion in DBMS B+ Tree in DBMS Advantages of B-Tree in DBMS Types of Data Abstraction in DBMS Levels of Abstraction in DBMS 3- Tier Architecture in DBMS Anomalies in Database Management System Atomicity in Database Management System Characteristics of DBMS DBMS Examples Difference between Relational and Non-Relational Databases Domain Constraints in DBMS Entity and Entity set in DBMS ER Diagram for Banking System in DBMS ER Diagram for Company Database in DBMS ER Diagram for School Management System in DBMS ER Diagram for Student Management System in DBMS ER Diagram for University Database in DBMS ER Diagram of Company Database in DBMS Er Diagram Symbols and Notations in DBMS How to draw ER-Diagram in DBMS Integrity Constraints in DBMS Red-Black Tree Deletion in DBMS Red-Black Tree Properties in DBMS Red-Black Tree Visualization in DBMS Redundancy in Database Management System Secondary Key in DBMS Structure of DBMS 2-Tier Architecture in DBMS Advantages and Disadvantages of Binary Search Tree Closure of Functional Dependency in DBMS Consistency in Database Management System Durability in Database Management System ER Diagram for Bank Management System in DBMS ER Diagram for College Management System in DBMS ER Diagram for Hotel Management System in DBMS ER Diagram for Online Shopping ER Diagram for Railway Reservation System ER Diagram for Student Management System in DBMS Isolation in DBMS Lossless Join and Dependency Preserving Decomposition in DBMS Non-Key Attributes in DBMS Data Security Requirements in DBMS DBMS functions and Components What is Homogeneous Database? DBMS Functions and Components Advantages and Disadvantages of Distributed Database Relational Database Schema in DBMS Relational Schema Transaction Processing in DBMS Discriminator in DBMS

Applications of DBMS
2019-07-27 07:32:32

Applications of DBMS

Applications of DBMS: There are various fields where a database management system is used. Following are some applications which make use of the database management system:

Applications of DBMS

1. Railway Reservation System: In the railway reservation system, the database is required to store the record or data of ticket bookings, status about train’s arrival, and departure. Also if trains get late, people get to know it through database update.

2. Library Management System: There are lots of books in the library so; it is tough to store the record of all the books in a register or copy. So, the database management system (DBMS) is used to maintain all the information related to the name of the book, issue date, availability of the book, and its author.

3. Banking: Database management system is used to store the transaction information of the customer in the database.

4. Education Sector: Presently, examinations are conducted online by many colleges and universities.  They manage all examination data through the database management system (DBMS). Inspite that student’s registrations details, grades, courses, fee, attendance, results, etc. all the information is stored in the database.

5. Credit card transactions: Database Management system is used for purchasing on credit cards and generation of monthly statements.

6. Social Media Sites: We all use of social media websites to connect with friends and to share our views with the world. Daily, millions of peoples sign up for these social media accounts like Pinterest, Facebook, Twitter, and Google plus. By the use of the database management system, all the information of users are stored in the database and, we become able to connect with other people. 

7. Telecommunications: Without DBMS any telecommunication company can’t think. The Database management system is necessary for these companies to store the call details and monthly postpaid bills in the database.

8. Finance: The database management system is used for storing information about sales, holding and purchases of financial instruments such as stocks and bonds in a database.

9. Online Shopping: These days, online shopping has become a big trend. No one wants to visit the shop and waste their time. Everyone wants to shop through online shopping websites (such as Amazon, Flipkart, snapdeal) from home. So all the products are sold and added only with the help of the database management system (DBMS). Invoice bills, payments, purchase information all of these are done with the help of DBMS.

10. Human Resource Management: Big firms or companies have many workers or employees working under them. They store information about employee’s salary, tax, and work with the help of database management system (DBMS).

11. Manufacturing: Manufacturing companies make different types of products and sale them on a daily basis. In order to keep the information about their products like bills, purchase of the product, quantity, supply chain management, database management system (DBMS) is used.

12. Airline Reservation System: This system is the same as the railway reservation system. This system also uses a database management system to store the records of flights departure, arrival, and delay status.