What is the Purpose of a Database Management System

The purpose of this paper is to explain what a Database Management System (DBMS) is, the main principles of database design and to describe the features or characteristics of four prevalent database models. What is a DBMS? A database management system could be described as a file processing system that creates and administers data and or objects as information for the purpose of access and storage in a convenient way. Many types of programs have been written to add and extract information from files. A key objective of a DBMS is to maintain data integrity. What is a Database Model? A database model is used to determine what the structure of a database might look like. It portrays how information will relate to each other, how it will be stored, organised and manipulated. According to Gavin Powell, A database model is a pretty picture commonly known as an entity relationship diagram(a database on paper). A database, on the other hand, is the implementation or creation of a physical database on a computer. A database model is used to create a database. (1) What are the main features of a DBMS? †¢ Data storage. The integration and sharing of data decreases storage costs and reduces file duplication. †¢ Security, access and control of data. A DBMS will have properties such as encryption, authentication and authorization which control access. †¢ Data recovery. A system will have the ability to be backed up regularly so that in the event of a disaster valuableShow MoreRelatedDesign Of Audit Trails And Data Quality Monitoring Programs1624 Words   |  7 Pagesguidelines that are developed for purposes of maintaining a record of all the activities of the system and the application that are done by the system users. Importantly, audit trails are highly used in the process of detecting any form of security violations in the system, performance issues, and any flaws in the applications. Some of the key elements of audit trails include original source documents, transaction history database, and safe storage capabilities. For purposes of making sure that the healthcareRead MoreDatabase Management And A Computer System1325 Words   |  6 Pages Before understanding what Data Management is you must learn what each word stands for. We are going to break down the full meaning to give you a full understanding of what data man agement is, the purpose and its advantages. First and foremost data is a collection of facts from which you can draw a conclusion. In computer terminology data is anything in a form suitable for use with a computer. Database is a collection of data that is organized so that its content can easily be accessed, managed,Read MoreDatabase Management Systems ( Dbms )898 Words   |  4 Pagespay close attention to how they access, store and use data. One of the systems at the heart of current data management is different database management system. But as with most technology product out there, people have a wide range of database technologies and systems to choose from. Picking out the most convenient for your business can be difficult. This guide will hope to explain what database management systems are and what are the benefits for using one. We’ll also explain some of the most commonRead MoreManagement Informational System1165 Words   |  5 Pagesthe term database. How is it different from a database management system? Database is simply a collection of data. A database helps and provides managers and decision making people with timely and relevant information that leads the company to organizational success. A database management system is totally different than regular database. A (DBMS) is a group of programs that manipulates the database. 2. What is the hierarchy of data in a database? The hierarchy of data in a database is bitsRead MoreDatabase Analysis : Database Management System Essay1337 Words   |  6 PagesDatabases are fundamentally containers for data. When data for any organization needs to be stored, databases can be used. For example, let’s say a public library stores books, we could say that the library is a database of books. But specifically, databases are computer structures that save, organize, safeguard and produce and/or deliver data. A database platform is essentially a database management system (DBMS) which is a computer software application that interacts with the user, other applicationsRead MoreDatabase Processing Ch 1 and Part of Ch 21432 Words   |  6 PagesQuestions 1.1 What is the purpose of a database? - The purpose of a database is to help people keep track of  things. 1.2 What is the most commonly used type of database? - The  relational database is the most commonly used type of database. 1.7 Define  the terms data and information. Explain how the two terms differ. - Data are facts and figures. Information is defined as knowledge derived from data, or as data  presented in a meaningful context.  Data  is simply recorded in the database, but the dataRead MoreDatabase Enviroment1227 Words   |  5 PagesTHE DATABASE ENVIRONMENT: A database defines a structure for storing information and it collects information that is organized in such a way that a computer program can quickly select desired pieces of data. A database can also be thought of as an electronic filing system. Data and information are extracted from a database by creating a query and then submitting it to the query database management system (DBMS) and it is posed in a language that only the DBMS can understand. PROBLEMSRead MoreThe Management Of The Production Essay1638 Words   |  7 Pages1. INTRODUCTION 1.1 PROJECT SUMMARY: The management of the production is done by the production manager manually which is a difficult process. The Project deals with the development of the computerized system for maintaining the regular records. The Project consists of various forms and developed with the help of the PHP Programming. The system has a module called Operation, which consists of the details of all employees that is needed to be filled in the form. The other module called the ProductRead MoreAnalysis of Database Management and Information Retrieval Systems1117 Words   |  5 PagesDIFFERENTIATE BETWEEN DATABASE MANAGEMENT SYSTEM AND INFORMATION RETRIEVAL SYSTEM BY FOCUSING ON THEIR FUNCTIONALITIES 2. HIGHLIGHT THE DIFFERENCES BETWEEN DATA AND INFORMATION 3. MAKE APPROPRIATE USE OF DIAGRAMS TO ILLUSTRATE THE UNDERLYING CONCEPTS/COMPONENTS OF DATABASE MANAGEMENT SYSTEM AND INFORMATION RETRIEVAL 4. DIFFERENTIATE BETWEEN STRUCTURED AND NON STRUCTURED DATA. GIVE EXAMPLES FOR EACH. 5. REFERENCES 6. APPENDICES â€Æ' 1. DIFFERENTIATE BETWEEN DATABASE MANAGEMENT SYSTEM AND INFORMATION RETRIEVALRead MoreProject Proposal for a Student Record Database Management System1211 Words   |  5 PagesProject Proposal for a Student Record Database Management System for Microtech Institute of Multimedia Technology (MIMUT) Title Student Record Database Management System Centre Name: West African Chartered College Student Name: Malamin Gassama IMIS Membership Number: 344029 Supervisor Name: Mr. Mike Topic Area: Records Management Project Title: Student Record Database Management System to keep track of student’s enrolment process, course, class dates and tuition fees.