Introducing Database System

Only available on StudyMode
  • Download(s) : 22
  • Published : February 25, 2013
Open Document
Text Preview
CHAPTER 1: Introducing Database System

LEARNING OUTCOMES
TOPIC

At the end of this chapter, students should be able to:

DATABASE CONCEPT

BSIT 201
 Explain what is data management  Differentiate manual file system and computerised file system with database system

INTRODUCING DATABASE SYSTEM

CHAPTER 1

 Define database system, database and database management system  List the functions, advantages and disadvantages of database management system

PREPARED BY:

YEW CHERN HAR SCHOOL OF INFORMATION TECHNOLOGY
FACULTY OF ENGINEERING AND INFORMATION TECHNOLOGY
Slide 2 of 80

CHAPTER 1: Introducing Database System

CHAPTER 1: Introducing Database System

TOPIC OUTLINES
TOPIC

INTRODUCTION
TOPIC

Introduction 1.1 Manual File System 1.1.1 Disadvantages of Manual File System 1.2 Computerised File System 1.2.1 Disadvantages of Computerised File System 1.3 Database System 1.4 Database 1.4.1 Characteristics of Database 1.5 Database Management System 1.5.1 Functions of Database Management System 1.5.2 Advantages of Database Management System 1.5.3 Disadvantages of Database Management System Figure 01

Are you being overwhelmed by too much data?
Slide 3 of 80 Slide 4 of 80

CHAPTER 1: Introducing Database System

CHAPTER 1: Introducing Database System

INTRODUCTION
TOPIC

INTRODUCTION
TOPIC

What you need is Data Management

Figure 02

Not sure how to make sense of the data?
Slide 5 of 80

Figure 03

Slide 6 of 80

1

CHAPTER 1: Introducing Database System

CHAPTER 1: Introducing Database System

INTRODUCTION
TOPIC

INTRODUCTION
TOPIC

Data management is a discipline that focuses on the proper way for

We will examine 3 ways for managing data
Manual File System

Computerised File System
Figure 04 Figure 05 Figure 06

Evolution of Data Management

Generating Data

Storing Data

Retrieving Data

Database System
Focus of this course
Slide 7 of 80 Slide 8 of 80

CHAPTER 1: Introducing Database System

CHAPTER 1: Introducing Database System

1.1 Manual File System
TOPIC

1.1 Manual File System
TOPIC

A manual file system is a way of managing data using

Data Storage
1. Record data on paper. 2. File paper away into folders and cabinets.

Pen and paper
Figure 08 Figure 07 Slide 9 of 80 Slide 10 of 80 Figure 09

CHAPTER 1: Introducing Database System

CHAPTER 1: Introducing Database System

1.1 Manual File System
TOPIC

1.1 Manual File System

1.1.1 Disadvantages of Manual File System

TOPIC

Data Retrieval
1. Locate paper from cabinets and folders. 2. Retrieve data from paper.

As data collection increases

Figure 09

Figure 10

Figure 11

Slide 11 of 80

Slide 12 of 80

2

CHAPTER 1: Introducing Database System

CHAPTER 1: Introducing Database System

1.1 Manual File System

1.1 Manual File System
TOPIC TOPIC

1.1.1 Disadvantages of Manual File System

Solution to Manual File System

Keeping track and looking up data becomes much more difficult

Where is my data?
Figure 11 Figure 13

Replace Manual File System with Computerised File System
Figure 12

Slide 13 of 80

Slide 14 of 80

CHAPTER 1: Introducing Database System

CHAPTER 1: Introducing Database System

1.2 Computerised File System
TOPIC

1.2 Computerised File System
TOPIC

A computerised file system is a way of managing data using

Data Storage
1. Launch a program (e.g. Microsoft Excel) to input data. 2. When you saved the data, the data gets stored in a computer file (e.g. Excel file .xls).

Computer Programs

Files
Figure 14 Figure 16

Figure 15 Slide 15 of 80 Slide 16 of 80

CHAPTER 1: Introducing Database System

CHAPTER 1: Introducing Database System

1.2 Computerised File System
TOPIC

1.2 Computerised File System

1.2.1 Disadvantages of Computerised File System

TOPIC

Data Retrieval
1. Find a program that could open the computer file (e.g. Excel file .xls). 2. Launch the...
tracking img