Database Management Systems (DBMS)
Database Management System (or DBMS) refers to the technology of efficiently storing and retrieving data and security measures for protecting the data within a database system.
Structures that exist in a relational database system:
Database - A database is a logical grouping of data. It contains a set of related table spaces and index spaces.
Table - A table is a logical structure made up of rows and columns.
Indexes - An index is an ordered set of pointers to rows of a table.
Keys - A key is one or more columns that are identified as such in the creation of a table or index, or in the definition of referential integrity.
DBMSs are of two types: General-purpose and special-purpose DBMSs
General-purpose DBMS: General-purpose DBMSs aim to meet the needs of as many applications as possible. They are complex software systems and are expensive but their cost can be spread over a large number of users, making them cost-effective for most organizations. Oracle is an example of a general-purpose DBMS.
Special-purpose DBMS: an email system is an example of a special-purpose DBMS; it performs many of the functions of a general-purpose DBMS but these functions are limited to what is required to handle email and don't provide the user with all of the functionality that would be available using a general-purpose DBMS.
Start studying Alison's Diploma in Information Technology Management course.
Learn more about what Information Technology Project Managers do and how people become Information Technology Project Managers.