| A | B |
|---|
| old search engine algorithm | key word frequency |
| Google search algorithm | # of links to page from other pages |
| Databases used every day | ATM, online banking, airline reservations |
| application | program to turn a computer into a productive tool |
| database program | runs and maintains a database |
| database | a computerized collection of information |
| erosion of this caused by ubiquity of databases | privacy |
| large amounts of information | easily handled by databases |
| text field | ABCDEFG |
| computational field | 65-47= |
| date field | 1/12/2012 |
| text files | sources of database imports |
| sorting | arranging in alphabetical or numeric order |
| report | most common printout from a database |
| function not performed by database itself | printing form letters |
| Entity | thing being represented in a database |
| attribute | things that describe entitites |
| primary key | a unique attribute for each entity |
| records | complete information about an entity in a table |
| columns | an attribute, listed for each entity in a table |
| rows | records/instances of an entity |
| foreign key | attribute that refers to the primary key of another entity |
| cardinality | relationship between data tables/how tables relate to each other |
| relational database | multiple tables of data that relate to each other through special key fields |
| flat file database | contain a single table of data |
| table | flat collection of entitites in a database, has rows and columns |
