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 |