Shared Flashcard Set

Details

CIW IBA Curriculum Lesson 06:
Databases and Web Search Engines
22
Computer Science
Professional
01/13/2014

Additional Computer Science Flashcards

 


 

Cards

Term
Database
Definition
A collection of data that can be sorted and searched using search algorithms.
Term
Table
Definition
A collection of data about a limited topic, organized into rows and columns in a database.
Term
Field
Definition
A category of information in a database table.
Term
Record
Definition
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 thing.
Term
relational database
Definition
A database that contains multiple tables related through common fields.
Term
common field
Definition
A field contained in two or more database tables that forms a connection between the tables.
Term
Relationship
Definition
A connection between two or more database tables that is based on a field that the tables have in common.
Term
primary key
Definition
A field containing a value that uniquely identifies each record in a database table.
Term
foreign key
Definition
A field in a related database table that refers to the primary key in the primary table.
Term
one-to-one
Definition
relationship In databases, a relationship in which each record in Table A can have only one matching record in Table B, and vice versa.
Term
one-to-many
Definition
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.
Term
many-to-many
Definition
relationship In databases, a relationship in which one record in Table A can relate to many matching records in Table B, and vice versa.
Term
junction table
Definition
A database table containing foreignkey fields that refer to the primary-key fields from the primary tables in a many-to-many relationship.
Term
Query
Definition
A question posed by a user to a database to request database information. The database returns the query results based on the criteria supplied by the user in the query.
Term
Structured Query Language (SQL)
Definition
A language used to create and maintain professional, highperformance corporate databases.
Term
Database Management system (DBMS)
Definition
A program used to store, access and manipulate database information.
Term
Common Gateway Interface (CGI)
Definition
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.
Term
search engine
Definition
A powerful software program that searches Internet databases for userspecified information.
Term
Keyword
Definition
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.
Term
meta search engine
Definition
A search engine that scans Web pages for meta tag information.
Term
Index
Definition
A catalog of the contents of a database. Each entry identifies a unique database record.
Term
Boolean operator
Definition
A symbol or word used in Internet searches to narrow search results by including or excluding certain words or phrases from the search criteria.
Supporting users have an ad free experience!