Computers: Understanding Tech 6e 12.2
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| key | An attribute that can be used to identify a set of information and therefore provide a means to search or sort a database.
🗑
|
||||
| primary key | A database field that must contain only unique entries, such as unique ID numbers, so it can be used to locate records quickly. The database designer sets the most important field in a table as the primary key.
🗑
|
||||
| data browsing | An act that involves moving through a database file, examining each record, and looking for information.
🗑
|
||||
| file processing | Retrieving and performing some type of operation on database data.
🗑
|
||||
| query tool | A tool included in database management systems to help users select matching information from within a larger set of data.
🗑
|
||||
| query | A set of instructions that enables users to specify criteria designed to retrieve needed information from a database.
🗑
|
||||
| Structured Query Language (SQL) | A popular query language that enables users to request information from a database. SQL works with most databases, and can bridge communications gaps between different database systems.
🗑
|
||||
| SELECT command | The basic query command in SQL, which asks a database to return records that match specified criteria.
🗑
|
||||
| Query by Example (QBE) | A process in which the user builds a query by selecting one or more tables, adding the fields to display in the results in a query grid, and then entering the entry to match or other criteria in applicable fields.
🗑
|
||||
| joining | A situation in which a query returns data from more than one table by matching data from fields in the specified tables—commonly matching the primary key field in one table with the field holding the same type of data in another table.
🗑
|
||||
| security measures | Methods used in a database management system to protect and safeguard data.
🗑
|
||||
| metadata | Information about the elements in a database that describes the structure, specifications, and purpose of each element. Descriptive metadata also identifies other types of information, such as the metadata for a website.
🗑
|
||||
| data dictionary | A metadata repository that collects the body of metadata for the entire database.
🗑
|
||||
| legacy database | A database that runs using languages, platforms, or models that are no longer supported by an organization’s current database system.
🗑
|
||||
| recovery | Restoration of data. In a database recovery, the database administrator uses the most recent backup, which typically contains the most recent and accurate data.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
softcrylic
Popular Computers sets