22 terms

CIW IBA lesson 6 vocab

STUDY
PLAY
database
a collection of data that can be sorted and searched using search algorithms
table
a collection of data about a limited topic, organized into rows and columns in a database
field
a category of information in a database table
record
a collection of information in a database table consisting of one or more related fields about a specific entity, such as a person, product or event
relational database
a database that contains multiple tables related through common fields
common field
a field contained in two or more database tables that forms a connection between the tables
relationship
a connection between two or more database tables that is based on a field that the tables have in common
primary key
a field containing a value that uniquely identifies each record in a database table
foreign key
a field in a related database table that refers to the primary key in the primary table
one-to-one relationship
in databases, a relationship in which each record in Table A can have only one matching record in Table B, and vice versa
one-to-many relationship
in databases, a relationship in which a record in Table A can have multiple matching records in Table B, but a record in Table B has only one matching record in Table A
many-to-many relationship
in databases, a relationship in which one record in Table A can relate to many matching records in Table B, and vice versa
junction table
a database table containing foreign-key fields that refer to the primary-key fields from the primary tables in a many-to-many relationship
query
a question posed by a user to a database to request database information; the database returns the query results based on the criteria supplied by the user in the query
Structured Query Language (SQL)
a language used to create and maintain professional, high-performance corporate databases
database management system (DBMS)
a program used to store, access and manipulate database information
Common Gateway Interface (CGI)
a program that processes data submitted by the user; allows a Web server to pass control to a software application, based on user request; the application receives and organizes data, then returns it in a consistent format
search engine
a powerful software program that searches Internet databases for user-specified information
keyword
a word that appears on a Web page and is used by search engines to identify relevant URLs
meta search engine
a search engine that scans Web pages for <meta> tag information
index
a catalog of the contents of a database; each entry identifies a unique database record
Boolean operator
a symbol or word used in Internet searches to narrow search results by including or excluding certain words or phrases from the search criteria