Databases - DBMS

Benefits of a DBMS?

System security, integrity, data security, efficiency, consistency and customisation.

What is the external view?

The view of data by customers/those who input and view data.

What is the conceptual view?

The view that shows how all tables are connected and their relationships.

What is the internal view?

The view that shows the structure or a database's files and records. Allows programmers to examine record attributes, data types, validation, etc.

What is concurrency?

Where several transactions occur simultaneously.

A DBMS...

... separates applications from data.

What is a transaction?

A change in data.

What is ACID?

Atomicity, Consistency, Isolation, Durability.

What is DBMS?

Data Base Management System. A tool used to store edit and organise data in a database.