213342 Management Information System Week 6

1
213342Management Information SystemWeek 6
Database system

• By
• Aj-Kulachatr Chatrakul Na Ayudhaya
• Marketing Department
• Business Administration Faculty

2
Agenda
1. Database Concepts
2. Database Management System DBMS
3. Relational Database
4. DBMS Software and Applications
3
Management Information SystemDatabase Concepts

• Document Locker
• More keeping area
• difficulty to access
• very slow
• very bored
• High error Mistake

• Database
• reduce keeping area
• EZ to Access
• speed to Access
• very simplify
• High Accuracy

??? ??????? ??.
4
Management Information System Filing System
Attendant Data
Payroll Slip
Payroll System
Customer Data
Service Report
After sale System
Products Data
P / O
Inventory System
5
Management Information SystemDatabase system
Attendant Data
Payroll Slip
Payroll System
Customer Data
Service Report
Suppliers Data
After sale System
DBMS
Description
P / O
Inventory System
6
Management Information SystemDatabase system

• A collection of data organized to serve many
  applications efficiently by centralizing the data
  and minimizing redundant data

Database
Data from different sources
Applications
7
Management Information System Component of
Database System
Base on Computer base information system (CBIS)
Software
Data
DB Component
Hardware
Procedure
People
8
People Components
1. General User
2. Operator
3. System Analysis(SA)
4. Programmer
5. Database Administrator (DBA)
9
Management Information System Strength
Weakness of Database

• Strength
• Inconsistency can be avoid
• Data can be shared
• Redundancy can be reduced
• Maintaining data integrity
• Standardization
• Data security
• Data independence

10
Management Information SystemWithout Database
Data Redundancy
??? ??????? ??.
11
Management Information SystemWithout Database
Inconsistency
??? ??????? ??.
12
Management Information SystemWithout Database
lack of Integrity
??? ??????? ??.
13
Management Information SystemWith data base
Data can be shared
Sale dept.
MKIS Database
DBMS Software
Purchasing Dept.
14
Management Information System Weakness of
Database

• Weakness
• High cost of database investment
• Very complicated
• Risk of system down
• Centralized data System

15
Management Information SystemDatabase Management

• Database Management System (DBMS)
• Special software to create and maintain a
  database and enable individual business
  applications to access the data

Database
??? ??????? MKIS ??.
16
Management Information SystemDatabase Management

• Data Hierarchy

File
Byte
Record
Field
Data base
0 1 Bit ??????
17
Management Information System Data Management
System DBMS
?????????????????????????????????????????????????
????????????????????????????????????????????????
????????????????????????????????????????????????
??????????????????????????????????????????????????
???????????????????? ????????????????????????????
?? ?????????????????????? ???????????????????????
?????????????????? 1. Appending Data 2.
Editing Data 3. Retrieving Data 4.
Deleting Data etc
18
Management Information System DBMS Basic
Function
Data Management System DBMS
19
Management Information System DBMS Basic
Function
Data Definition
Data Manipulation
Data Dictionary
???????????????

• DDM
• Add
• Delete
• Update
• Query
• Report
• SQL , COBAL

• DDL
• Create
• Tables
• and
• Relationships

(Laudon Laudon)
20
Management Information SystemExample of DBMS

• Client/Server
• DB2
• Oracle
• Ingres
• Sybase
• Progress
• Informix

• PC
• dBASE
• FoxPro
• Access
• Approach
• Paradox
• MySQL

21
Management Information System DBMS
miscellaneous Function

• Data Security ???????????
• Data Integrity ??????????????????
• Data Concurrency ????????????????????
• Data Recovery ?????????????
• Data Dictionary ???????????????
• Performance ???????????????

22
Management Information SystemElement of DBMS
Laudon Laudon. 1996
Physical Database
DDL DML DICTIONARY
DBMS
Applications
23
Management Information System Database Program
MS-ACCESS
24
Management Information System Database Program
MS-SQL Server
25
Take a break4 Minutes

• Job Today
• ???????????????????? 3 ??
• ???????? Databases ???? MS Access
  ???????????????????
• ??? Save ??????? Group No
• ?????????? Internet ????? kulachatr_c_at_yahoo.com
• ???? subject ???? Group No
• ?? Box email ??????????????

26
Block Diagram
TEXT
TEXT
TEXT
TEXT
TEXT
TEXT
TEXT
TEXT
27
Table
TEXT TEXT TEXT TEXT TEXT
Title A
Title B
Title C
Title D
Title E
Title F
28
3-D Pie Chart
TEXT
TEXT
TEXT
TEXT
TEXT
TEXT
29
Marketing Diagram
Title
TEXT
TEXT
TEXT
TEXT