Illustrated here is a table for the entity supplier

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: ational database organizes data in the form of two-dimensional tables. Illustrated here is a table for the entity SUPPLIER showing how it represents the entity and its attributes. Supplier_Number is the key field. Figure 5-1 5.9 Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information The Database Approach to Data Management The PART Table Figure 5-2 Data for the entity PART have their own separate table. Part_Number is the primary key and Supplier_Number is the foreign key, enabling users to find related information from the SUPPLIER table about the supplier for each part. 5.10 Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information The Database Approach to Data Management • Establishing relationships • Entity-relationship diagram • used to clarify table relationships in a relational database • Relational database tables may have: • One-to-one relationship • One-to-many relationship • Many-to-many relationship • Requires creating a tabl...
View Full Document

This document was uploaded on 02/11/2014.

Ask a homework question - tutors are online