Introduction to Databases: Concepts, Advantages, and Examples, Assignments of Database Management Systems (DBMS)

Database Management system Assignment DBMS

Typology: Assignments

2020/2021

Uploaded on 12/10/2021

techno-society
techno-society 🇵🇰

1 document

1 / 4

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
What do you mean by database? What are the advantages of
maintaining a database?
Databases:
A database isan organized collection of structured information, or data,
typically stored electronically in a computer system. Together, the data
and the DBMS, along with the applications that are associated with
them, are referred to as a database system, often shortened to just
database.
Advantages of Database Management System
Better Data Transferring
Better Data Security.
Better data integration.
Minimized Data Inconsistency.
Faster data Access.
Better decision making.
Increased end-user productivity.
What examples of certain problems/scenarios where a maintain a
database should not be preferred?
Problems:
1. High initial investment in hardware, software, and training.
2. The generality that a DBMS provides for defining and processing
data.
3. Overhead for providing security, concurrency control, recovery, and
integrity functions.
4. Simple, well-defined database applications that are not expected to
change at all.
pf3
pf4

Partial preview of the text

Download Introduction to Databases: Concepts, Advantages, and Examples and more Assignments Database Management Systems (DBMS) in PDF only on Docsity!

What do you mean by database? What are the advantages of maintaining a database? Databases: A database is an organized collection of structured information, or data, typically stored electronically in a computer system. Together, the data and the DBMS, along with the applications that are associated with them, are referred to as a database system, often shortened to just database. Advantages of Database Management System  Better Data Transferring  Better Data Security.  Better data integration.  Minimized Data Inconsistency.  Faster data Access.  Better decision making.  Increased end-user productivity. What examples of certain problems/scenarios where a maintain a database should not be preferred? Problems:

  1. High initial investment in hardware, software, and training.
  2. The generality that a DBMS provides for defining and processing data.
  3. Overhead for providing security, concurrency control, recovery, and integrity functions.
  4. Simple, well-defined database applications that are not expected to change at all.

ER model on banks: Commercial Banks, Foreign Banks, Islamic Banks, BANKS COMMERCIAL BANK FOREIGN BANKS ISLAMIC BANK ID Balance Account No Account ID Job EMPLOYEE Maintain ACCOUNT Name Gender

ER model on player and teams:

PLAYERS

PLAYER NAME PLAYER NO Team name HAS Result

SPORTS Data

players PLAY Name Players no

TEAMS

PARTICI PATE