Chapter 11 Part THREE (CGS2100)
About this set
Created by:
MeliBrown2323 on April 18, 2012
Subjects:
Log in to favorite or report as inappropriate.
Order by
15 terms
Terms | Definitions |
|---|---|
 Browsing? | Viewing records |
| Sort? | Organizing it in new fashion |
| Query? | A question or inquiry |
| Database query? | A question you ask the database so that it provides you with the records you wish to view |
| Relationship? | A link b/t tables that defines how the data is related |
| One-to-one relationship? | Indicates that for each record in a table there is only one corresponding record in a related table |
| One-to-many relationship? | Characterized by a record in one table |
| Many-to-many relationship? | Characterized by records in one table being related to multiple records in a second table and vice versa |
| Normalization? | Process of recording data only once in a database to reduce data redundancy |
| Foreign key? | The primary key of another table that is included for purposes of est. relationships with that other table |
| Referential integrity? | For each value in the foreign key of one table |
| Time-variant data? | It doesn't all pertain to one period in time |
| Clickstream data? | Info captured about each click that users make as they navigate a web site |
| Data staging? | A 3 step process: Extracting data from source databases, transforming the data, storing data in a data warehouse |
| Data mart? | Small slices of a data warehoue |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.