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
Record
A collection of information in a data table consisting of one or more related fields about a specific entity
Relational Database
A database that contains multiple tables related through common fields
Relationship
A connection between two or more data tables that is based on a field that the tables have in common
Search engine
A powerful software problem that searches internet databases for user specified information
Structured Query Language
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
