Info 211 chapter 4

Brenda, the sales manager of a firm, wants to generate a report containing sales analyses of the second and third quarter of the year. She should use a ________ to obtain the information that she wants from the database. Group of answer choices form query application program report

???

________ products process large organizational and workgroup databases. Group of answer choices Personal DBMS Enterprise DBMS Application Program Forms and reporting

Enterprise DBMS

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. Group of answer choices N:M 1:1 M:1 1:N

N:M

Which of the following is an international standard language for processing a database? Group of answer choices Cassandra SQL DB2 MS Access

SQL

Which of the following is true about the database development process? Group of answer choices A database is a model of how the developers view their business world. User review of the data model is avoided as it is not helpful in data modeling. Changing a relationship from 1:N to N:M in an existing database is simply a matter of changing notations. The easiest time to change the database structure is during the data modeling stage.

The easiest time to change the database is structure is during the data modeling stage.

Which of the following is true of N:M relationships? Group of answer choices They are the same as N:N relationships. They represent minimum cardinalities in a relationship. They are also called one-to-many relationships. They can have more than one entity on each side of the relationship.

They can have more than one entity on each side of the relationship.

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 ________. Group of answer choices primary keys identifiers records entities

entities

Which of the following refers to the problem that exists in database apps when two users modify the same data item, but only one of those changes is recorded? Group of answer choices lost update problem bullwhip effect update query problem crow's foot paradigm

lost update problem

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) ________. Group of answer choices identifier primary key functionally dependent record foreign key

primary key

A(n) ________ is a search request for data from a database. Group of answer choices form report app query

query