Data Quiz 1

Based on the model below, which of the following statements is true? -Employees can be in many departments. -Departments can have many employees. -Departments must have at least one employee. -There is a zero to many relationships between department and employee. -Employees must report to a department.

-Departments can have many employees.

Which of the following is an example of a daily operational procedure or task supported by an operational database?

-Issuing a correct bill to a customer who purchased an airline ticket -Deducting the correct amount of money from a customer's checking account upon an ATM withdrawal -Retrieving a customer's account number using their first name, last name, and DOB

Consider the model below. The client's requirements have changed, and they now need to allow categories to contain no products. Which of the lettered symbols below would need to change to accommodate this? -a -b -c -d -e

B

Which of the following is a part of the database requirements step?

Conceptual modeling

A DBMS is software used for the purpose of

Database creation Maintenance of databases Insertion, storage, retrieval, update, and deletion of the data in the database

The description of the structure and the properties of the data best defines which category?

Metadata

characterization of ERP systems?

Reflect the best industry practices of the particular business process Deployment can be lengthy Typically facilitate processes uniform across industries Expensive and historically prone to implementation failure or delays

A _____________ can be used on ____________.

Relationship attribute; a M:N relationship only

Consider the Chen diagram below. If the client also wanted to store each employee's title (e.g., Vice President of Finance), this attribute would look like which attribute(s) below? Assume that multiple employees can have the same title -Phone -SSN -Age -Full name -Salary

Salary

Cheerios is an example of:

data

________ are in charge of implementing the database model as a functioning database using the DBMS software.

database developers

FirstName is an example of: -An entity -Data -DBMS -Metadata -Data Type

metadata

Product name is an example of

metadata

Minimum cardinality can specified as

optional or mandatory

Entities represent:

real-world notions or constructs that the database keeps track of

The first and most critical step in the development of the database is

requirements collection, definition, and visualization