Lecture_Slides_03-02-11

Lecture_Slides_03-02-11 - ITM 309 Database and Data...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
1 ITM 309 Database and Data Warehouses (continued) Dr. Frederick Rodammer Michigan State University Eli Broad College of Business Rodammer@bus.msu.edu March 2, 2011
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 Today’s Learning Objectives Define Relational Database Fundamentals Understand the purpose of a Database Management System Understand Business Intelligence, Data Warehouse, s Case) Information Cleansing
Background image of page 2
3 CLOSING CASE TWO: Mining the Data Warehouse How is Ben & Jerry’s using business intelligence tools to remain competitive in a saturated market? What is Ben & Jerry’s key focus in using Business Intelligence from their data warehouse to gain a competitive advantage?
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
4 Primary keys and foreign keys identify the various entity classes (tables) in the database Primary key – a field (or group of fields) that uniquely identifies a given entity in a table Foreign key – a primary key of one table that appears an attribute in another table and acts to provide a logical relationship among the two tables RELATIONAL DATABASE FUNDAMENTALS
Background image of page 4
5 Traditional File Environment
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 16

Lecture_Slides_03-02-11 - ITM 309 Database and Data...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online