Chapter 2

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

a. A CUSTOMER gender is MALE or FEMALE

Which of the following is a fundamental data modeling component, helping ensure data integrity? a. Constraint b. Entity c. Attribute d. Relationship

a. Constraint

Within the database environment, a data model represents data structures and their attributes, relations, constraints, and transformations with the purpose of supporting a specific problem domain. Define "problem domain" in the context of data models. a. a clearly defined area within a real-world environment that will be systematically addressed b. the process of creating a specific data model for a particular set of real-world data to be addressed c. a blueprint containing all necessary instructions for building a database that will meet all end-user requirements d. a relatively simple and usually graphical representation of complex real-world objects or events

a. a clearly defined area within a real-world environment that will be systematically addressed

In the context of relational databases, a column in a relational table is associated with the _____(s) of a real-world person, place, thing, or event. a. attributes b. entity c. constraints d. relationships

a. attributes

When creating a student roster, a school cannot enroll more than 20 students per course. This is an example of what data modeling building block? a. constraint b. relationship c. attribute d. entity

a. constraint

Sarah is working on a design that has physical independence and needs to make a change. Which change will not affect the internal model? a. storage methods b. internal schema c. logical design d. external model

a. storage methods

In the context of Laney's 3 Vs of Big Data databases, which term refers to the fact that data is collected in multiple data formats? a. variety b. volume c. velocity d. vendor

a. variety

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? a. The 3Vs b. Big data c. The internet of Things (IoT) d. Hadoop

b. Big data

Determine which of the following simple-language expressions represents a valid constraint. a. EMPLOYEE manages STORE b. Each CONTAINER contains between 0 and 100 UNITs. c. STUDENT takes CLASS d. CUSTOMER generates INVOICE

b. Each CONTAINER contains between 0 and 100 UNITs.

Ali needs to review the metadata of a file system. Where should they look? a. Client node b. Name node c. Data node d. Map node

b. Name node

Which of the following is a disadvantage of various database models? a. Database security b. System complexity c. Data sharing d. Visual modeling

b. System complexity

Which of the following is true of NoSQL databases? a. They are geared toward transaction consistency rather than performance. b. They are not based on the relational model. c. They do not support very large amounts of sparse data. d. They do not support distributed database architectures.

b. They are not based on the relational model

Which of the following is true of business rules? a. They allow the designer to develop business processes. b. They can serve as a communication tool between the users and designers. c. They allow the designer to set company policies with regard to data. d. They provide a framework for the company's self-actualization.

b. They can serve as a communication tool between the users and designers.

Kaiden is wanting to ensure there is proper facilitation of communication between the designer, application programmer, and the end user. What should the most important part of his process be? a. To avoid major legal consequences b. To distinguish between objects in the problem domain. c. To identify the relationship type between entities d. To verify perceptions of end-users and reconcile differences

b. To distinguish between objects in the problem domain

When identifying types of relationships represented by business rules, consider that relationships between entities are _____. a. one-way b. bidirectional c. constraint-less d. always many-to-many

b. bidirectional

A noun in a business rule translates to a(n) _____ in the data model. a. relationship b. entity c. constraint d. attribute

b. entity

Which of the following models operate at the lowest level of abstraction and is both hardware and software dependent? a. internal b. physical c. conceptual d. external

b. physical

Jackie is working in a database entering information on employees using the following format: EMPLOYEE.LAST_NAME .This indicates the attribute LAST_NAME from the EMPLOYEE in what? a. entity b. table c. rows d. column

b. table

When identifying and documenting business rules, it is important to recognize that despite being crucial contributors to the development of business rules, it pays to _____ the end-user's perceptions of business operations. a. prioritize b. verify c. describe d. ignore

b. verify

Which of the following types of HDFS nodes acts as the interface between the user application and the HDFS? a. Data node b. Map node c. Client node d. Name node

c. Client node

Which of the following technologies is not used in Big Data? a. NoSQL b. Hadoop c. SQL d. MapReduce

c. SQL

Which of the following is not a valid component of object-oriented data models? a. Object b. Class c. Volume d. Attributes

c. Volume

Your manager has requested a report that gives them a global view of the entire database being used as the basis for the identification and high-level description of main data objects without model-specific details. Which model or schema would you provide them? a. physical b. external c. conceptual d. internal

c. conceptual

Sally's Dog Grooming Salon is creating a database of every dog she grooms. She wants to collect specific information about the breed, height, weight, and age of each dog. What building block does "dog" represent in her data model? a. relationship b. class c. entity d. attribute

c. entity

Business rules must describe the main and distinguishing features of the data as viewed by _____. a. the end-users b. the application programmer c. the company d. the designer

c. the company

In an entity relational model (ERD), what is each row in a table known as? a. An entity relation b. An entity tuple c. An entity set d. An entity occurrence

d. An entity occurrence

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

d. An invoice must be paid in a reasonable amount of time.

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

d. It helps to standardize the company's view of data.

Which of the following two-dimensional structures is known as a relation? a. Entity b. Tuple c. File d. Table

d. Table

Different views of the data are less likely to cause problems or conflicts when a database offers which of the following? a. documentation system b. management system c. physical server d. blueprint

d. blueprint

Comel, a student, takes four classes with her group of best friends. She sits in the front row with two friends and the others sit behind them. What type of relationship would Comel's situation be described as? a. one-to-many b. hierarchical c. one-to-one d. many-to-many

d. many-to-many

A verb associating two nouns in a business rule translates to a(n) _____ in the data model. a. attribute b. entity c. constraint d. relationship

d. relationship

Sally is more concerned with data location, formatting, and specific reporting requirements. Which describes Sally's role? a. the end users b. the purchasing manager c. the inventory manager d. the applications programmer

d. the applications programmer

What conceptual model is being used if an entity-relationship diagram (ERD) is being used? a. the external model b. the physical model c. the internal model d. the conceptual model

d. the conceptual model

A company's business response time is reflective of the _____ of their Big Data database storage and processing. a. analysis b. variety c. volume d. velocity

d. velocity