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

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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


Ensembles d'études connexes

Ricci Chapter 44: Nursing Care of the Child With an Alteration in Mobility/Neuromuscular or Musculoskeletal Disorder

View Set

ID 2202 Art Nouveau Belgium/Scotland

View Set

Psy 136 Large-Scale Brain Networks

View Set

Final Exam Multiple Choice Questions

View Set

Econ 1101 - Chapters 22 & 27 Exam Review

View Set

Endocrine Practice Questions (N2 Exam 2)

View Set

Exam 1 - 5020; Foundations & Theory

View Set