Laudon_ch05

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: e (join table, Intersection relation) that links the two tables to join information 5.11 Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information The Database Approach to Data Management A Simple Entity-Relationship Diagram This diagram shows the relationship between the entities SUPPLIER and PART. Figure 5-3 5.12 Essentials of Business Information Systems Essentials Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information The Database Approach to Data Management • Normalization • Process of streamlining complex groups of data to: • Minimize redundant data elements • Minimize awkward many-to-many relationships • Increase stability and flexibility • Referential integrity rules • Used by relational databases to ensure that relationships between coupled tables remain consistent • E.g. When one table has a foreign key that points to another table, you may not...
View Full Document

This document was uploaded on 02/11/2014.

Ask a homework question - tutors are online