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.
