DBMS

DBMS

CHARACTERISTICS

FUNCTIONS

ADVANTAGES

DISADVANTAGES

Is a program that interacts with user's application program and db.

-Has a data definition language.

-Has a data manipulation language.

-Uses a query language.

-Provides control access to db.

Enables the user to:

-Define

-Create

-Maintain

-Control access

-Control of data redundancy.

-Data consistency.

-Sharing of data.

-Security & Integrity.

-Complexity.

-Costs.

-Reduced performance.

-Higher impact of failure.

FILE-BASED

SYSTEM

CHARACTERISTICS

A collection of applications programs that perform services for end-users and manage its own data.

ANSI

Is an abstract design of a db in which we have three levels

-External: User's point of view

-Conceptual: What data is stored and the relations

-Internal: Physical representation of the data.

V S