微觀經(jīng)濟(jì)學(xué)mis_ch(7)-文庫吧資料
2025-01-09 02:38本頁面
【正文】 mining（數(shù)據(jù)挖掘） ? Utilizing Web interfaces to databases Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。 2022 by Prentice Hall Access Data Dictionary Features Figure 59 Microsoft Access has a rudimentary data dictionary capability that displays information about the size, format, and other characteristics of each field in a database. Displayed here is the information maintained in the SUPPLIER table. The small key icon to the left of Supplier_Number indicates that it is a key field. Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management Database Management Systems 169。 2022 by Prentice Hall Capabilities of Database Management Systems ? Data definition capabilities ? Specify structure of content of database ? Data dictionary (數(shù)據(jù)字典） ? Automated or manual file storing definitions of data elements and their characteristics ? Querying and reporting ? Data manipulation language ? Structured query language (SQL) ? Microsoft Access querybuilding tools ? Report generation, . Crystal Reports Database Management Systems Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。 2022 by Prentice Hall ? Join: – Combines relational tables to present the user 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 169。 ? Insert: insert into PART (Part_Number, Part_Name, Unit_Price, Supplier_Number) values (‘180’, ‘wheel’, ’’, ‘8259’)。 select * from SUPPLIER where Supplier_Number = ‘8259’。 2022 by Prentice Hall Human Resources Database with Multiple Views Figure 57 A single human resources database provides many different views of data, depending on the information requirements of the user. Illustrated here are two possible views, one of interest to a benefits specialist and one of interest to a member of the pany’s payroll department. Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management Database Management Systems 169。 2022 by Prentice Hall EntityRelationship Diagram for the Database with Four Tables Figure 56 This diagram shows the relationship between the entities SUPPLIER, ART, LINE_ITEM, and ORDER. The Database Approach to Data Management Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。 2022 by Prentice Hall Sample Order Report Figure 54 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. The Database Approach to Data Management Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databases and Information Management 169。 2022 by Prentice Hall A Simple EntityRelationship Diagram Figure 53 This diagram shows the relationship between the entities SUPPLIER and PART. The Database Approach to Data Management Essentials of Business Information Systems Chapter 5 Foundations of Business Intelligence: Databas
教學(xué)課件相關(guān)推薦
鄂ICP備17016276號(hào)-1