11-05-2012, 05:26 PM
Fundamentals of Database Design
database.ppt (Size: 1.26 MB / Downloads: 145)
Agenda
Introduction and participants needs
We will review “what is a database;”
Understand the difference between data and information;
What is the purpose of a database system;
How to select a database system;
Database definitions and fundamental building blocks;
What is a database
A database is any organized collection of data. Some examples of databases you may encounter in your daily life are:
a telephone book
T.V. Guide
airline reservation system
motor vehicle registration records
papers in your filing cabinet
files on your computer hard drive.
Why do we need a database?
Keep records of our:
Clients
Staff
Volunteers
To keep a record of activities and interventions;
Keep sales records;
Develop reports;
Perform research
Longitudinal tracking
More about database definition
What is a database?
Quite simply, it’s an organized collection of data. A database management system (DBMS) such as Access, FileMaker, Lotus Notes, Oracle or SQL Server which provides you with the software tools you need to organize that data in a flexible manner. It includes tools to add, modify or delete data from the database, ask questions (or queries) about the data stored in the database and produce reports summarizing selected contents.