| A | B |
|---|
| Database | collection of data that can be sorted and searched using search algorithms |
| Table | A collection of data about a limited topic, organized into rows and columns in a database |
| Field | A category of information in a database table |
| Record | A collection of in a information in a database table consisting of one or more related fields about a specific entity, such as a person, product or event |
| Relational Database | database that contains multiple tables through common fields |
| Common Field | A field contained in two or more database tables that forms 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 | In databases, a relationship in which each record inTable 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 a record in 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 matching records in Table B, and vice versa |
| Junction Table | A database table containing foreign key fields that refers to the primary-key fields from the primary tables in a many-to-many relationship |
| Query | A question posed by a user to a database to request 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 a Web server to pass control to a software application, based on user request. |
| 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 <Meta> tag information |
| Index | A catalog of the contents of a database |
| Boolean Operator | symbol or word used in Internet searches to narrow search results by including or excluding certain words or phrases from the search criteria |
| Menu query | You are offered a list of options in a menu from which to choose |
| Query by example | You specify the fields and data values to be used in a query |
| Query language | you use a specialized language called SQL to retrievean manipulate information in a database |
