A $\_\_\_\_\_$ is a description that involves "telling" the database management system $($DBMS$)$ the logical and physical structure of the data and the relationships among the data for each user.

Group of answer choices

query

record

schema

field

Flag question: Question $2$

Question $21$ pts

A $\_\_\_\_\_$ is a subset of a data warehouse that is used by small$-$ and medium$-$sized businesses and departments within large companies to support decision making.

Group of answer choices

data dictionary

data model

data mart

data mine

Flag question: Question $3$

Question $31$ pts

A $\_\_\_\_\_\_$ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Group of answer choices

data dictionary

schema

data definition language

data manipulation language

Flag question: Question $4$

Question $41$ pts

A$($n$)\_\_\_\_\_$ is a field or set of fields in a record that uniquely identifies the record.

Group of answer choices

attribute

entity

primary key

data item

Flag question: Question $5$

Question $51$ pts

At Coast$-$to$-$Coast Moving and Van Lines, Ryan is responsible for managing the flow of the company's data, from initial acquisition of new data to deletion of old, outdated data. Ryan is involved in $\_\_\_\_\_\_\_\_\_\_\_.$

Group of answer choices

$$data stewardship

$$data lifecycle management

$$database administration

$$data management

Flag question: Question $6$

Question $61$ pts

What is the primary difference between an entity and an attribute?

Group of answer choices

An attribute is a table; an entity is a column from the attribute table.

An entity is specific, where as an attribute is not data at all but brainstorming ideas that take place before the entity is created.

An attribute refers to applications, and an entity refers to executives.

An entity is information about people, places, or events, where as an attribute is a column or specific field of the data elements associated with an entity.

Flag question: Question $7$

Question $71$ pts

A data model is a diagram of data attributes and their relationships.

Group of answer choices

True

False

Flag question: Question $8$

Question $81$ pts

When you connect to the university library website to find out whether the library has an article you want to read, and the site then interacts with a database that contains a catalog of library books and articles to determine whether the book you want is available, the database management system functions as a$($n$)\_\_\_\_\_\_\_\_\_\_$ to query the database and provide the requested information to the website.

Group of answer choices

data dictionary

electronic exchange

back$-$end application

front$-$end application

Flag question: Question $9$

Question $91$ pts

Data warehouses allow managers to $\_\_\_\_\_$ to get increasing levels of detail about business conditions.

Group of answer choices

roll up

drill down

slice and dice

extract data

Flag question: Question $10$

Question $101$ pts

Each attribute in a relational database model can be constrained to a range of allowable values called a $\_\_\_\_\_.$

Group of answer choices

bandwidth

scope

slot

domain

Flag question: Question $11$

Question $111$ pts

Unstructured data comes from sources such as word$-$processing documents and scientific research.

Group of answer choices

True

False

Flag question: Question $12$

Question $121$ pts

Haley's employer has asked her to review tens of thousands of social media posts about their company's products and compile this data into a database.$$ In terms of the characteristics of big data, Haley is dealing with $\_\_\_\_\_\_\_\_.$

Group of answer choices

$$volume

$$variety

$$velocity

$$veracity

Flag question: Question $13$

Question $131$ pts

Some databases use $\_\_\_\_\_\_,$ which is a visual approach to developing queries and requests.

Group of answer choices

Query by Example $($QBE$)$

user views

Structured Query Language $($SQL$)$

data manipulation language $($DML$)$

Flag question: Question $14$

Question $141$ pts

Carlos is working with an existing database, but he wants to eliminate some of the columns in the table to create a new, more streamlined database. He will use projection to create his new database.$$

Group of answer choices

True

False

Flag question: Question $15$

Question $151$ pts

Suppose a new tech startup wants to define the data model. They would then $\_\_\_\_.$

Group of answer choices

collect and cleanse the data

define user access privileges

create the entity$-$relationship model

acquire a new database management system

Flag question: Question $16$

Question $161$ pts

The position of a $\_\_\_\_\_$ is a non$-$technical position responsible for defining and implementing consistent principles for setting data standards and data definitions that apply across all the databases in an organization.

Group of answer choices

data analyst

data administrator

database administrator

data owner

Flag question: Question $17$

Question $171$ pts

The smallest piece of data used by a computer is a$($n$)\_\_\_\_\_.$

Group of answer choices

entity

byte

bit

character