Using MIS Chapter 5 Flashcards

1
Q

Developers generally construct a logical representation of database data, called a data model, after building a database.

A

False

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

Browser-based applications ________.

a. are more vulnerable to security threats than are traditional applications
b. need to be pre-installed on the users’ computers
c. run within a corporate network that is protected from the Internet
d. eliminate the need to check for data consistency

A

are more vulnerable to security threats than are traditional applications

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

A foreign key is essential in relational databases to represent the relationship between two tables.

A

True

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

A many-to-many (N:M) relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.

A

True

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

SQL is an international standard language for processing a database.

A

True

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

A key is a column or group of columns that identifies a unique row in a table.

A

True

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

Which of the following is true of traditional database application programs?

a. Application forms, reports, and queries are displayed and processed using a browser.
b. They are written in object-oriented languages such as C++ and VisualBasic.
c. All of the application logic is contained in a program on the database server.
d. They are thin-client applications that need not be pre-installed on the users’ computers.

A

They are written in object-oriented languages such as C++ and VisualBasic.

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

A(n) ________ is a program used to create, process, and administer a database.

a. DBMS
b. operating system
c. data mart
d. information system

A

DBMS

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

The general goal of normalization is to construct tables such that every table has a single topic or theme.

A

True

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

A line in an E-R diagram is used to represent the attributes of the entities.

A

False

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