MIS 309 Chapter 5
A ________ is a collection of forms, reports, queries, and programs that process a database. A) database application B) database design C) data field D) data model
A
A data model is a ________. A) logical representation of database data B) repository of unprocessed data C) collection of isolated databases D) set of programs used to retrieve data
A
Albert creates a relational database to store employee performance statistics. He stores each employee's data in independent rows and creates a column named "Employee Number" to assign unique numbers to each employee. This column is referred to as a(n) ________. A) primary key B) identifier C) foreign key D) functionally dependent record
A
An organization buys a proprietary database application to be used by a small workgroup of five people. This is an example of a(n) ________ DBMS A. personal B. enterprise C. inter-enterprise D. individual
A
From among the following, identify the open source DBMS product. A) MySQL B) DB2 C) Access D) Oracle Database
A
Identify the type of task that a database administrator is performing when validating the data model to be used in a database management system. A) development B) adaptation C) backup and recovery D) operation
A
The rows in a database are called ________. A) records B) tables C) files D) fields
A
When using the relational model to represent data, one must ________. A) add a foreign key to one of the tables B) have more than two identifiers in the model C) establish only N:M relationships between the tables D) use metadata instead of foreign keys
A
Which of the following data elements is placed higher than records in the data hierarchy? A) file B) field C) character D) byte
A
Which of the following is a developmental task of database administration? A) creating and staffing the DBA function B) monitoring backup procedures C) conducting training for users D) managing configuration changes in systems
A
Which of the following is a nonrelational data store developed by Facebook? A) Cassandra B) Dynamo C) SharePoint D) Bigtable
A
Which of the following is true about the database development process? A) The easiest time to change the database structure is during the data modeling stage. B) Changing a relationship from 1:N to N:M in an existing database is simply a matter of changing notations. C) User review of the data model is avoided as it is not helpful in data modeling. D) A database is a model of how the developers view their business world.
A
Which of the following types of DBMS products is designed for smaller and simpler database applications? a. personal DBMS b. enterprise DBMS c. inter-enterprise DBMS d. workgroup DBMS
A
_______ is the term used to describe data collections that are characterized by huge volume, rapid velocity, and great variety. A) BigData B) NoSQL C) Dynamo D) Hadoop
A
________ is an example of a personal DBMS. A. Access B. Oracle C. MySQL D. Dynamo
A
________ is the process of converting a data model into tables, relationships, and data constraints A) Database design B) Database querying C) Data mining D) Database aggregation
A
) Constraints on the number of entities in a relationship are called ________ cardinalities. A) specific B) minimum C) primary D) critical
B
A data integrity problem will occur only if ________. A) a database has multiple administrators B) data are duplicated in a database C) the database is very large D) there are complex relationships between entities in a database
B
A primary key used in a database is a ________. A) group of rows that are formed to identify a unique table or file B) column or group of columns that identifies a unique row in a table C) character or byte that represents fields or columns D) group of tables or files formed to identify a unique field or ro
B
A(n) ________ DBMS is designed to process large organizational and workgroup databases. A. workgroup B. enterprise C. inter-enterprise D. corporate
B
A(n) ________ is a program used to create, process, and administer a database. A) operating system B) DBMS C) information system D) data mart
B
Columns that belong to a different table than the one in which they reside are called ________. A) attributes B) foreign keys C) primary keys D) internal records
B
Each entity in a database has a unique attribute called a(n) ________. A) public key B) identifier C) foreign key D) index field
B
Every table in a normalized database has a(n) ________. A) one-to-one relationship between entities B) single theme C) foreign key D) specialized query format
B
In an E-R diagram, a(n) ________ on a line means that at least one entity type of that type is required. A) small oval B) vertical bar C) arrow D) triangular block
B
The tables that appear in a database are known as ________. A) records B) files C) fields D) attributes
B
Which of the following is a nonrelational data store developed by Amazon? A) Cassandra B) Dynamo C) SharePoint D) Bigtable
B
Which of the following is a valid observation of MySQL A) It is offered by Oracle. B) It is license-free for most applications. C) It is a closed-source database product. D) It is yet to be widely adopted.
B
Which of the following is used to process and display browser database application forms, reports, and queries? A) C++ B) html C) COBOL D) VisualBasic
B
________ forms are used to read, insert, modify, and delete data. A) Reports B) Data Entry C) Queries D) DBMS
B
________ is the process of converting a poorly- structured table into two or more well-structured tables. A) Optimization B) Normalization C) Refactoring D) Standardization
B
A ________ describes the data and relationships that will be stored in a database. A) data aggregator B) query model C) data model D) data application
C
A ________ is a request for data from a database. A) form B) report C) query D) application
C
A database is required instead of a spreadsheet when ________. A) professionals need to keep a track of things B) a user requires control over data C) lists involve data with multiple themes D) one or more users want to access the same data
C
A line on an E-R diagram that indicates a 1:N relationship between two entities is referred to as ________. A) identifiers B) foreign keys C) crow's feet D) entities
C
A student management system allows students to have multiple majors and advisers are assigned to handle multiple students and courses. This is an example of a(n) ________ relationship. A) 1:N B) 1:1 C) N:M D) M:1
C
An administrator should create a(n) ________ before developing a database design. A) data aggregator B) query model C) data model D) data application
C
Browser applications are thin-client applications that ________. A) mostly display static content B) are processed using VisualBasic and C++ C) need not be pre-installed on the users' computers D) depend on internal networks and not the Internet to transmit data
C
Browser-based applications ________. A) are thick-client applications B) can only display static content C) support querying using graphics D) process queries using C++
C
In a data model, a(n) ________ is something that a user wants to track. A) record B) byte C) entity D) primary key
C
In a database, ________ are grouped into columns. A) fields B) records C) bytes D) files
C
Metadata are ________. A) code used for server-side processing B) error logs of databases C) data that describe data D) encrypted data transmissions
C
Which of the following is an international standard language for processing a database? A) Cassandra B) DB2 C) SQL D) MS Access
C
Which of the following is the smallest data element in a database? A) field B) record C) byte D) file
C
Which of the following is true of traditional database application programs? A) Application forms, reports, and queries are displayed and processed using a browser. B) All of the application logic is contained in a program on the database server. C) They are written in object-oriented languages such as C++ and VisualBasic. D) They are thin-client applications that need not be pre-installed on the users' computers.
C
________ are the final judges as to what data the database should contain and how the records in that database should be related to one another. A) Administrators B) Developers C) Users D) Designers
C
27) Which of the following is true of single-user databases? A) They are displayed and processed using html5, css3, and JavaScript. B) They use JavaScript for user-side processing. C) The Internet is used to access the DBMS server computer. D) The application, the DBMS, and the database all reside on the user's computer.
D
A database design team transforms entities into tables and expresses relationships by defining ________. A. tables B. identifiers C. primary keys D. foreign keys
D
Brad, a project manager, wants to build a database to integrate information about employees and tasks that they handle. Brad wants to track information such as task name, percentage completed, and employee name. These aspects that Brad wants to track are called ________. A) identifiers B) records C) primary keys D) entities
D
Brenda, the sales manager of a firm, wants to generate a particular report containing sales analyses of the second and third quarter of the year. After accessing the DBMS, she should type the keyword into a ________ form to obtain the information that she wants. A) report B) data model C) database administrative function D) query
D
Browser-based applications ________. A) need to be pre-installed on the users' computers B) run within a corporate network that is protected from the Internet C) eliminate the need to check for data consistency D) are more vulnerable to security threats than are traditional applications
D
Entities in a data model have ________ that describe the characteristics of the entity. A) characters B) primary keys C) codes D) attributes
D
Identify the first step in transforming a data model into a relational database design. A) representing the data relationships B) normalizing the data and files C) creating foreign keys D) creating a table for each entity
D
In an E-R diagram, a line between two entities represents a(n) ________. A) attribute B) identifier C) cardinality D) relationship
D
The columns in a database are called ________. A) records B) tables C) files D) fields
D
The database administrator of an organization constantly manages the processing rights and responsibilities of employees. This is an example of a(n) ________ task. A) development B) recovery C) adaptation D) operational
D
Traditional database applications programs are ________. A) browser-based and display dynamic content B) written in languages such as html5 and JavaScript C) entirely dependent on the database server for application logic D) thick applications that need to be installed on users' computers
D
When you modify or delete data present in a database, you are ________. A) creating a new database B) forming a data model C) simplifying the data structure D) processing the database
D
Which of the following database administration tasks is related to adaptation? A) monitoring backup procedures B) conducting training for users C) monitoring database performance D) managing configuration changes in systems
D
Which of the following formations on a line in an E-R diagram means that the relationship need not have an entity of that type? A) vertical bar B) arrow C) double line D) small oval
D
Which of the following is a nonrelational data store developed by Google? A) Cassandra B) Dynamo C) SharePoint D) Bigtable
D
Which of the following is an example of a database management system? A) MS Excel B) BigData C) NoSQL D) Access
D
Which of the following is an example of an enterprise DBMS? A. Access B. Oracle C. Amazon D. SQL Server
D
Which of the following is true of N:M relationships? A) They are the same as N:N relationships. B) They represent minimum cardinalities in a relationship. C) They are also called one-to-many relationships. D) They can have more than one entity on each side of the relationship.
D
__________ in an E-R diagram refer to the minimum number of entities required in a relationship A) One-to-one relationships B) Primary keys C) Foreign keys D) Minimum cardinalities
D
A(n) ________ is a self-describing collection of integrated records.
Database
T/F: 1:N, N:M, and 1:1 are common examples of minimum cardinalities
False
T/F: A DBMS and database mean the same thing and are synonymous terms that can be used interchangeably
False
T/F: A database is best described as a collection of unrelated tables
False
T/F: A group of similar rows or records in a table is called a field
False
T/F: A line in an E-R diagram is used to represent the attributes of the entities
False
T/F: A user does not need user account credentials to access and process a database
False
T/F: Browser applications are thin-client applications that need to be pre-installed on the users' computers
False
T/F: Changing a relationship from one-to-many to many-to-many in a functional database is simply a matter of changing the N:N notation to N:M
False
T/F: Database applications must present data to the users in the same format as the database table
False
T/F: Developers generally construct a logical representation of database data, called a data model, after building a database
False
T/F: Each table in a database must have two or more primary keys
False
T/F: In an entity-relationship (E-R) diagram, an entity is represented by a triangle, and the relationships between entities are represented by dotted lines
False
T/F: In data models, physical objects are represented as entities, whereas logical constructs and transactions are represented as attributes
False
T/F: Managing the impact of database structure changes on applications and users is an operational task for a database administrator
False
T/F: Metadata refers to entities of a database that users want to process
False
T/F: Most organizations develop their own DBMS software in order to obtain control over data
False
T/F: Most traditional databases use the Internet to transmit traffic back and forth between the users' computers and the DBMS server
False
T/F: Normalization is the process of combining two or more tables into a single table
False
T/F: Normalized tables are faster to process than tables that haven't been normalized
False
T/F: One of the developmental tasks of a database administrator is to create a system to record and manage the resolution of problems
False
T/F: The accuracy of a database design is independent of the corresponding data model
False
T/F: The easiest time to change the database structure is after the data modeling stage
False
T/F: The lost-update problem can be resolved by implementing multi-user database processing
False
T/F: The purpose of a database is to keep track of things that involve a single theme
False
T/F: The small oval on a line in an E-R diagram means that the relationship must have an entity of that type
False
T/F: A data model describes data and relationships that will be stored in the database
True
T/F: A database application is a collection of forms, reports, queries, and application programs that serves as an intermediary between users and database data
True
T/F: A database is a self-describing collection of integrated records
True
T/F: A database management system (DBMS) is a program used to create, process, and administer a database
True
T/F: A foreign key is essential in relational databases to represent the relationship between two tables
True
T/F: A key is a column or group of columns that identifies a unique row in a table
True
T/F: A many-to-many (N:M) relationship means that more than one entity is allowed on each side of the relationship and that the number of entities on each side can be different.
True
T/F: A spreadsheet can be used to store data if the structure of a list is simple
True
T/F: An identifier is an attribute or a group of attributes whose value is associated with one, and only one, entity instance
True
T/F: Attributes are used to describe characteristics of entities
True
T/F: Browser database application forms, reports, and queries are displayed and processed using html5, css3, and JavaScript
True
T/F: Browser-based applications are more dynamic and better suited to today's world than older database applications
True
T/F: In the case of single-user databases, the application, the DBMS, and the database all reside on the user's computer
True
T/F: Locking must be used to coordinate the activities of users in order to prevent the lost-update problem
True
T/F: Minimum cardinalities represent the lower limit on the number of entities required in a relationship
True
T/F: MySQL is an open source DBMS product that is license-free for most database applications
True
T/F: NoSQL means nonrelational databases that support very high transaction rates processing relatively simple data structures, replicated on many servers in the cloud
True
T/F: One of the functions of a DBMS is to provide tools to assist in the administration of a database.
True
T/F: Reports refer to the structured presentation of data using sorting, grouping, filtering, and other operations
True
T/F: SQL is an international standard language for processing a database
True
T/F: Special data that describes the structure of a database is called metadata
True
T/F: The crow's-foot notation in an E-R diagram shows the maximum number of entities that can be involved in a relationship
True
T/F: The data integrity problem occurs only if data are duplicated
True
T/F: The format of metadata depends on the software product that is processing the database
True
T/F: The general goal of normalization is to construct tables such that every table has a single topic or theme
True
T/F: To modify an existing table, a developer can open the metadata form for that table and add a new row of metadata.
True
T/F: Users are the final judges as to what data the database should contain and how the records in that database should be related to one another
True
Relational databases represent relationships using ________. A) foreign keys B) file systems C) metadata D) unique identifiers
a
