Lesson 6 Flashcards
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.
Common field
A field contained in two or more database tables that forms a connection between tables
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- keys 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 common to be used as keywords.
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 databases, a relationship a record in Table A can have multiple matching records in Table B, and vice versa.
Database
A collection of data that can be sorted and searched using search algorithms.
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.
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 supplied by the user in the query.
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.
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.
