Database components
a collection of data that can be sorted and searched using search algorithms.
contained in two or more database tables that forms a connection between the tables
Common Field
designed to enable an operating system to access databases from various vendors
Open Database Connectivity (ODBC)
When specifying keywords to conduct an Internet search, which of the following parts of speech will be the most useful?
Nouns
requires the search results to include multiple keywords.
AND operator
a category of information in a table.
Field
A database that contains multiple tables related through common fields.
Relational Database
method by which data is passed back and forth between the server and the application program
Common Gateway Interface (CGI)
an HTML element used in a Web page to embed information for use by search engines.
meta-tags
find a multi-word phrase with the words in a specified order?
Quotes ""
A collection of data about a limited topic, organized into rows and columns in a database.
table
A connection between two or more database tables that is based on a field that the tables have in common.
Relationship
Which language should you use to create and maintain large relational databases?
SQL
Search engines use automated programs to find relevant websites by reading each site's source code embedded in the <meta> tags.
bot or spider
Used to narrow search results by including or excluding words or phrases
Boolean Operators
a collection of information consisting of one or more related fields about a specific entity, such as a person, product or event
Record
A field containing a value that uniquely identifies each record in a database table.
How can database information be provided to users via the Web?
By connecting a Web server to a database server
bases its research on primary resources.
Scholarly
Patrick wants to search for Fender guitars other than Stratocasters. He plans to use a keyword search engine. He does not want to see any results for Stratocaster guitars, only other Fender models. Which of the following search strings should he use?
guitar Fender !Stratocaster
Provide 3 examples of how databases are used and provide an appropriate primary key example for each.
School - student records, primary key - student ID
Work - Payroll records, Employee ID
Business - customer records, customer ID or Transaction #
List and explain the 3 types of relational databases.
A one-to-one relationship is a database table relationship in which each record in Table A can have only one matching record in Table B, and vice versa.
one-to-many relationship - a database table 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 - one record in Table A can relate to many matching records in Table B, and vice versa.
List 4 ways that an Internet server can use a database in a business environment.
Company sales data
Banking
Web storefronts
Web search engines
List and explain the three categories of resources on the Internet:
Primary — source material that has not been edited or compiled in a significant way by a researcher.
secondary - research based on primary resources, preferably by a credible individual or group.
Indexes — encyclopedias and reference material that list additional titles.
List and explain 5 boolean operators.
AND, & Results must include both words.
OR, | Results must include at least one of the words.
+ (plus sign does not work in advanced search)
Results must include the word specified after
the operator.
NOT, !, -
(minus sign does not work in advanced search)
Results must exclude the word specified after
the operator.
NEAR, ADJ (adjacent), FAR, BEFORE Two keywords on a page must be within a
certain proximity to each other (near or far).
" " Keywords must appear in phrases in the order
specified.
( ), < >, [ ], { } Boolean operator phrases must be performed in
the order specified.
* (Example: color* will return color, colors,
colorize, Colorado, etc.)
The root word can include variations in
spelling. This Boolean operator is called a
wildcard character.