Database Management Systems (dbms)

Database Management Systems (DBMS)

Certificate Course in Information Technology

Anil Luvishewa

[e-mail]

Learning Outcomes

• Understand the need for database management as opposed to the traditional stand - alone applications approach.
• Learn the major factors involved in proper database design including the use of entity-relationship diagrams and normalization.
• Learn to use SQL for data definition and data manipulation.

Topics

• Introduction to DBMS
• The Database Architecture
• Database Design Process
• Conceptual Data modeling – (Entity-Relationship approach)
• The logical Database Model – (The Relational Model)
• Logical Database Design – (Normalization)
• Data Manipulation using SQL

Introduction to Database Concepts

• Why use a Database?
• Why Database Technology?

?
Branch
Branch
Mobile
ATM users
ATM users
Bank
Banking System
Banking System

Data and Information

• Data
• Raw facts
• Less meaningful
• Not processed

Eg:

Date of birth

• Information
• Processed data
• Meaningful
• Organized

Eg:
Processed DOB: Age

File Processing System

• Individual applications maintain own private data files.
• Leads to data duplicate (redundancy).
• Inconsistency
• Management is very difficult
• Data is in different formats.
• Inflexible

What is a database?

A database is an organized collection of data that are related in a meaningful way and stored in a common pool which can be accessed by one or many persons for many purposes.