DBMS

DBMS

1. Role

   • Provides a set of tools for maintaining a database
   • E.g. Define/create tables, run queries, define input forms and reports

2. Key Features

   • Allows separation of data between applications and the database
   • Allows multiple applications to use the database
   • Can allow many users to simultaneously access the data and applications
   • Provides security in the form of access rights
   • Can provide automatic backups

3. Report

   • One of the useful features of a DBMS is that it can make a report based on a query

4. Module

   • A module is a program within an application that performs a specific task which cannot be done by simply making a query or report

5. Other DBMS'S

   • MS Access is a very simple DBMS
   • Other examples of more sophisticated DBMS are Oracle and MySQL