Managing%20Information%20%26%20People

Managing20information202620people

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Managing Information & People People Databases, Data Databases, Warehouses, Data Marts Warehouses, Databases everywhere Databases For Competitive Advantage – Jiffy Lube (CRM) – Customer information for better service For Problem solving, Decision making: – World Bank (KMS) – IMDB (Internet Movie Database) – Databases for your PDA Databases PDA – Realtor.com Library Databases Library Purpose of Database Purpose Keep track of things All data in one place Allows for complexity and relationships Allows among data among Allows for more than one “theme” One theme spreadsheet One Multiple theme database Multiple What is a Database? What Self-describing collection of integrated Self-describing records records – Columns are fields – Rows are records – Group of similar records (rows) called table Group (or file) (or One table per theme Parts of a Database Parts Tables (files) Relationships among records (rows) Metadata – data about data Example of a Table Example Parts of a Database Parts Tables (files) Relationships among records (rows) Metadata – data about data Relationships among records Relationships Relationships among records Relationships A primary key is a field that identifies a primary unique row in a table (CustID) unique A foreign key is a field in one table that is foreign NOT the primary key in THAT table but IS the primary key in another table (SKU#) the Relationships among records Relationships Primary Keys Foreign Keys Primary Key Foreign Key because it is the primary key in the inventory table May want to link these Primary key is CustID because only one CustID per person Primary key is SKU# because only one SKU# per item Parts of a Database Parts Tables (files) Relationships among records (rows) Metadata – data about data Metadata Metadata Description of the format of the data to be entered in the database (i.e., metadata) What is a Database? What Self-describing collection of integrated collection integrated records records METADATA...
View Full Document

This note was uploaded on 03/17/2009 for the course BCOR 2500 taught by Professor Adams during the Spring '08 term at Colorado.

Ask a homework question - tutors are online