LogoLogo

Database Management System Last Minute Notes [Part - 1]

Prasun Das| July 1, 2022 at 8:11 PM | 3 minutes Read

What is actually DBMS?


A Database Management System (DBMS) is system software used to manage the organization by storage, access, modification, and integrity of data in a structured database. A DBMS allows end-users to systematically create, read, update and delete data in a database. The DBMS essentially serves as an interface between the database and end-users, ensuring that data is consistently organized and easily accessible.



Why do we need DBMS?


Efficient Data Management

A database is responsible for storing and managing a large amount of data on a daily basis. This would not

be possible using any other conventional tool such as a spreadsheet as they would simply not work.


Improved Data Sharing and Data Security

A proper database management system helps to increase organizational accessibility to

data, which in turn enables the end-users to share the data quickly and effectively across the

whole organization.


Accuracy

A database can be said to be pretty accurate as it has all sorts of built-in constraints, checks etc. This

means that the information available in a database is guaranteed to be correct in the majority of scenarios.


Data Updation Convenience

In a database, it is real easy to update the data using various Data Manipulation languages

(DML) available. One of these languages is SQL.


Effective Data Integration

Implementing a data management system promotes an integrated and efficient picture of an

organization’s operations. It becomes easier to see how processes in one segment of the

organization affect the other segments.





Difference between file management system & DBMS


So, thus we can understand the differences between the traditional file management system & DBMS from the above-mentioned points. Here is a detailed comparison between the two,







Some important terminologies regarding DBMS


Instance

The data stored in a database at a particular moment of time is called an instance of the

database. 


For example, let's say we have a single table employee in the database, today the table

has only like 10 records, so today the instance of the database has those 10 records only. Let's say, we are going to add another 1000 records in this table by tomorrow so the instance of the

database tomorrow will have 1010 records in that table named employee.


Schema

A database schema is a structure that represents the logical representation of the data in a particular database. Schema can be classified into three types: i) Physical Schema, ii) Logical Schema & iii) View Schema.




Database Architecture


A Database Architecture is a simple representation of DBMS design. It helps to design, develop, implement, and maintain the entire database management system. A DBMS architecture allows us to divide the database system into individual components that can be independently modified, replaced and/or altered. 


Database Architecture


This can be classified into 3 types: i) 1-Tier Architecture, ii) 2-Tier Architecture & iii) 3-Tier Architecture.


1-Tier Architecture

i) In this architecture, the database is directly available to the user. 

ii) It means the user can directly sit on the DBMS and uses it. Any kind of changes done here will directly be done on the database itself. It doesn't provide a handy tool for the end-users. 

iii) The 1-Tier architecture is used for the development of the local application, where programmers can directly communicate with the database for a quick response.





2-Tier Architecture


i) The 2-Tier architecture is the same as the basic client-server. In the two-tier architecture, applications on the client end can directly communicate with the database on the server side. For this kind of interaction, one example that we can think of can be JDBC.

ii) The user interfaces and application programs are run on the client side.

iii)The server side is responsible to provide the functionalities like query processing and transaction management.

iv) To communicate with the actual DBMS, the client-side application establishes a connection with the server-side.




3-Tier Architecture


i)The 3-Tier architecture contains another layer between the client and server. In this type of architecture, the client is unable to directly communicate with the server.

ii) The application on the client-end interacts with an application server which further communicates with the database system.

iii) End user has no idea about the existence of the database beyond the application server. The database has no idea about any other user beyond the application.

iv) The 3-Tier architecture is the one that is being used in the majority of large-scale web applications.





In this part we have covered the basics of database management system . In the upcoming part we will cover normalization , SQL , and important interview related questions.

Thanking Snehomoy Maitra for contributing to this blog

#dbms#cheatsheet#computer fundamentals#fundamentals to learn
View Count:4.5k
0

Comments

Similar Articles

Busting myths about web3

WHAT IS WEB3?Web3 is the catch-all term for the vision of an upgraded version of the internet aimed at giving power back to the users. It is truly the......

Cover image

Operating System INTERVIEW QUESTIONS

Operating Systems is one of the core subjects for a computer science student. As such a lot of important questions are asked on this subject in interv......

Cover image

Cloud Computing Cheatsheet

Getting started with cloud computing ?The words "cloud" and "web" will be interchangeable. What kind of business operates today without the internet? ...

Cover image

Software Engineering — SOFTWARE MAINTENANCE [Part-4]

SOFTWARE MAINTENANCE:Software Maintenance can be defined as the process of modifying a software product after its delivery. The main purpose of softwa...

Cover image

Software Engineering — Software Process Activities [Part - 3]

A quick summary upto what we did this far  from this series:Software EngineeringSoftware engineering is a discipline of engineering concerned wit...

Cover image

Understanding Time Complexity with Interview Examples

Introduction:Understanding time complexity of a function is imperative for every programmer to execute a program in the most efficient manner. Time co...

Cover image

Software Engineering — Software Development lifecycle and software process(Part 2)

 Software MethodologyA software methodology (which is also known as software process) is a set of related development Phases that leads to the pr...

Cover image

Software Engineering [Part 1] - Introduction

Software Engineering is a subject that requires when you are a software developer as well as when you are in your college preparing for a semester or ...

Cover image

SQL Interview Questions

Are you getting ready for your SQL developer job interview?You've come to the correct place.This tutorial will assist you in brushing up on your SQL s...

Cover image

SQL CHEATSHEET

Introduction: What is SQL?To understand SQL, we must first understand databases and database management systems (DBMS).Data is essentially a collectio...

Cover image

Computer Networking Cheatsheet (Last Minute Notes)

 Networking: Importance in real life!Using a computer for work, as well as for personal use, ha...

Cover image

Last Minute Preparation Cheat Sheet for Quantitative Aptitude

FORMULA LIST:ALGEBRA :1.Sum of first n natural numbers = n(n+1)/22.Sum of the squares of first n nat...

Cover image

Database Management System Last Minute Notes [Part - 2]

ER-DiagramWhat are ER Models ?An Entity Relationship Diagram (ERD) is a visual representation of dif...

Cover image

C Cheatsheet

C CHEATSHEETINTRODUCTION:C programming language was developed by Dennis Ritchie of Bell Labs in 1972...

Cover image

C Interview Questions — 2022

C is a general purpose high-level language most popular amongst coders, it is the most compatible, e...

Cover image

C++ STL Cheat Sheet

C++ programming language has templates which basically allows functions and classes to work with gen...

Cover image

C++ CHEAT SHEET

C++ was conceived in the late 1970s to overcome the limitations of C. It  is an extension of th...

Cover image

Python [Advanced] Interview Questions — 2022

Interview Questions are a great source to test your knowledge about any specific field. But remember...

Cover image

Basic Python [Core] Interview Questions for Freshers and Short Sample Answers — 2022

The most popular high-level, multipurpose programming language right now is Python.Python supports p...

Cover image

Python Cheat Sheet - Learn the basics of Python

IntroductionPython is a high-level programming language with dynamic binding and high-level inherent...

Cover image

Basic Java Interview Questions for Freshers and Short Sample Answers — 2022

Interview Questions are a great source to test your knowledge about any specific field. But remember...

Cover image

Java OOP Cheat Sheet — A Quick Guide to Object-Oriented Programming in Java

Object-Oriented Programming or better known as OOPs is one of the major pillars of Java that has lev...

Cover image

Learn Java: Basics to Advanced Concepts [Java Cheatsheet]

Java is a high-level programming language known for its robustness, object-oriented nature, enhanced...

Cover image