Database Day 02: Functions of A Database Management System

Functions of A Database Management System (DBMS)

1. Create database
2. Create tables
3. Create supporting structures (e.g. indexes)
4. Read database data
5. Modify (insert, update, or delete) database data
6. Maintain database structures
7. Enforce rules
8. Control concurrency
9. Provide security
10. Perform backup and recovery

For example, an organization developes a database that is used to manage its data. The company has two buildings that house different departments. The first building houses Administration, Accouting, Finance and Human Resources departments and the second buidling houses Production, Marketing, and Information Systems departments.The company database contains data about company employees, departments, company projects, company assests (e.g. computer equipment, buildings), and other aspects of company operations (e.g. sale orders, purchasing orders, products).

References

1. David Kroenke and David Auer (2011). Database Processing: Fundamentals, Design, and Implementation, 12 edition, Prentice Hall.