Transcript Introduction to Database Management Systems - Jui

Management Information Systems
Lecture 1: Introduction to MIS
J.-S. Rayson Chou, P.E., Ph.D.
Assistant Professor in Operations Management
Database Management System :
Concepts and Definitions
An DBMS collects, processes, stores, analyzes, and
disseminates information for a specific purpose “Application”.
> Hardware
> Software
•
•
•
>
>
>
>
Operating system
software
DBMS software
Application
programs and
utility software
Data
Network
Procedures
People
Hardware
Software
Application
Data
People
2
Information System Is A System
3
Information System
> Data
Raw description of things, events, activities, and transactions
that are recorded but alone do not to convey any specific
meeting
> Information
Data that has been organized so that they have meaning and
value to the recipient
> Knowledge
Information that has been organized and processed to convey
understanding, experience and expertise as they apply to a
current problem or activity
4
Data Analysis / Mining
Decision Trees
Sequence
Clustering
Clustering
Time Series
Association
Naïve Bayes
Neural Network
5
Inter-Organizational Systems (IOS)
Two or more organizations
6
The Database Life Cycle (DBLC)
7
Applications of Information Systems
Marketing (市場行銷管理)
Identify customers
Determine what they want
Planning products
Advertising and promoting products
Determine prices for products
Sales (銷售物流管理)
Contact customers
Sell the product
Take the order
Follow-up on the sale
5 year sales forecast
Manufacturing (製造業生產管理)
Control Equipment and machinery
Design new products
When and quantity of products to produce
New production facilities
Generate the work order
Purchasing (電子商務管理)
Which vendors
Quantity to purchase
Coop, rebate tracking
Handle delivery discrepancies
Generate the purchase order
Finance (財務金融管理)
Financial Assets
Investment management
Banking
Long term budgets
Accounting (會計資訊系統)
Human Resources (人力資源管理)
Employee wages, salaries & benefits
Long term labor requirements
Tracking vacation, sick,
Track employee skills
Interview and review employees
Accounts Receivable
Disbursements
Payroll
Depreciation
Earned Coop and Rebates
8
Contrasting Database and File
Systems
9