cgs - databases

Select the advantages of using a database instead of a traditional filing system.

A database can hold larger amounts of data, A database can provide better data integrity

What element of a database field specifies the data in a field such as text, numeric, or date/time?

Data type

Select what's true about object-oriented databases

Store instructions for how to compute the data as well as the data to be processed, Equipped to handle unstructured data such as MP4 files, videos, images, and extremely large files, Use Object Query Language to construct queries that extract data from the database

Large databases, often called data banks, that cover particular subjects are referred to as ________ databases

commercial

The DBMS engine provides an interface for the end user of the database. This interface is called the ________ view

logical

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 it can store virtually unlimited amounts of data that can be shared across networks, and because the data can be kept far more accurately, a ________ has many advantages over a traditional filing system

database

A database that stores data in different physical locations and that users access though client/server networks is called a ________ database

distributed

Forms structure data input to help ensure data ________, meaning the information entered is accurate, timely, and useful

integrity

When you receive a utility bill, you're actually getting a report that was generated by a database management system. The DBMS subsystem that provides for data maintenance, analysis, and the generation of reports is called the data ________ subsystem

manipulation

A collection of related records in a database is referred to as a ________

table

You own a pet care center. What fields might you enter when you create a table for dogs that you care for?

Owner's last name, Pet's name, Owner's address

Your college has a database with a Students table. Which of the following could be a primary key in the table?

Student number, social security number

The data definition, as described in the data dictionary, tells users how each unit of data is defined in the database. Which of the following elements will be used to describe the data?

What field name will the data fall under, What data type will be included

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

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

The interfaces for the logical view of a database and the physical view of a database are provided by the DBMS ________

engine

In a database a ________ is a group of related characters in a database table that represents a characteristic of someone or something

field

In a relational database, a common field that links two tables in a relationship but is not a primary key is called a ________ key

foreign

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

The DBMS subsystem that provides programming language interfaces, allowing programmers to create visually appealing data entry screens, is called the application ________ subsystem

generation

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 reliability and the accuracy of the information in a database is referred to as data ________

integrity

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

A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ________ database

multidimensional

A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a ________

query

To search a database for information, create a ________

query

In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a ________

record

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