G supplier part attributes 57 specific characteristics

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 store and maintain information E.g. SUPPLIER, PART • Attributes: • 5.7 Specific characteristics of each entity, e.g.: • SUPPLIER name, address • PART description, unit price, supplier Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information The Database Approach to Data Management • Relational database • • • • • • 5.8 Organize data into two-dimensional tables (relations) with columns and rows One table for each entity • E.g. (CUSTOMER, SUPPLIER, PART, SALES) Fields (columns) store data representing an attribute Rows store data for separate records Key field: Uniquely identifies each record Primary key: • One field in each table • Cannot be duplicated • Provides unique identifier for all information in any row Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information The Database Approach to Data Management A Relational Database Table A rel...
View Full Document

Ask a homework question - tutors are online