CIS Study Set Structuring and Storing Data

A (n) _ rule defines how a company performs certain aspects of its business and typically results in either a yes/no or true/false answer.

Business

What is the smallest or basic unit of information?

Data element

Select the two terms representing the smallest or basic unit of information.

Data field and data element

What is the time it takes for data to be stored or retrieved?

Data latency

A (n)_ maintains information about various types of objects, events, people, and places.

Database

What creates, reads, updates, and deletes data in a database while controlling access and security?

Database management system

Select the statement that accurately defines the relationship between entities and attributes in a relational database.

Each attribute of an entity occupies a separate column of a table.

A (n) _ key is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables.

Foreign

What is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables?

Foreign key

_ management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Identity

What is a measure of the quality of information?

Information integrity

What is the duplication of data, or the storage of the same data in multiple places?

Information redundancy

The _ view of information focuses on how individual users logically access information to meet their own particular business needs.

Logical

What provides details about data?

Metadata

One primary goal of a database is to eliminate information redundancy by recording each piece of information in _ places (s) in the database.

Only one

A (n) _ key is a field (or group of fields) that uniquely identifies a given record in a table.

Primary

Which tool helps users graphically design the answer to a question against a database?

Query by example

Select the four functions that a database management system can perform on data in a database

Read, delete, create, update

Select three accurate statements reflecting the business advantages of a relational database.

Reduced information redundancy, increased information security, increased information integrity

What is a tool that asks users to write lines of code to answer questions against a database?

Structured Query Language

Business critical integrity constraints tend to mirror the very rules by which an organization achieves success.

True

Databases today scale to exceptional levels, allowing all types of users and programs to perform information processing and information searching skills.

True

Why does a database offer increased information security?

Various security features of database ensure that individuals have only certain types of access to certain types of information.

Select the statement below that accurately reflects a database.

While a database has only one physical view, it can easily support multiple logical views that provides fo flexibility.

Integrity _______ are rules that help ensure the quality of information

constraints

What compiles all of the metadata about the data elements in the data model?

data dictionary

What deals with the physical storage of information on a storage device?

physical view of information

What is a field that uniquely identifies a given record in a table?

primary key

A (n) _ database model stores information in the form of logically related two dimensional tables.

relational