Chapter 2 Quiz

Question 1

Which of the following two-dimensional structures is known as a relation?

Answer 1

table

Question 2

Which of the following is not a valid component of object-oriented data models?

Answer 2

volume

Question 3

Why is identifying and documenting business rules essential to database design?
a. It can be a communication tool between users and managers.
b. It allows the designer to manage business processes.
c. It helps to standardize the company’s view of data.
d. It allows the user to understand relationship participation rules and constraints.

Answer 3

c

Question 4

Which of the following entity relationship (ER) connectivity statements is invalid?
a. PAINTER paints many PAINTINGs
b. An EMPLOYEE learns many SKILLs
c. An EMPLOYEE manages a STORE
d. A CUSTOMER gender is MALE or FEMALE

Answer 4

d

Question 5

Which of the following is a disadvantage of various database models?

Answer 5

system complexity

Question 6

A CEO of a company wants to find a new and improved way to manage and extract business insights from large amounts of web- and sensor-generated data. Which of the following could they use to achieve this goal?

Answer 6

big data

Question 7

Which of the following technologies is not used in Big Data?

Answer 7

SQL

Question 8

Which of the following is not a valid business rule?
a. An invoice may have many items.
b. A customer must reside in the USA.
c. An invoice can only be paid to one customer.
d. An invoice must be paid in a reasonable amount of time.

Answer 8

d

Question 9

Which of the following is a fundamental data modeling component, helping ensure data integrity?

Answer 9

constraint

Question 10

In an entity relational model (ERD), what is each row in a table known as?

Answer 10

entity occurrence