click below
click below
Normal Size Small Size show me how
CIW~Exam
Lesson 6 Databases and Web Search Engines
| Question | Answer |
|---|---|
| • Database | – an organized collection of information that pertains to a particular subject or purpose |
| o Table | – a collection of data about a specific topic, organized into columns and rows |
| o Field | – a category of information in a table (a column) |
| o Record | – a collection of information consisting of one or more related fields about a specific entity (a row) |
| • Relational database | – a database that contains multiple tables related through common fields |
| o Common field | – a field, contained in two or more tables, that forms a relationship between the tables |
| o Relationship | – a connection between two or more tables based on a common field o Relating tables eliminates the duplication of data |
| o The common field | is the primary key in one table and the foreign key in another table |
| Primary key | – a field containing a value that uniquely identifies each record in a table |
| Foreign key | – a field in a related table that refers to the primary key in another table |
| • Query databases using: | o Menu queries (drop-down menu) o Query by example (keyword search) o Query languages, such as SQL (customized search) |
| o Search engine | – uses a robot or spider program to browse the Web following hyperlinks, and index the content that it finds |
| o Information portal | – only finds Web sites based on manual submissions |
| • Boolean operators | – symbols or words used to narrow Internet search results by including or excluding certain words or phrases from the results |
| o Popular | – generally bases information on secondary resources |
| o Scholarly | – bases its research on primary resources |