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: add a record to the table with foreign key unless there is a corresponding record in the linked table 5.13 Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information The Database Approach to Data Management Sample Order Report Figure 5-4 The shaded areas show which data came from the SUPPLIER, LINE_ITEM, and ORDER tables. The database does not maintain data on Extended Price or Order Total because they can be derived from other data in the tables. 5.14 Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information The Database Approach to Data Management The Final Database Design with Sample Records Figure 5-5 The final design of the database for suppliers, parts, and orders has four tables. The LINE_ITEM table is a join table that eliminates the manyto-many relationship between ORDER and PART. 5.15 Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information The Database Approach to Data Management Entity-Relationship Diagram for the Database with Four Tables...
View Full Document

This document was uploaded on 02/11/2014.

Ask a homework question - tutors are online