BCOR 330 - Chapter 5
A __________ is a collection of forms, reports, queries, and programs that process a database.
database application
The purpose of a ________ is to create, process, and administer a database.
database management system (DBMS)
A one-to-many relationship is expressed by _____________.
1:N
Which of the following describes a database application?
A collection of forms, reports, queries, and programs that process a database
Which of the following best describes a primary key?
A column or group of columns that identifies a unique row in a table
Which of the following is true of the components of an entity-relationship data model?
Attributes describe the characteristics of entities.
Which of the following actions follows the step of determining the requirements for new forms, reports, and queries during the development of a database application system?
Creating a data model
Which of the following best defines metadata?
Describes the structure of a database
Which of the following categories of new DBMS represents DBMS that process databases in main memory?
In-memory DBMS
Which of the following is true about a data model?
It describes the data and relationships that will be stored in the database.
Which of the following gives an accurate description of a data model?
It is a logical representation of the data in a database that describes the data and relationships that will be stored in the database.
Which of the following is true of a query?
It is a request that is executed to retrieve data from a database.
Which of the following describes the structure of a database?
Metadata
Which of the following is an open source document-oriented DBMS that is used by organizations because it does not require normalized data but manages collections of documents that have a variety of structures?
MongoDB
Which of the following is another name for a row in a database?
Record
The eHermes developers decide to use the SQL Server DBMS instead of MongoDB. What is the reason for this decision?
SQL Server will be less risky.
Which of the following is the primary purpose of using a database?
To keep track of data
Setting up user accounts, passwords, permissions, and limits for processing a database is part of database ________.
administration
All of the following are database administration activities EXCEPT ________.
creating the database tables, relationships, and other structures
Tables that are not normalized will likely have problems related to __________.
data integrity
Just as building architects create a blueprint before they start building, so, too, database developers create a __________ before they start designing the database.
data model
Keeping track of data is the primary purpose of a __________.
database
Changes in processing requirements for future IS systems have led to new categories of DBMS. All of the following are new DBMS categories EXCEPT ________.
output-memory DBMS
A column or group of columns that identifies a unique row in a table is a __________.
primary key
Attributes of an entity-relationship data model are best used to describe __________.
the characteristics of entities
