This preview shows page 1. Sign up to view the full content.
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
This note was uploaded on 09/08/2010 for the course BUS 188 at San Jose State University .