Database Concepts

1
Database Concepts
Track 3 Managing Information using Database
2
Objectives

• Database concepts
• Terminology and jargon.
• Introduction to Database Management System. (DBMS)

3
Possible databases

• Personal address book
• a collection of documents
• a collection of excel spreadsheets
• data, collected, maintained and used somewhere

4
What is Database

• An organized store of information
• Held over a period of time,
• In computer-readable form

5
Database Components
Http//cs.ucf.edu/courses/cgs2545/CH02/index.htm
6
Minimal duplications of data
Database characteristics and advantages
File sharing
Easy data retrieval
7
TABLE

• Record
• Column

8
Database models

• 2000s

• 1990s

• 1970s

• 1960s

?
Object oriented
Hierarchical
Client Oriented
Traditional files
Object-relational
Network
9
Relational Database

• Data structure
• Data manipulation
• Data integrity
• Relational Database is an easy way to create and
  manage large amount of data in organized and easy
  to retrieve way.

10
Database Management System

• A DBMS (Database Management System) is software
  that enables users to define, create and maintain
  the database and provides controlled access to
  this database

11
Summary

• Database system is the organized collection of
  data (database), which has been developed by
  using the Database management system, has an
  user friendly Interface and dynamic application
  program.