Tutorial

DBMS Tutorial

DBMS Tutorial is an amazing tutorial series to learn about DBMS, its features, SQL queries, ER diagrams, concept of Normalisation etc,DBMS is understands for Database Management system.

FAQ

Most frequent questions and answers

A Database Management System (DBMS) is software designed to store, retrieve, define, and manage data in a database.

Dr E.F. Codd, also known to the world as the ‘Father of Database Management Systems‘ had propounded 12 rules which are in-fact 13 in number.

In 1960, Charles W. Bachman designed the Integrated Database System, the “first” DBMS.

Application of DBMS

SectorUse of DBMS
BankingFor customer information, account activities, payments, deposits, loans, etc.
AirlinesFor reservations and schedule information.
UniversitiesFor student information, course registrations, colleges and grades.
TelecommunicationIt helps to keep call records, monthly bills, maintaining balances, etc.
FinanceFor storing information about stock, sales, and purchases of financial instruments like stocks and bonds.
SalesUse for storing customer, product & sales information.
ManufacturingIt is used for the management of supply chain and for tracking production of items. Inventories status in warehouses.
HR ManagementFor information about employees, salaries, payroll, deduction, generation of paychecks, etc.
Types of Databases

1) Centralized Database.

2) Distributed Database

3) Relational Database.

4) NoSQL Database.

5) Cloud Database. 

6) Object-oriented Databases. 

7) Hierarchical Databases.

8) Network Databases.

As we know both C and C++ are programming languages and used for application development. The main difference between both these languages is C is a procedural programming language and does not support classes and objects, while C++ is a combination of both procedural and object-oriented programming languages.

Advantages of Database Management System
  • Reducing Data Redundancy.
  • Sharing of Data. 
  • Data Integrity.
  • Data Security. 
  • Privacy.
  • Backup and Recovery. 
  • Data Consistency.
Database Management System (DBMS)
  • Introduction.
  • Entity Relationship Model.
  • Relational Model.
  • Relational Algebra.
  • Functional Dependencies.
  • Normalisation.

Using DBMS, we can overcome many problems such as- data redundancy, data inconsistency, easy access, more organized and understandable, and so on. There is the name of some popular Database Management System- MySQL, Oracle, SQL Server, Amazon simple DB (Cloud-based), etc.

trigger is a special type of stored procedure that automatically runs when an event occurs in the database server. DML triggers run when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view.

In a database, a deadlock is a situation in which two or more transactions are waiting for one another to give up locks. For example, Transaction A might hold a lock on some rows in the Accounts table and needs to update some rows in the Orders table to finish.

Have you found this platform useful ?

Don't forget to share with your love one's !

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Accept Read More