various applications
TRANSCRIPT
-
7/29/2019 Various Applications
1/12
VARIOUS APPLICATIONS
OF DATABASE
PREPARED BY-DIPTI GUPTA
(09XQCMA023)
-
7/29/2019 Various Applications
2/12
DATABASE
A database consists of an organized collection of data forone or more uses, typically in digital form.
It describes the activities of one or more relatedorganizations.
For example, a university database might containinformation about the following:
Entities such as students, faculty, courses, and
classrooms.
Relationships between entities, such as studentsenrollment in courses, faculty teaching courses, and
the use of classrooms for teaching the courses.
-
7/29/2019 Various Applications
3/12
DATABASE MANAGEMENT SYSTEM
A Database Management System (DBMS) is a set of
computer programs that controls the creation,
maintenance, and the use of a database.
It allows organizations to place control of databasedevelopment in the hands of database administrators
(DBAs) and other specialists.
It provides an environment that is both convenient and
efficient to use.
-
7/29/2019 Various Applications
4/12
APPLICATIONS OF DATABASE
Various application of databases in different sectors are:
BANKING
AIRLINES
UNIVERSITIES
CREDIT CARD TRANSACTIONS TELECOMMUNICATIONS
FINANCE
SALES
MANUFACTURING HUMAN RESOURCES
LIBRARIES
-
7/29/2019 Various Applications
5/12
BANKING For customer information
Accounts
Loans
Banking transactions
AIRLINES For reservations and schedule
information
Fares
Availability of seats
-
7/29/2019 Various Applications
6/12
UNIVERSITIES
For student information
Course registrations
Grades
Fees
CREDIT CARD TRANSACTIONS
For information about the card
holder
Purchases on credit cards
Generation of monthly statements
-
7/29/2019 Various Applications
7/12
TELECOMMUNICATIONS
For keeping records of calls made
Generating monthly bills
Maintaining balances on prepaid
calling cards
Storing information about thecommunication networks.
FINANACE
For storing information about holdings
Sales
Purchases of financial instruments
such as stocks and bonds
-
7/29/2019 Various Applications
8/12
SALES
For customer information
Product
Purchase information
Schemes
MANUFACTURING
For management of supply chain
For tracking production of items in
factories
Inventories of items in warehouses
Orders for items
-
7/29/2019 Various Applications
9/12
HUMAN RESOURCE
For information about employees
Salaries Payroll
Taxes
Benefits
Leaves
LIBRARIES For books
Authors
Availability
-
7/29/2019 Various Applications
10/12
ER DIAGRAM OF A BANK DATABASE
CUSTOMER ACCOUNTDEPOSITOR
Customer
nameCustomer
id
Customer
street Customer
city
Account
balance
Accountnumber
-
7/29/2019 Various Applications
11/12
ER DIAGRAM OF A AIRLINE DATABASE
AIRPORT AEROPLANELAND
Arrival Departure
Luggage
belt
Number
of passengers
Fares
-
7/29/2019 Various Applications
12/12