Understanding Databases and DBMS

An integrated collection of logically organised data

A collection of unrelated data

A type of software application

A method for storing data

Metadata about the database

User data

Backup information

Data processing instructions

To create and destroy databases

To manipulate data

To query data

To secure data

Data redundancy

High performance

Easy integration

Low cost

Databases automatically retrieve data

Traditional files are more secure

Databases are slower

Traditional files are easier to manage

A value that represents the presence or absence of an electronic signal

A group of interrelated fields

A collection of records

A type of database

To retrieve, insert, and modify database information

To define database structures

To manage user access

To create backups

To enable storage, modification, and extraction of information from a database

To create physical storage devices

To manage hardware resources

To develop software applications

It describes the logical structure of the database

It contains user data

It is a backup of the database

It is a type of software

To query, insert, update, and modify data

To create database backups

To manage user permissions

To define data types