Global Institute Of Management & Technology

(GIMT)

INTRODUCTION ON
TOPIC : DATABASE
MANAGEMENT SYSTEM
BY ARPITA BISWAS
DEPT : CSE,
YEAR : 3rd,
SEMESTER : 6th
REG NO. : 2590100110002 OF 2020-21
ROLL. NO. : 25900120014
SUBJECT : DATABASE MANAGEMENT SYSTEM
SUB CODE : PCC-CS601
 INTRODUCTION
• DATA
• TYPE OF DATA
• STORING DATA IN COMPUTER
• DATABASE
• MANAGEMENT

DATABASE MANAGEMENT SYSTEM(DBMS)

• DBMS
• DATABASE APPLICATIONS

DATA MANIPULATION LANGUAGE((DML)

• DML

CONTENT :
• SQL

DBMS ARCHITECHTURE
• TYPE OF DBMS ARCHITECHTURE
• 1-TIER ARCHITECHTURE
• 2-TIER ARCHITECHTURE
• 3-TIER ARCHITECHTURE

COMPONENTS OF DBMS

TYPE OF DATABASES

ADVANTAGES OF DBMS OVER FILE SYSTEM

REFERENCE

THANK YOU
  DATA : Data are characteristics , usually numerical, that are collected through
observation. In a more technical sense, data is a set of values
of qualitative or quantitative variables about one or more persons or objects, while
a datum (singular of data) is a single value of a single variable.
Example: Name, Address, Zip, SSN are characteristics or information about a
person.
 TYPE OF DATA :
 Unstructured-Data
 Structured – Information (interpreted data – data supplied with semantics)
 STORING DATA IN COMPUTER :
 Data could be stored computers in File System and or Database Management and
 INTRODUCTION : or content management systems.
 Let us focus on File System and Database approaches . Each one has its own
advantages and disadvantages.
 DATABASE : A database is information that is set up for easy access, management
and updating. Computer databases typically store aggregations of data records or files
that contain information, such as sales transactions, customer data, financials and
product information.
Database is a collection of inter-related data which helps in efficient retrieval,
insertion and deletion of data from database and organizes the data in the form of
tables, views, schemas, reports etc. For Example, university database the data
students, faculty, and admin staff etc. which helps in efficient retrieval, insertion and
deletion of data it.
 MANAGEMENT : Generally Management refers create, Retrieve, update and delete.
 DATABASE MANAGEMENT SYSTEM(DBMS) :
 Database Management System : The software  Database Applications:
which is used to manage database is called Database  Banking: transactions
Management System (DBMS). For Example,  Airlines: reservations, schedules
MySQL, Oracle etc. are popular commercial DBMS  Universities: registration, grades
used in different applications.
 Sales: customers, products, purchases
 DBMS allows users the following tasks:  Online retailers: order tracking, customized
 Data Definition: It helps in creation, modification and recommendations
removal of definitions that define the organization of  Manufacturing: production, inventory, orders, supply chain
data in database.
 Human resources: employee records, salaries, tax deductions
 Data Updating : It helps in insertion, modification and  Databases can be very large.
deletion of the actual data in the database.
 Databases touch all aspects of our lives
 Data Retrieval : It helps in retrieval of data from the
 Application(for any university) program examples :
database which can be used by applications for various
purposes.  Add new students, instructors, and courses
 User Administration : It helps in registering and  Register students for courses, and generate class rosters
monitoring users, enforcing data security, monitoring  Assign grades to students, compute grade point averages
performance, maintaining data integrity, dealing with (GPA) and generate transcripts
concurrency control and recovering information  In the early days, database applications were built directly on top
corrupted by unexpected failure. of file systems
 DATA MANIPULATION LANGUAGE ( DML) :
 Language for accessing and  SQL :
manipulating the data organized by the  The most widely used commercial language
appropriate data model  SQL is NOT a Turing machine equivalent
 DML also known as query language language
 Two classes of languages  SQL is NOT a Turing machine equivalent
language
 Pure – Used for proving properties about
computational power and for optimization  To be able to compute complex functions SQL

is usually embedded in some higher-level
Relational Algebra
language
 Tuple relational calculus
 Application programs generally access
 Domain relational calculus databases through one of
 Commercial – Used in commercial systems  Language extensions to allow embedded SQL
 SQL is the most widely used commercial  Application program interface (e.g.,
language . ODBC/JDBC) which allow SQL queries to be
sent to a database .
 DBMS ARCHITECHTURE :
DBMS ARCHITECHTURE :
 1-Tier Architecture :
• The DBMS design depends upon its architecture.  In this architecture, the database is
The basic client/server architecture is used to directly available to the user. It means
deal with a large number of PCs, web servers, the user can directly sit on the DBMS
database servers and other components that are
connected with networks. and uses it.
• The client/server architecture consists of many  Any changes done here will directly be
PCs and a workstation which are connected via
the network. done on the database itself. It doesn't
• DBMS architecture depends upon how users are provide a handy tool for end users.
connected to the database to get their request
done.  The 1-Tier architecture is used for
development of the local application,
TYPES OF DBMS ARCHITECTURE : where programmers can directly
• Database architecture can be seen as a single tier communicate with the database for the
or multi-tier. quick response.
• But logically, database architecture is of two
types like: 2-tier architecture and 3-tier
architecture.
 DBMS ARCHITECHTURE :
 2-Tier Architecture :  3-Tier Architecture :
 The 2-Tier architecture is same as basic client-server. In the two-  The 3-Tier architecture contains another layer between the
tier architecture, applications on the client end can directly client and server. In this architecture, client can't directly
communicate with the database at the server side. For this communicate with the server.
interaction, API's like: ODBC, JDBC are used.
 The application on the client-end interacts with an application
 The user interfaces and application programs are run on the server which further communicates with the database system.
client-side.
 End user has no idea about the existence of the database
 The server side is responsible to provide the functionalities like: beyond the application server. The database also has no idea
query processing and transaction management. about any other user beyond the application.
 To communicate with the DBMS, client-side application  The 3-Tier architecture is used in case of large web application.
establishes a connection with the server side.
 COMPONENT OF DBMS :
THE COMPONENTS OF DBMS :
1. Hardware : The hardware is the actual computer system used for keeping and accessing the
database. The conventional DBMS hardware consists of secondary storage devices such as hard
disks. Databases run on the range of machines from micro computers to mainframes. SOFTWARE
2. Software : Software is the actual DBMS between the physical database and the users of the
system. All the requests from the user for accessing the database are handled by DBMS.
3. Data : It is an important component of the database management system. The main task of
DBMS is to process the data. Databases are used to store the data, retrieved, and updated to and
from the databases. USER HARDWARE

4. PROCEDURES : Procedures refer to general instructions to use a database management

system. This includes procedures to setup and install a DBMS, To login and logout of DBMS
software, to manage databases, to take backups, generating reports etc.
COMPONENT OF
DATABASE ACCESS LANGUAGE : Database Access Language is a simple language
5.
designed to write commands to access, insert, update and delete data stored in any database. A DBMS
user can write commands in the Database Access Language and submit it to the DBMS for
execution, which is then translated and executed by the DBMS. User can create new databases,
tables, insert data, fetch stored data, update data and delete the data using the access language.
DATABASE
6. Users : There are a number of users who can access or retrieve the data on demand using the
application and the interfaces provided by the DBMS. ACCESS DATA
The users of the database can be classified into different groups − LANGUAGE
 Native Users
 Online Users
PROCEDURES
 Sophisticated Users
 Specialized Users
 Application Users
 DBA- Database Administrator
REFERENCE :
1. https://images.app.goo.gl/xrRQKPMbJb9htUbW
6
2. https://images.app.goo.gl/CmthdUEEKATAFBK
g8
3. https://images.app.goo.gl/uFPP3RW3N69yqrSPA
4. https://images.app.goo.gl/hAeRiCcFNaUKXrD5
6
5. https://www.javatpoint.com/dbms-tutorial
6. https://www.ibm.com/docs/en/zos-basic-skills?to
pic=zos-what-is-database-management-system
7. https://www.geeksforgeeks.org/introduction-of-d
bms-database-management-system-set-1/
8. https://www.techtarget.com/searchdatamanageme
nt/definition/database-management-system
9. https://www.guru99.com/what-is-dbms.html
10. https://www.tutorialspoint.com/dbms/index.htm
THANK YOU