518 essentials of business information systems

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: interest to a benefits spet and one of interest to a member of the company’s payroll department. 5.18 Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information Database Management Systems Operations of a Relational DBMS • Select: • Creates a subset of all records meeting stated criteria • Join: • Combines relational tables to present the ser with more information than is available from individual tables • Project: • • 5.19 Creates a subset consisting of columns in a table Permits user to create new tables containing only desired information Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information Database Management Systems The Three Basic Operations of a Relational DBMS The select, project, and join operations enable data from two different tables to be combined and only selected attributes to be displayed. Figure 5-8 5.20 Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Chapter Information Management Information Database Management Systems Capabilities of Database Management Systems • Data definition capabilities • Specify structure of content of database • Data dictionary ...
View Full Document

This document was uploaded on 02/11/2014.

Ask a homework question - tutors are online