Badm 374 Intro to management
information systems questions with
correct answers
.A database is - correct answer ✔✔a well-designed, organized, and carefully managed collection of data.
The process of defining relationships among data to create useful information requires - correct answer
✔✔knowledge, which is the awareness and understanding of a set of information and the ways in which
that information can be made useful to support a specific task or reach a decision.
Information is - correct answer ✔✔a collection of data organized and processed so that it has additional
value beyond the value of the individual facts.
Data consists of - correct answer ✔✔raw facts, such as an employee number, total hours worked in a
week, an inventory part number, or the number of units produced on a production line.
Nine characteristics of quality information: - correct answer ✔✔Accessible, Accurate, Complete,
Economical, Relevant, Reliable, Timely, Secure, and Verifiable.
An entity is a - correct answer ✔✔person, place, or thing (object) for which data is collected, stored, and
maintained. Examples of entities include employees, products, and customers.
File: - correct answer ✔✔A collection of similar entities. Attribute: A characteristic of an entity. Domain:
The range of allowable values for a data attribute. Data item: The specific value of an attribute.
A foreign key is - correct answer ✔✔an attribute in one table that refers to the primary key in another
table.
Database approach to data management: - correct answer ✔✔An approach to data management where
multiple information systems share a pool of related data.
, A database management system (DBMS) - correct answer ✔✔consists of a group of programs provided
by the DBMS supplier that are used to access and manage a database as well as provide an interface
between the database and its users and other application programs.
In a relational database, - correct answer ✔✔the schema defines the tables, the attributes in each table,
and the relationships between attributes and tables.
A data definition language (DDL) - correct answer ✔✔is a collection of instructions and commands used
to define and describe data and relationships in a specific database.
A data dictionary contains the following information for each data item: - correct answer ✔✔Name of
the data attribute; Aliases or other names that may be used to describe the item; Range of values that
can be used (domain); Type of data (such as alphanumeric or numeric); Number of bytes of storage
needed for the item
When an application requests data from the DBMS, it
When the DBMS retrieves the data, it - correct answer ✔✔follows a logical access path to the data
follows the physical access path to the data.
Data manipulation language (DML)-- - correct answer ✔✔A specific language, provided with a DBMS,
which allows users to access and modify the data, to make queries, and to generate reports.
Data cleansing is - correct answer ✔✔process of detecting and then correcting or deleting incomplete,
incorrect, inaccurate, or irrelevant records that reside in a database.
The enterprise data model - correct answer ✔✔identifies the data entities and data attributes of
greatest interest to the organization along with their associated standard data definitions, data length
and format, domain of valid values, and any business rules for their use.
The entity-relationship (ER) diagram - correct answer ✔✔is a data model used to analyze and
communicate data needs at the individual project or application level using graphical symbols to identify
data entities and their associated data attributes as well as the relationships among the entities of
interest.
information systems questions with
correct answers
.A database is - correct answer ✔✔a well-designed, organized, and carefully managed collection of data.
The process of defining relationships among data to create useful information requires - correct answer
✔✔knowledge, which is the awareness and understanding of a set of information and the ways in which
that information can be made useful to support a specific task or reach a decision.
Information is - correct answer ✔✔a collection of data organized and processed so that it has additional
value beyond the value of the individual facts.
Data consists of - correct answer ✔✔raw facts, such as an employee number, total hours worked in a
week, an inventory part number, or the number of units produced on a production line.
Nine characteristics of quality information: - correct answer ✔✔Accessible, Accurate, Complete,
Economical, Relevant, Reliable, Timely, Secure, and Verifiable.
An entity is a - correct answer ✔✔person, place, or thing (object) for which data is collected, stored, and
maintained. Examples of entities include employees, products, and customers.
File: - correct answer ✔✔A collection of similar entities. Attribute: A characteristic of an entity. Domain:
The range of allowable values for a data attribute. Data item: The specific value of an attribute.
A foreign key is - correct answer ✔✔an attribute in one table that refers to the primary key in another
table.
Database approach to data management: - correct answer ✔✔An approach to data management where
multiple information systems share a pool of related data.
, A database management system (DBMS) - correct answer ✔✔consists of a group of programs provided
by the DBMS supplier that are used to access and manage a database as well as provide an interface
between the database and its users and other application programs.
In a relational database, - correct answer ✔✔the schema defines the tables, the attributes in each table,
and the relationships between attributes and tables.
A data definition language (DDL) - correct answer ✔✔is a collection of instructions and commands used
to define and describe data and relationships in a specific database.
A data dictionary contains the following information for each data item: - correct answer ✔✔Name of
the data attribute; Aliases or other names that may be used to describe the item; Range of values that
can be used (domain); Type of data (such as alphanumeric or numeric); Number of bytes of storage
needed for the item
When an application requests data from the DBMS, it
When the DBMS retrieves the data, it - correct answer ✔✔follows a logical access path to the data
follows the physical access path to the data.
Data manipulation language (DML)-- - correct answer ✔✔A specific language, provided with a DBMS,
which allows users to access and modify the data, to make queries, and to generate reports.
Data cleansing is - correct answer ✔✔process of detecting and then correcting or deleting incomplete,
incorrect, inaccurate, or irrelevant records that reside in a database.
The enterprise data model - correct answer ✔✔identifies the data entities and data attributes of
greatest interest to the organization along with their associated standard data definitions, data length
and format, domain of valid values, and any business rules for their use.
The entity-relationship (ER) diagram - correct answer ✔✔is a data model used to analyze and
communicate data needs at the individual project or application level using graphical symbols to identify
data entities and their associated data attributes as well as the relationships among the entities of
interest.
