Loading presentation...

Present Remotely

Send the link below via email or IM

Copy

Present to your audience

Start remote presentation

  • Invited audience members will follow you as you navigate and present
  • People invited to a presentation do not need a Prezi account
  • This link expires 10 minutes after you close the presentation
  • A maximum of 30 users can follow your presentation
  • Learn more about this feature in our knowledge base article

Do you really want to delete this prezi?

Neither you, nor the coeditors you shared it with will be able to recover it again.

DeleteCancel

Make your likes visible on Facebook?

Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.

No, thanks

Introduction to Database

No description
by

JM Casiño

on 5 July 2015

Comments (0)

Please log in to add your comment.

Report abuse

Transcript of Introduction to Database

Introduction to
base System
Data
How were
maintained in the pre-computer period?

records
computer period
the Database approach
Manual filling system
Projects
Clients
Products
Equipments
Employees
Sales
Departments
Inventory
...
Database is a collection of Related Datas
What do these records contain?
Employees
Let's take a look...
Employee ID:
Name:
Address:
Position:
An Employee Records holds:
But what do we do with the Records?
Records
We
Add
Update
Search
Delete
What do we do with Records?
This is Manual Filling and it is Time consuming, Costly and Prone to Errors
Generate Report
what is a Database
Which means, instead of having 3 Cabinets of Data
We Will Have a Single Database File
Projects
Products
Equipments
Clients
Employees
Sales
Departments
Inventory
...
It is a shared collection of logically coherent data with some inherent meaning;
It is designed , built and populated with data for specific purpose such as meeting the information needs of an organization;
Application Program
Can a user access a database through an application program alone
Can a user directly access database?
DBMS
We would need a DBMS
What is DBMS
A Software System that enables user to:
Define Create and Maintain the Database
DDL(Data Definition Language)
DML(Data Manipulation Language)
Provide controlled access to this Database
Security
Integrity
Concurrency control
Recovery control
User-accessible catalogue (description of data)
This is the Database
For Example
DBMS Software
Handles Queries and Access Datas
the Users
Before the Users could access the database
their request would be recieved by the DBMS Software
This is the Simplest Example of a woking
Database System
Other Examples of Database System?
Supermarket
Credit Card company
Library
University
NO
Introduction
in
Database System
Prepared by:
Casiño, Jan Michael F.
NO
Then How can a User access a Database?
Full transcript