Lesson 6 Flashcards
Boolean
A symbol or word used in internet searches to narrow search results by including or excluding certain words or phrases from the search criteria
Database
A collection of data that can be sorted and 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
juction table
A database table containing foreign key fields that refer to the primar- key fields from the primary tables in many-to-many-relationships
Common field
A field contained in two or more database tables that forms a connection between the tables
Keyword
A word that appears on a web page and is used by search engines to identify relevent URL’s. Some words such as “the”or “and” are too common to be used as keywords
Many-to-many-relationships
Indatabases, 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 relationships
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
One-to-one relationships
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 datbase to request database information. Database returns the query results based on the criteria supplied by the user in query
