HO 343 Session 13: Database System Concept

1
HO 343 -- Session 13Database System Concept
Tools
EK BUNCHUA ek_at_alpha.tu.ac.th Room
528 Thammasat Business School
2
????????? ??? ?????????

• ???????????????????
• ??????????????????
• ??????????????????
• ??????????????
• ??????????????

• ??????????????????
• ??????????????
• ???????????????
• ??????????????????
• ???????????

3
Database ...

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

Database
Data from different sources
Applications
4
Database System ...

• A computerized record keeping system
• Database system must represent the real world
• GIGO Garbage In, Garbage Out

5
Without Database
Data Redundancy
6
Without Database
Data Inconsistency
7
Without Database
Lack of Integrity
8
Why Database? ...

• Data can be shared
• Redundancy can be reduced
• Inconsistency can be avoided
• Integrity can be maintained
• Security restrictions can be applied

HRIS Database
9
??????????????????? ...

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

Database
10
??????????????????????????? ...

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

• PC
• dBASE
• FoxPro
• Access
• Paradox

11
?????????????????????????? ...

• Data Definition ??????????????
• Create Tables and Relationships
• Data Manipulation ???????????????
• Add, Delete, Update
• Query and Report

12
??????????? ? ???????????? ...

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

13
Computer Workshop
Microsoft Access 97
14
Next Classes
Sep. 13 1. HRIS Database Content 2. Database
Design Principles 3. Computer Workshop
Database Design 4. HRIS Database
Development Sep. 20 1. HRIS Database
Applications 2. HR Research System 3. HR
Intelligence System 4. Integrated HRIS Sep.
27 1. Presentation 2. Wrap Up