Adaptive Learning Assignment 2
In contrast to computerized systems, traditional file management systems can create issues
with ______. -correct answer_organization, repetition, and lack of consistency For the past 10
years, a restaurant has been running a customer loyalty program, rewarding customers with
discounts and treats. Records of these rewards have been kept in odd notes and multiple
spreadsheets used in different ways by various employees who have come and gone over the
years. Because of this, some customers are not getting their rewards, while others are
receiving rewards they have not earned. Overall, the restaurant is losing money and business
with this program. How can a database management system (DBMS) help with this problem?
-correct answer_A DBMS will help the owners manage the data they already have to run their
customer loyalty program more efficiently. A database management system (DBMS) is a
computer program that is used to ______. -correct answer_help organize the data found in a
database Which statement most accurately describes the value of data integrity to an
organization? -correct answer_Databases and database management system (DBMS) with a
high level of data integrity enable more efficient data maintenance in support of organizational
goals. Which of the following are examples of data objects that a relational database
management system (RDBMS) may include? More than one answer may be correct. -correct
answer_Addresses of the company's wholesalers and the number of items in a company's
inventory Names of customers and records of when merchandise was returned Which
statement best explains why traditional file systems have certain issues? -correct
answer_Each file is independent of another file in a traditional system. A relational database
management system (RDBMS) is a type of DBMS whose primary function is to ______.
-correct answer_show how data are connected through relationships Database management
system (DBMS) make it easier to secure data and information because they ______. -correct
answer_allow for the creation of access constraints Which of the following sets of
characteristics specifically apply to relational databases? More than one answer may be
correct. -correct answer_A relational database organizes data in tables composed of records
or objects (the rows), and fields (the columns). Data tables in a relational database are linked
by the fields they have in common. Which statement explains the difference between a
database and a database management system (DBMS)? -correct answer_A DBMS is a
software program designed to organize and administer databases. In the datasheet view of a
relational database (such as Microsoft Access), a row of information is called a ___ . -correct
answer_record Data integrity is increased when ______. -correct answer_data are centralized
In the two tables in the image, which field is a foreign key? -correct answer_FK OwnerID A
mid-sized independent hardware store has recently merged with a large national chain. The
local owners have long used a reliable database to manage inventory. Their database has
been essential in balancing orders for seasonal merchandise with the problem of limited shelf
space. The merger will soon entail managing many more types of data, as the national chain
has approved lists of suppliers, precise requirements for recording transactions, specific
, human resources procedures, and more. Which statement best summarizes what the local
managers will be able to do for the first time when they start using the parent company's
database management system (DBMS)? -correct answer_The managers will be able to create,
edit, and store data in a secure manner across all data types required by the parent company.
Which of the following statements describe the capabilities of relational database management
system (RDBMS)? More than one answer may be correct. -correct answer_RDBMS allow
users to view, add, revise, and remove data. RDBMS have features that support the quality
and security of data. The primary characteristic of a relational database is that it ______.
-correct answer_stores and allows access to data objects that are related to one another This
is a screenshot of a portion of a datasheet. (Drag the correct response to the empty box)
Where could you click to switch to the Design view? -correct answer_View A link between
tables in a relational database that defines how the data are related is called a _____. -correct
answer_relationship When you need to link two tables in a database that do not have a field in
common, one solution is to create a ___. -correct answer_foreign key Referential integrity
states that structural relationships in relational databases must ______. -correct answer_be
consistent: a foreign key field that references a primary key field must agree with that primary
key What is the purpose of an SQL statement? -correct answer_Answer questions about the
database To search a database for information, create a ___. -correct answer_query In the
relationship shown in the image, the Owners table is linked to the Pets table by a one-to-many
relationship. This means that each entry in the OwnerID field can be linked to many ___.
-correct answer_Pets A query is a request for information stored in a database. One of the
benefits of using a database to store information is the ability to run a query. In relational
database management systems (RDBMS), there are a variety of query tools that are used to
execute and run queries. Which of the following are tools used to run queries in an RDBMS?
More than one answer may be correct. -correct answer_SQL specific queries Crosstab queries
Action queries Which of the following statements correctly describes referential integrity? More
than one answer may be correct. -correct answer_For referential integrity to exist, data on both
sides of the table relationship must be present. Referential integrity applies to data quality
within the structure of a relational database. Forms structure data input to help ensure data
_________ , meaning the information entered is accurate, timely, and useful. -correct
answer_integrity or accuracy Which of the following is a task that an SQL statement would be
expected to perform? -correct answer_Retrieve data So that users can find specific information
quickly by using filters based on specific criteria, databases allow the creation of ___. -correct
answer_queries To display or distribute information from a database, programmers or
database administrators create ___. -correct answer_reports Relational database
management systems (RDBMS) have a variety of tools that can be used to execute/run
queries. One of these query tools is the ability to execute/run action queries. Which of the
following are common types of action queries? More than one answer may be correct. -correct
answer_Delete query Update query Append query To control how information is entered into a
database, programmers and database administrators create ___ to help ensure data integrity.
In contrast to computerized systems, traditional file management systems can create issues
with ______. -correct answer_organization, repetition, and lack of consistency For the past 10
years, a restaurant has been running a customer loyalty program, rewarding customers with
discounts and treats. Records of these rewards have been kept in odd notes and multiple
spreadsheets used in different ways by various employees who have come and gone over the
years. Because of this, some customers are not getting their rewards, while others are
receiving rewards they have not earned. Overall, the restaurant is losing money and business
with this program. How can a database management system (DBMS) help with this problem?
-correct answer_A DBMS will help the owners manage the data they already have to run their
customer loyalty program more efficiently. A database management system (DBMS) is a
computer program that is used to ______. -correct answer_help organize the data found in a
database Which statement most accurately describes the value of data integrity to an
organization? -correct answer_Databases and database management system (DBMS) with a
high level of data integrity enable more efficient data maintenance in support of organizational
goals. Which of the following are examples of data objects that a relational database
management system (RDBMS) may include? More than one answer may be correct. -correct
answer_Addresses of the company's wholesalers and the number of items in a company's
inventory Names of customers and records of when merchandise was returned Which
statement best explains why traditional file systems have certain issues? -correct
answer_Each file is independent of another file in a traditional system. A relational database
management system (RDBMS) is a type of DBMS whose primary function is to ______.
-correct answer_show how data are connected through relationships Database management
system (DBMS) make it easier to secure data and information because they ______. -correct
answer_allow for the creation of access constraints Which of the following sets of
characteristics specifically apply to relational databases? More than one answer may be
correct. -correct answer_A relational database organizes data in tables composed of records
or objects (the rows), and fields (the columns). Data tables in a relational database are linked
by the fields they have in common. Which statement explains the difference between a
database and a database management system (DBMS)? -correct answer_A DBMS is a
software program designed to organize and administer databases. In the datasheet view of a
relational database (such as Microsoft Access), a row of information is called a ___ . -correct
answer_record Data integrity is increased when ______. -correct answer_data are centralized
In the two tables in the image, which field is a foreign key? -correct answer_FK OwnerID A
mid-sized independent hardware store has recently merged with a large national chain. The
local owners have long used a reliable database to manage inventory. Their database has
been essential in balancing orders for seasonal merchandise with the problem of limited shelf
space. The merger will soon entail managing many more types of data, as the national chain
has approved lists of suppliers, precise requirements for recording transactions, specific
, human resources procedures, and more. Which statement best summarizes what the local
managers will be able to do for the first time when they start using the parent company's
database management system (DBMS)? -correct answer_The managers will be able to create,
edit, and store data in a secure manner across all data types required by the parent company.
Which of the following statements describe the capabilities of relational database management
system (RDBMS)? More than one answer may be correct. -correct answer_RDBMS allow
users to view, add, revise, and remove data. RDBMS have features that support the quality
and security of data. The primary characteristic of a relational database is that it ______.
-correct answer_stores and allows access to data objects that are related to one another This
is a screenshot of a portion of a datasheet. (Drag the correct response to the empty box)
Where could you click to switch to the Design view? -correct answer_View A link between
tables in a relational database that defines how the data are related is called a _____. -correct
answer_relationship When you need to link two tables in a database that do not have a field in
common, one solution is to create a ___. -correct answer_foreign key Referential integrity
states that structural relationships in relational databases must ______. -correct answer_be
consistent: a foreign key field that references a primary key field must agree with that primary
key What is the purpose of an SQL statement? -correct answer_Answer questions about the
database To search a database for information, create a ___. -correct answer_query In the
relationship shown in the image, the Owners table is linked to the Pets table by a one-to-many
relationship. This means that each entry in the OwnerID field can be linked to many ___.
-correct answer_Pets A query is a request for information stored in a database. One of the
benefits of using a database to store information is the ability to run a query. In relational
database management systems (RDBMS), there are a variety of query tools that are used to
execute and run queries. Which of the following are tools used to run queries in an RDBMS?
More than one answer may be correct. -correct answer_SQL specific queries Crosstab queries
Action queries Which of the following statements correctly describes referential integrity? More
than one answer may be correct. -correct answer_For referential integrity to exist, data on both
sides of the table relationship must be present. Referential integrity applies to data quality
within the structure of a relational database. Forms structure data input to help ensure data
_________ , meaning the information entered is accurate, timely, and useful. -correct
answer_integrity or accuracy Which of the following is a task that an SQL statement would be
expected to perform? -correct answer_Retrieve data So that users can find specific information
quickly by using filters based on specific criteria, databases allow the creation of ___. -correct
answer_queries To display or distribute information from a database, programmers or
database administrators create ___. -correct answer_reports Relational database
management systems (RDBMS) have a variety of tools that can be used to execute/run
queries. One of these query tools is the ability to execute/run action queries. Which of the
following are common types of action queries? More than one answer may be correct. -correct
answer_Delete query Update query Append query To control how information is entered into a
database, programmers and database administrators create ___ to help ensure data integrity.
