Database

 A. FUNCTIONS OF DBMS A database management system (DBMS) is a software package designed to  de me, manipulate, retrieve and manage data in a database . A DBMS generally manipulates the data itself, the data format, field names, record structure, and file structure. It provides users and programmers with a systematic way to create, retrieve, update and manage data. B. ADVANTAGES OF DBMS Advantages of Database Management System (DBMS):   1. Better Data Transferring 2.  Better Data Security 3.  Better data integration 4.  Minimized Data Inconsistency 5.  Faster data Access 6.  Better decision making 7.  Increased end-user productivity 8.  Simple 9.  Data abstraction 10.  Reduction in data Redundancy C. DISADVANTAGES OF DBMS Disadvantages of Database Management System (DBMS): 1. Increased Cost:       1.  Cost of Hardware and Software      2.  Cost of Staff Training      3....

A. WHAT  IS A DATABASE? Formally, a  " D atabase " refers to a set of related data and the way it is organized. Access to this data is usually provided by a "database management system" (DBMS) consisting of an integrated set of computer software that allows users  to interact with one or more databases and provides access to all of the data contained in the database (although restrictions may exist that limit access to particular data). The DBMS provides various functions that allow entry, storage and retrieval of large quantities of information and provides ways to manage how that information is organized. B. WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL? Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA). Excel forms part of the Microsoft Office   suite  ...