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