| A | B |
|---|
| Database | A collection of data that can be sorted and searched using search algorithms. |
| Table | A collection of data about a limited topic, organized into columns and rows in a database. |
| Field | A category of information in a database table. |
| Record | A collection of information in a database table consisting of one or more related fields about a specific entity. |
| Relational Database | A database that contains multiple tables related through common fields. |
| Common Field | A field contained in two or more database tables that form a connection between the tables. |
| Relationship | A connection between two or more database tables that is based on a field that the tables have in common. |
| Primary Key | A field containing a value that uniquely identifies each record in a database table. |
| Foreign Key | A field in a related database table that refers to the primary key in the primary table. |
| 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. |
| One-to-Many Relationship | In databases, a relationship in which a record in Table A can have multiple matching records in Table B, but Table B has only one matching record in Table A. |
| Many-to-Many Relationship | In databases, a relationship in which one record in Table A can relate to many records in Table B and vice versa. |
| Junction Table | A database table containing foreign-key fields that refer to the primary-key fields from primary tables in a many-to-many relationship. |
| Query | A question posed by a user to a database information. |
| Structured Query Language (SQL) | A language used to create and maintain professional, high performance corporate databases. |
| Database Management System (DBMS) | A program used to store, access and manipulate database information. |
| Common Gateway Interface (CGI) | A program that processes data submitted by the user. Allows Web servers to pass control to a software application, based on user request. The application receives and organizes data, then returns it in a consistent format. |
| Search Engine | A powerful software program that searches Internet databases for user-specified information. |
| Keyword | A word that appears on a Web page and is used by search engines to identify relevant URLs. |
| Meta Search Engine | A search engine that scans Web pages for tag information. |
| Index | A catalog of the contents of a database. Each entry identifies a unique database record. |
