CP102 Lecture Notes - Lecture 14: Foreign Key, Unique Key, Data Warehouse
Document Summary
Field: a category of information in a database is stored in a field. Basically the headers to the columns: records and tables: the group of data for one item across related fields is called a record. The rows of the table: primary key: each record should have one field that has a value unique to that record, which is a primary key, types of databases. Most common form of output for any database is a printer (or electronic) report o relational. This is the primary key of another table that is included in a table for purposes of establishing relationships with that other table. Data storage: a data warehouse is a large-scale electronic repository of data that contains and organizes in one place all the data related to an organization. They consolidate information from separate data sources and organize the data by subjects: populating data warehouses. Source data can come from three places: internal sources (ex.
