Question | Answer |
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 rows and columns 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, such as a person, product or event. |
relational | A database that contains
multiple tables related through common fields. |
database | A collection of data that can be sorted and
searched using search algorithms. |
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 recod in a database |
one-to-one relationship | a relationship in which each record in table a can have one matching record in B |
foreign key | a field in a related database table that refers to the primary key in the primary table |
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 refer to the primary key fields from the primary tabels in many to many relationship |
query | a question posed by a user to a database to request database information |
SQL | a language used to create and maintain professional high performance corporate databases |
DBMS | A program
used to store, access and manipulate database
information. |
CGI | a program that processes data submitted by the user. |
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.
Some words, such as "the" or "and," are too common
to be used as keywords. |
meta search engine | search engine that scans
Web pages for <meta> tag information. |
index | catalog of the contents of a database. Each
entry identifies a unique database record. |
boolean operator | A symbol or word used in
Internet searches to narrow search results by
including or excluding certain words or phrases from
the search criteria. 5-3 |