Lesson 6 Vocabulary

21 cards·by gsewsankar31

Boolean operator

A symbol or word used in Internet searches to narrow search results by including orexcluding certain words or phrases from the search critea

Common field

A field contained in two or more database tables that forms a connection between the tables.

Database

A collection of data that can be sorted or searched using search algorithms.

Database Management System (DBMS)

A program used to store, access and manipulate database information.

Field

A category of information in a database table.

Foreign key

A field in a related database table that refers to the primary key in the primary table.

Index

A catalog of the contents of a database. Each entry identifies a unique database record.

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.

Keyword

A word that appears on a Web page and is used by search engines to identify relevant URLs. Some words, such as "the" or "and," are too commo

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.

Meta search engine

A search engine that scans Web pages for tag information.

One-to-many relationship

In database, 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

One-to-one relationship

In database, a relationship in which record in Table B, and vice versa.

Primary Key

A field containing a value that uniquely identifies each record in a database table.

Query

A question posed by a user to a database to request database information. The database returns the query results based on the criteria suppl

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

Relational Database

A database that contains multiple tables related through common fields.

Relationship

A connection between two or more database tables that is based on a field that the tables have in common.

Search Engine

A powerful software program that searches Internet databases for user-specified information.

Structured Query Language (SQL)

A language used to create and maintain professional, high-performance corporate databases.

Table

A collection of data about a limited topic, organized into rows and columns in a database.