Intro to Info Systems Ch.7

What type of website is best to build for a website with continually changing information including press releases, new product information, and updated pricing? A) Data-driven website B) Static website C) Relational website D)All of the above

A) Data-driven website

A central repository does not allow information to be integrated across multiple systems. True False

False

A database management system (DBMS) can only interact with other software application programs. True False

False

A foreign key is a field (or group of fields) that uniquely identifies a given entity in a table. True False

False

Which of the following database structures stores information in a tree-like structure that allows repeating information using parent/child relationships, in such a way that it cannot have too many relationships? A) Hierarchical database B) Network database C) Relational database model D) All of the above

A) Hierarchical database

What type of integrity constraint does not allow someone to create an order for a nonexistent customer? A) Relational integrity constraint B) Business-critical integrity constraint C) Information-critical integrity constraint D) None of the above

A) Relational integrity constraint

What refers to how well a system can adapt to increased demands? A) Scalability B) Performance C) Information integrity D) Redundancy

A) Scalability

What is a forward integration? A) Takes information entered into a given system and sends it automatically to all downstream systems and processes B) Takes information entered into a given system and sends it automatically to all upstream systems and processes C) Takes information entered into a given system and sends it to the application generation component D) Takes information entered into a given system and sends it to the DBMS

A) Takes information entered into a given system and sends it automatically to all downstream systems and processes

Why do relational databases use primary keys and foreign keys? A) To create logical relationships B) To create a database C) To create physical relationships D) All of the above

A) To create logical relationships

What is a primary key? A) Characteristics or properties of an entity B) A field (or group of fields) that uniquely identifies a given entity in a table C) A field (or group of fields) that uniquely identifies a given attribute in a table D) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables

B) A field (or group of fields) that uniquely identifies a given entity in a table

What type of website is best to build for a general informational website with static information? A) Data-driven website B) Static website C) Relational website D) All of the above

B) Static website

What is a backward integration? A) Takes information entered into a given system and sends it to the DBMS B) Takes information entered into a given system and sends it automatically to all upstream systems and processes C) Takes information entered into a given system and sends it automatically to all downstream systems and processes D) Takes information entered into a given system and sends it to the application generation component

B) Takes information entered into a given system and sends it automatically to all upstream systems and processes

What is a foreign key? A) Characteristics or properties of an entity B) A field (or group of fields) that uniquely identifies a given entity in a table C) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables D) A field (or group of fields) that uniquely identifies a given attribute in a table

C) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables

What is the physical view of information? A) Focuses on how users logically access information to meet their particular business needs B) Focuses on how users physically access information to meet their particular business needs C) Deals with the physical storage of information on a storage device such as a hard disk D) Deals with the logical storage of information on a storage device such as a hard disk

C) Deals with the physical storage of information on a storage device such as a hard disk

In the relational database model, what is a person, place, thing, transaction, or event about which information is stored? A) Logical view B) Physical view C) Entity D) Attribute

C) Entity

Which of the following is true in regards to the elimination of redundant information? A) Uses additional hard disk space B) Makes performing information updates harder C) Improves information quality D) All of the above

C) Improves information quality

All of the following are advantages of database-stored information, except: A) Increased flexibility B) Increased performance C) Increased information redundancy D) Increased information integrity

C) Increased information redundancy

Which of the following measures how quickly a system performs a certain process or transaction? A) Information integrity B) Scalability C) Performance D) Redundancy

C) Performance

In the relational database model, what are characteristics or properties of an entity? A) Entity B) Physical view C) Logical view D) Attribute

D) Attribute

What is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database? A) Customer-driven website B) Data-driven database C) Customer-driven database D) Data-driven website

D) Data-driven website

Ideally, an organization only wants to build forward integrations. True False

False

The physical view and the logical view are the same in a relational database management system. True False

False

A data-driven website is an interactive website kept constantly updated and relevant to the needs of its customers through the use of a database. True False

True

A foreign key in the relational database model is a primary key of one table that appears as an attribute in another table. True False

True

Redundancy is the duplication of information, or storing the same information in multiple places. True False

True