week 2 quiz

The relational data model was developed in the ____. a. 1960s b. 1970s c. 1980s d. 1990s

1970s

Which data model has the highest level of abstraction? a. Hierarchical b. Entity relationship c. Object-oriented d. Relational

Entity relationship

Which of the following is true of business rules? a. They allow the designer to set company policies with regard to data. b. They can serve as a communication tool between the users and designers. c. They provide a framework for the company's self actualization. d. They allow the designer to develop business processes.

They can serve as a communication tool between the users and designers.

A(n) ____ is the equivalent of a field in a file system. a. entity b. constraint c. attribute d. relationship

attribute

A(n) ____ model represents a global view of the database as viewed by the entire organization. a. physical b. external c. internal d. conceptual

conceptual

A(n) ____ is anything about which data are to be collected and stored. a. relationship b. entity c. constraint d. attribute

entity

The ____ model uses the term connectivity to label the relationship types. a. relational b. entity relationship c. object-oriented d. network

entity relationship

The ____ model was developed to allow designers to use a graphical tool to examine structures rather than describing them with text. a. object-oriented b. entity relationship c. network d. hierarchical

entity relationship

VMS/VSAM is an example of a(n) ____. a. relational data model b. file system data model c. XML data model d. hierarchical model

file system data model

Students and classes have a ____ relationship. a. one-to-many b. many-to-one c. one-to-one d. many-to-many

many-to-many