Ch. 5-3 What is a database management system (DBMS)?

Processing the database

2nd function of the DBMS; DBMS provides applications for 4 processing operations: to read, insert, modify, or delete data

Administering the database

3rd function of DBMS; responsibilities: development, operation, backup and recovery, adaptation

Database management system (DBMS)

a program used to create, process, and administer a database; is a software program; used to create tables, relationships, and other structures in the database

Structured query language (SQL)

an international standard language for processing a database

Permissions

can limit certain users to be able to read/access only certain data in database tables

Database administrations

involves a wide variety of activities, such as: using DBMS to set up a security system involving user accounts, passwords, permissions, limits for processing the database; backing up database data; adding structures to improve the performance of database applications; removing data that are no longer wanted or needed, etc