Database Design and Administration Flashcards

1
Q

is an integrated collection of stored data that is centrally managed and controlled

A

database (DB)

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

A database is managed and controlled by a …

A

database management system

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

A … is a system software component that is generally purchased and installed separately from other system software components

A

database management system (DBMS)

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

which is the actual data for the problem domain

A

application domain data

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

contains descriptive information about the application domain data

A

schema

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

It is required because it describes the structure and rules for accessing the application domain data

A

schema data

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

is defined as a collection of steps that helps with designing, creating, implementing, and maintaining business’s data management systems

A

Database design

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

The main purpose of designing a database is to produce

A

Physical and logical models of design

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