Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Database > Chapter 1 > Flashcards

Chapter 1 Flashcards

1
Q

________ are established between entities in a well-structured database so that the desired information can be retrieved.

A

Relationships

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

Database architects establish standards for data in business units.

A

True

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

Metadata are data that describe the properties of other data.

A

True

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

Metatdata typically describes all of the following EXCEPT:

A

location on disk.

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

Organizational commitment to a database project is not necessary for its success.

A

False

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

Many of the disadvantages of file processing systems can also be limitations of databases.

A

True

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

All projects move from the planning-enterprise modeling step to the planning-conceptual data modeling step of the systems development life cycle.

A

False

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

Prototyping is a type of rapid application development.

A

True

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

Database processing programs are coded and tested during the design stage of the systems development life cycle.

A

False

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

________ do NOT concentrate on determining the requirements for the database component of an information system.

A

End Users

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

Data from prior systems is converted to the new system during the implementation phase of the systems development life cycle.

A

True

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

The period that can be considered a “proof of concept” time was the:

A

1960s

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

Development starts from scratch with the traditional file processing approach because new file formats, descriptions, and file access logic must be designed for each new program.

A

True

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

Which of the following is software used to create, maintain, and provide controlled access to databases?

A

Database management system (DBMS)

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

The SDLC phase in which every data attribute is defined, every category of data is listed, and every business relationship between data entities is defined is called the ________ phase.

A

analysis

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

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

A

user view

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

One reason for improved application development productivity with the database approach is that file design and low-level implementation details do not need to be handled by the application programmer.

A

True

18
Q

The SDLC phase in which database processing programs are created is the ________ phase.

A

implementation

19
Q

Separation of metadata from application programs that use the data is called data independence.

A

True

20
Q

Which of the following is NOT a cost and/or risk of the database approach?

A

Improved responsiveness

21
Q

Which of the following is NOT an advantage of database systems?

A

Redundant data

22
Q

Multi-tier client/server database applications contain a business logic layer.

A

True

23
Q

Although personal databases improve productivity, one risk is that data cannot be shared with other users.

A

True

24
Q

An enterprise resource planning system integrates all functions of the enterprise.

A

True

25
Q

A well-structured database establishes the entities between relationships in order to derive the desired information.

A

False

26
Q

________ do NOT concentrate on determining the requirements for the database component of an information system.

A

End Users

27
Q

A database is an organized collection of ________ related data.

A

logically

28
Q

Database development projects are never done in a bottom-up fashion.

A

False

29
Q

Because applications are often developed independently in file processing systems:

A

unplanned duplicate data files are the rule rather than the exception.

30
Q

The steps of the systems development life cycle can only be viewed as a linear process.

A

False

31
Q

The repository is populated during the analysis phase of the systems development life cycle.

A

True

32
Q

________ specify computer systems requirements.

A

Systems analysts

33
Q

The data repository assists database administrators in enforcing standards.

A

True

34
Q

Which of the following is NOT a cost and/or risk of the database approach?

A

Improved responsiveness

35
Q

One of the most popular RAD methods is:

A

prototyping.

36
Q

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n):

A

entity.

37
Q

The need for consensus on data definitions is an example of which type of risk in the database environment?

A

Organizational conflict

38
Q

A major difference between data warehouses and transactional systems as compared to big data is:

A

the data is unstructured in big data systems.

39
Q

Enterprise modeling sets the range and general contents of organizational databases.

A

True

40
Q

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis.

A

user view

Database (8 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions