8.2 Database management systems (DBMSs)

Question 1

Database management systems (DBMSs)

Answer 1

system software for the definition, creation and manipulation of a database

Question 2

Data management

Answer 2

the organisation and maintenance of data in a database to provide the information required

Question 3

Data dictionary

Answer 3

a set of data that contains metadata (data about other data) for a database

Question 4

Data modelling

Answer 4

the analysis and definition of the data structures required in a database and to produce a data model

Question 5

Logical schema

Answer 5

a data model for a specific database that is independent of the DBMS used to build that database

Question 6

Access rights (database)

Answer 6

the permissions given to database users to access, modify or delete data

Question 7

Developer interface

Answer 7

feature of a DBMS that provides developers with the commands required for definition, creation and manipulation of a database

Question 8

Structured query language (SQL)

Answer 8

the standard query language used with relational databases for data definition and modification

Question 9

Query processor

Answer 9

feature of a DBMS that processes and executes queries written in structured query language (SQL)