Unformatted text preview: stored.-Entity Classes (table) – collection of similar entities-Attributes (fields or columns) – characteristics or properties of an entity class. Keys and Relationships-Primary key – field that uniquely identifies a given entity in a table.-Foreign Key – in a relational database model is a primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables. Data Warehouse (pp. 192-193) Def – a logical collection of information – gathered from many different operational database – that supports business analysis activities and decision making tasks. ETL – Extraction, Transformation, and loading – this is used to extract data internally and externally than transform the data in to common set of enterprise definitions and loads the information to data warehouse. Data Mart – contains a subset of data warehouse information....
View Full Document
- Business, Relational model, Mining (pp., Warehouse (pp., Good data base