MIS Exam 1 Conceptual

Which of the following is NOT an advantage of database systems? A) Redundant data B) Program-data independence C) Better data quality D) Reduced program maintenance

A) Redundant data

A person's name, birthday, and social security number are all examples of ________: A) attributes. B) entities. C) relationships. D) descriptors.

A) attributes.

Program-data dependence is caused by ________ A) file descriptions being stored in each database application. B) data descriptions being stored on a server. C) data descriptions being written into programming code. D) data cohabiting with programs.

A) file descriptions being stored in each database application.

1. A database is an organized collection of ________ related data. A) logically B) physically C) loosely D) badly

A) logically

The most common types of entities are ________: (0.6%) A) strong entities. B) weak entities. C) associative entities. D) smush entities.

A) strong entities.

________ are established between entities in a well-structured database so that the desired information can be retrieved. (0.6%) A) Entities B) Relationships C) Lines D) Ties

B) Relationships

The following figure shows an example of: Employee---------carries---------<Dependent A) a one-to-many relationship. B) a strong entity and its associated weak entity. C) a co-dependent relationship. D) a double-walled relationship

B) a strong entity and its associated weak entity.

The logical representation of an organization's data is called a(n) ________: (0.6%) A) database model. B) entity-relationship model. C) relationship systems design. D) database entity diagram.

B) entity-relationship model.

The number of entity types that participate in a Unary relationship is ________: (0.6%) A) zero. B) one. C) two. D) three.

B) one.

Which of the following is software used to create, maintain, and provide controlled access to databases? A) Network operating system B) User view C) Database management system (DBMS) D) Attribute

C) Database management system (DBMS)

Which of the following is NOT a cost and/or risk of the database approach? A) Specialized personnel B) Cost of conversion C) Improved responsiveness D) Organizational conflict

C) Improved responsiveness

Which of the following is NOT a characteristic of a good business rule? A) Declarative B) Atomic C) Inconsistent D) Expressible

C) Inconsistent

________ analyze the business situation and identify the need for information and information services to meet the problems or opportunities of the business. (0.6%) A) Programmers B) Users C) Systems analysts D) Database analysts

C) Systems analysts

An entity type name should be all of the following EXCEPT ________: A) concise. B) specific to the organization. C) as short as possible. D) a singular noun.

C) as short as possible.

One of the most popular RAD methods is: A) automated design. B) structured walkthrough. C) prototyping. D) crafting.

C) prototyping.

Which of the following is NOT a good characteristic of a data name? A) Relates to business characteristics B) Readable C) Repeatable D) Relates to a technical characteristic of the system

D) Relates to a technical characteristic of the system

A ________ defines or constrains some aspect of the business. A) business constraint B) business structure C) business control D) business rule

D) business rule

Data that describe the properties of other data are ________ (0.6%) A) relationships. B) logical. C) physical. D) metadata.

D) metadata.

With the database approach, data descriptions are stored in a central location known as a ________: A) server. B) mainframe. C) PC. D) repository.

D) repository.