Chapter 1

Which of the following is software used to create, maintain, and provide controlled access to databases? Select one: a. Database management system (DBMS) b. User view c. Attribute d. Network operating system

Database management system (DBMS)

Organizing the database in computer disk storage is done in the ________ phase. Select one: a. analysis b. maintenance c. design d. implementation

Design

________ is the most popular RDMS data model notation. a. RED b. DRE c. END d. ERD

ERD

A constraint is a rule in a database system that can be violated by users. -- (T/F)

False

The internal schema consists of the physical schema and the enterprise data model. -- (T/F)

False

A database is an organized collection of ________ related data. Select one: a. physically b. loosely c. badly d. logically

Logically

Which of the following is NOT an advantage of database systems? a. Better data quality b. Reduced program maintenance c. Redundant data d. Program-data independence

Redundant data

Relational databases establish the relationships between entities by means of common fields included in this type of fileSelect one: a. entity. b. association. c. relation. d. relationship

Relation

________ are established between entities in a well-structured database so that the desired information can be retrieved. Select one: a. Lines b. Relationships c. Ties d. Entities

Relationships

________ is a tool even non-programmers can use to access information from a database. Select one: a. Data manipulation query language b. Structured query language c. ODBC d. ASP

Structured query language

The traditional methodology used to develop, maintain and replace information systems is called the: Select one: a. Systems Deployment Life Cycle. b. Systems Development Life Cycle. c. Unified Model. d. Enterprise Resource Model.

Systems Development Life Cycle.

A data warehouse contains summarized and historical information. -- (T/F)

True

A physical schema contains the specifications for how data from a conceptual schema are stored in a computer's secondary memory -- (T/F)

True

The external schema contains a subset of the conceptual schema relevant to a particular group of users. -- (T/F)

True

A(n) ________ is often developed by identifying a form or report that a user needs on a regular basis. Select one: a. reporting document b. enterprise view c. user view d. user snapshot

User view

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. Select one: a. analysis b. planning c. implementation d. design

analysis

The SDLC phase in which the detailed conceptual data model is created is the ________ phase. Select one: a. design b. analysis c. implementation d. planning

analysis

A graphical system used to capture the nature and relationships among data is called a(n): Select one: a. data model. b. XML data model. c. relational database d. hypertext graphic.

data model

A person, place, object, event, or concept about which the organization wishes to maintain data is called a(n): Select one: a. relationship. b. entity. c. object. d. attribute.

entity

The SDLC phase in which database processing programs are created is the ________ phase. Select one: a. design b. planning c. implementation d. analysis

implementation

Older systems that often contain data of poor quality are called ________ systems. Select one: a. mainframe b. legacy c. database d. controlled

legacy

Data that describe the properties of other data are: Select one: a. metadata. b. relationships. c. logical. d. physical

metadata

One of the most popular RAD methods is: Select one: a. crafting. b. prototyping. c. automated design. d. structured walkthrough.

prototyping

A centralized knowledge base of all data definitions, data relationships, screen and report formats, and other system components is called a(n): Select one: a. repository. b. database management system. c. index. d. data warehouse.

repository.

A relatively small team of people who collaborate on the same project is called a: Select one: a. server group. b. data collaborative. c. typical arrangement. d. workgroup

workgroup