• Document: TIM 50 - Business Information Systems
  • Size: 2.63 MB
  • Uploaded: 2018-12-08 05:36:06
  • Status: Successfully converted


Some snippets from your converted document:

TIM 50 - Business Information Systems Lecture 15 UC Santa Cruz Nov 10, 2016 Class Announcements n  Database Assignment 2 posted n  Due 11/22 Essentials of Management Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management The Database Approach to Data Management The Final Database Design with Sample Records Figure 5-5 5.3 © Copyright © 2011 Pearson Education, Inc. publishing as Prentice Hall Essentials of Management Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management The Database Approach to Data Management Entity-Relationship Diagram for the Database with Four Tables This diagram shows the relationship between the entities SUPPLIER, ART, LINE_ITEM, and ORDER. Figure 5-6 5.4 © Copyright © 2011 Pearson Education, Inc. publishing as Prentice Hall Essentials of Management Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 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 server with more information than is available from individual tables •  Project: •  Creates a subset consisting of columns in a table •  Permits user to create new tables containing only desired information 5.5 © Copyright © 2011 Pearson Education, Inc. publishing as Prentice Hall Essentials of Management Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management Database Management Systems The Three Basic Operations of a Relational DBMS Figure 5-8 The select, project, and join operations enable data from two different tables to be combined and only selected attributes to be displayed. 5.6 © Copyright © 2011 Pearson Education, Inc. publishing as Prentice Hall Essentials of Management Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management Database Management Systems Capabilities of Database Management Systems •  Data definition capabilities: •  Specify structure of content of database. •  Data dictionary: •  Automated or manual file storing definitions of data elements and their characteristics. •  Querying and reporting: •  Data manipulation language •  Structured query language (SQL) •  Microsoft Access query-building tools 5.7 © Copyright © 2011 Pearson Education, Inc. publishing as Prentice Hall Essentials of Management Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management Database Management Systems Example of an SQL Query Illustrated here are the SQL statements for a query to select suppliers for parts 137 or 150. They produce a list with the same results as Figure 5-8. Figure 5-10 5.8 © Copyright © 2011 Pearson Education, Inc. publishing as Prentice Hall Essentials of Management Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management Database Management Systems An Access Query . Figure 5-11 5.9 © Copyright © 2011 Pearson Education, Inc. publishing as Prentice Hall Essentials of Management Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management Database Management Systems Object-Oriented DBMS (OODBMS) •  Stores data and procedures that act on those data as objects to be retrieved and shared •  Better suited for storing graphic objects, drawings, video, than DBMS d

Recently converted files (publicly available):