DBMS, GOC and PowerPoint
DBMS, GOC and PowerPoint
(DBMS)
A database is a systematic collection of data.
A Database Management System is a collection of programs which
enables its users to access database, manipulate data and help in
representation of data.
It also helps control access to the database by various users.
Charles Bachmen’s Integrated Data Store (IDS) is said to be the first
DBMS in history.
TYPES OF DBMS
The following shows the evolution of DBMS categories
Object
Navigational Relational
SQL DBMS Oriented
DBMS DBMS
DBMS
• Microsoft Access
• Microsoft SQL
• MySQL
• Oracle
• IBM DB2
• Firebird
DETAILED FUNCTIONS OF A DBMS
A Database Management System
1. creates and maintains database schema;
2. creates table structures;
3. carries out data retrieval;
4. carries out data update;
5. ensures data integrity;
6. controls concurrency/shared update;
7. ensures security of data and database structures;
8. ensures backup and recovery;
DIFFERENCE BETWEEN DBMS AND SPREADSHEET
Paper tape
Spacebar or Click the mouse moves to the next slide or next animation
Press B to blacken the screen during a presentation or W to whiten it
Ctrl + P gives you a pen to draw on a slide (Esc will return to your cursor).
Press the desired slide number + enter on the keyboard to jump to that slide.