w4_3_Data Knowledge Mgmt 2_Sp12

w4_3_Data Knowledge Mgmt 2_Sp12 - Data and Knowledge...

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

View Full Document Right Arrow Icon
Data and Knowledge Management 2 Agenda 1. Review 2. Data & Knowledge Management (cont.) DBMS ER Diagram Database: Relational; Multidimensional OLAP IE 332 2.3.12
Background image of page 1

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

View Full DocumentRight Arrow Icon
Review Normalization DBMS MERP: What are the views? 2
Background image of page 2
Entity-Relationship Diagram ring and dash A has zero or one B dash and dash A has exactly one B ring and crow's foot A has zero or more B dash and crow's foot A has one or more B A A A A B B B B 3
Background image of page 3

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

View Full DocumentRight Arrow Icon
ER Diagram Practice Student Class 2 1 4 3 A B 4
Background image of page 4
Normalization Normalization is a method for analyzing and reducing a relational database to its most streamlined form for: Minimum redundancy Maximum data integrity Best processing performance Normalized data is when attributes in the table depend only on the primary key. 5
Background image of page 5

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

View Full DocumentRight Arrow Icon
Non-Normalized Relation 6
Background image of page 6
Normalizing the Database (part A) 7
Background image of page 7

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

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

This note was uploaded on 02/22/2012 for the course IE 332 taught by Professor Staff during the Spring '08 term at Purdue University.

Page1 / 31

w4_3_Data Knowledge Mgmt 2_Sp12 - Data and Knowledge...

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

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