Databases
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
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
A collection of related records in a database is referred to as a _____
table
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
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 (In a relational database, a common field that links two tables in a relationship but is not a primary key is called a foreign key.)
The reliability and the accuracy of the information in a database is referred to as data ________.
Integrity (Data centralization (keeping data in one database) helps increase data integrity.)
A complex database that organizes and stores information in a cube format and has measure attributes and feature attributes is called a ________ database.
Multidimensional
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
The DBMS subsystem that allows for data maintenance and data analysis, including providing the capability to create queries, reports, and forms is referred to as the data ________ subsystem.
To allow for the creation of queries, most database management systems incorporate a structured query language (SQL) into the data manipulation subsystem
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 type of data will be included
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
In the datasheet view of a relational database (such as Microsoft Access) a row of information is called a
record
The type of database that uses common fields to create links between tables is called a ________ database.
relational
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
Forms structure data input to help ensure data ________, meaning the information entered is accurate, timely, and useful.
Integrity
You need to purchase concert tickets for your friends. You go to StubHub.com to find them. In StubHub.com you can search between hundreds of seats in thousands of venues and thousands of events. To organize this information in a searchable manner, StubHub uses a complex ________.
database
A database that stores data in different physical locations and that users access though client/server networks is called a ________ database.
distributed
In a relational database, an important field that contains a unique value that identifies each record as individual is the ________ key.
primary
A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a ________.
query
In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a ________.
record
