Databases-Unit 6 CIS
The DBMS subsystem that allows for data recovery, support, and maintaining and securing the database is called the ________ subsystem.
Data Administration
What element of a database field specifies the data in a field such as text, numeric, or date/time?
Data type
Because Microsoft Access includes not only the software needed to create a database, but also the software needed to create forms, reports, data dictionaries and other capabilities, it is often referred to as a Database ________ System.
Management
SQL (Structured query language)
One of the most popular query languages
Fields
Should be chosen because they uniquely identify each data category you need to capture
When you make an online purchase and enter your shipping or billing information, you're actually filling out a form that was generated by a database management system. The DBMS subsystem that allows for form creation is the ________ generation subsystem.
application
Amazon.com allows you to search for thousands and thousands of items using images and information that are organized logically. This much storage and management requires a complex ________.
database
Because he wanted to be able to sort gifts according to continent and time zone, in 1984 Santa switched from using long lists to using ________.
databases
An integral part of a database management system (DBMS) is the Data Definition subsection. This subsection uses a data schema, also called a data ________.
dictionary
A database that stores data in different physical locations and that users access though client/server networks is called a ________ database.
distributed
In a database a ________ is a group of related characters in a database table that represents a characteristic of someone or something.
field
When you need to link two tables in a database that don't have a field in common, one solution is to create a ________ in one table that links to the primary key in the other table.
foreign key
To control how information is entered into a database, programmers and database administrators create ________ to help ensure data integrity.
forms
Databases are built by starting with single characters of data, organizing the data into fields, organizing the related fields into records, the records then make up a table. This organization is referred to as a data ________.
hierarchy
Adam was in the fifth grade when he was adopted by the Smith's. Because his school used a centralized database, all of his teachers had his correct name on their grade reports. This is an example of how a centralized database can help improve data ________.
integrity
The DBMS engine provides an interface for the end user of the database. This interface is called the ________ view.
logical
A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a(n) ________ database.
multidimensional
To search a database for information, create a ________.
query
Query
question, a request for information from a table in a database; info is generated using specific query language; can filter based on specific criteria, calculate/summarize data, and automate data management risks
In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a ________.
record
A link between tables in a relational database that defines how the data is related is called a ________.
relationship
To display or distribute information from a database, programmers or database administrators create ________.
reports
A collection of related records in a database is referred to as a ________.
table