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