8.2 Database management systems (DBMSs) Flashcards

You may prefer our related Brainscape-certified flashcards:
1
Q

Database management systems (DBMSs)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Data management

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Data dictionary

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Data modelling

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Logical schema

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Access rights (database)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Developer interface

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Structured query language (SQL)

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Query processor

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly