. .
Quiz by , created more than 1 year ago

asdf Quiz on Chapter 2 (True/False), created by . . on 30/08/2016.

834
3
0
. .
Created by . . over 7 years ago
Close

Chapter 2 (True/False)

Question 1 of 20

1

A data model is usually graphical.

Select one of the following:

  • True
  • False

Explanation

Question 2 of 20

1

2. An implementation-ready data model needn't necessarily contain enforceable rules to guarantee the integrity of the data.

Select one of the following:

  • True
  • False

Explanation

Question 3 of 20

1

3. An implementation-ready data model should contain a description of the data structure that will store the end-user data.

Select one of the following:

  • True
  • False

Explanation

Question 4 of 20

1

4. Within the database environment, a data model represents data structures with the purpose of supporting a specific problem domain.

Select one of the following:

  • True
  • False

Explanation

Question 5 of 20

1

5. Even when a good database blueprint is available, an applications programmer’s view of the data should match that of the manager and the end user.

Select one of the following:

  • True
  • False

Explanation

Question 6 of 20

1

6. In the context of data models, an entity is a person, place, thing, or event about which data will be collected and stored.

Select one of the following:

  • True
  • False

Explanation

Question 7 of 20

1

7. Database designers determine the data and information that yield the required understanding of the entire business.

Select one of the following:

  • True
  • False

Explanation

Question 8 of 20

1

8. Business rules apply to businesses and government groups, but not to other types of organizations such as religious groups or research laboratories.

Select one of the following:

  • True
  • False

Explanation

Question 9 of 20

1

9. Business rules must be rendered in writing.

Select one of the following:

  • True
  • False

Explanation

Question 10 of 20

1

10. In an SQL-based relational database, each table is dependent on every other table.

Select one of the following:

  • True
  • False

Explanation

Question 11 of 20

1

11. In an SQL-based relational database, rows in different tables are related based on common values in common attributes

Select one of the following:

  • True
  • False

Explanation

Question 12 of 20

1

12. A disadvantage of the relational database management system (RDBMS) is its inability to hide the complexities of the relational model from the user.

Select one of the following:

  • True
  • False

Explanation

Question 13 of 20

1

13. Each row in the relational table is known as an entity instance or entity occurrence in the ER model.

Select one of the following:

  • True
  • False

Explanation

Question 14 of 20

1

14. In Chen notation, entities and relationships have to be oriented horizontally; not vertically.

Select one of the following:

  • True
  • False

Explanation

Question 15 of 20

1

15. M:N relationships are not appropriate in a relational model.

Select one of the following:

  • True
  • False

Explanation

Question 16 of 20

1

16. Today, most relational database products can be classified as object/relational.

Select one of the following:

  • True
  • False

Explanation

Question 17 of 20

1

17. The network model has structural level dependence.

Select one of the following:

  • True
  • False

Explanation

Question 18 of 20

1

18. The external model is the representation of the database as “seen” by the DBMS.

Select one of the following:

  • True
  • False

Explanation

Question 19 of 20

1

19. The hierarchical model is software-independent.

Select one of the following:

  • True
  • False

Explanation

Question 20 of 20

1

20. The relational model is hardware-dependent and software-independent.

Select one of the following:

  • True
  • False

Explanation