Transcript Relational DBMS - Frostburg State University

Chapter One (Database System)
Objectives
Introduction to Database
Management Systems (DBMS)
 Data and Information
 History of DB
 Types of DB

DATA and INFORMATION

Data:



Raw facts; building blocks of information
Unprocessed information
Information:

Data processed to reveal meaning
2
Examples:

What are the examples of raw data?

How can row data become information?
3
Definitions



Introduction to Databases.
Database Management Systems (DBMS)
Why DB?
4
Advantages of DBMS

Centralized Control….







Redundancy
Inconsistency
Shared Data
Standard
Security
Integrity
Multiple View
5
Disadvantages of DBMS:


Complex Design
Cost




Software
Specialist
Program Failure
Others…
6
What is a good database:




Based on a Data Model.
Support one or more high level
programming languages.
Multiple user (Transaction
Management)
Recovery method
7
Definition:




Data Item
Record
File
DB

Domain
8
Type of Databases:

Single-user:


Desktop:


Supports only one user at a time
Single user database running on a personal
computer
Multi-user:

Supports multiple users simultaneously.
9
Type of Databases:

Workgroup:


Multi-user database that supports a small
group of users or a single department
Enterprise:

Multi-user database that supports a large
group of users or an organization
10
Type of Databases by Location:

Centralized:


Supports data located at a single site
Distributed:

Supports data distributed across several
sites
11