User talk:AAloys

DBMS stands for Database Management System which is a computer application or software that helps a user in the management of a collection of interrelated data. This collection of interrelated data is called a database such as the names, prices and brand of items in a store or names, phone numbers, email date of birth etc of students in an institution. These data is arranged in tables. The simplest database is made up of one table while others can have multiple tables. Some popular Database Management Systems include MySQL, Oracle, MS Access, MongoDB. A DBMS is designed to allow the definition, creation, querying, update, and administration of databases. DBMS stores data in such a way that it becomes easier to retrieve, manipulate, and produce information. With the use Database management systems, most of the problems associated with typical file-processing systems supported by conventional operating systems are resolved. Some of these problems include;
 * Difficulty in accessing data
 * Data redundancy and inconsistency
 * Data isolation – multiple files and formats
 * Difficulties in updating
 * Concurrent access by multiple users
 * Security problems

DBMS can be group into two main categories; non-relational database management systems and relational database management (RDBMS) AAloys (talk) 06:55, 16 December 2016 (UTC)