| A | B |
|---|
| database | an organized collection of information that pertains to a particular subject or purpose |
| table | a collection of data about a specific topic, organized into columns and rows |
| field | a category of information in a table (a column) |
| record | a collection of information consisting of one or more related fields about a specific entity (a row) |
| relational database | a database that contains multiple tables related through common fields |
| common field | a field, contained in two or more tables, that forms a relationship between the tables |
| relationship | a connection between two or more tables based on a common field |
| relating tables | eliminates the duplication of data and saves time |
| Primary key | a field containing a value that uniquely identifies each record in a table |
| foreign key | a field in a related table that refers to the primary key in another table |
| One-to-one relationship | each record in Table A can have only one matching record in Table B |
| one-to-many relationship | a record in Table A can have many matching records in Table B, but a record in Table B has only one matching record in Table A (the most common table relationship) |
| many-to-many relationship | one record in either Table A or B can relate to many matching records in the other table |
| structured query language | the standard interactive and programming language for accessing information from and updating information in relational databases |
| search engine | a powerful software program that makes it easy to find information on the Internet |
| informational portal | only finds Websites based on manual submissions |
| directory search | search engine displays a list of categories and subcategories that you can browse to find information |
| keyword search | you enter keywords in a search engine to query an index |
| Boolean operators | symbols or words used to narrow Internet search results by including or excluding certain words or phrases from the results |
| Common Gateway Interface | A program that processes data submitted by the user. Allows a Web server to pass control to a software application, based on user request. The application receives and organizes data, then returns it in a consistent format |
| database management system | A program used to store, access and manipulate database information |
| meta search engine | A search engine that scans Web pages for <meta> tag information |
| index | a catalog of the contents of a database.Each entry identifies a unique database record |
| query | a question posed by a user to database to request database information. |
