Skip to main content

DBMS Database Management System

DBMS Database Management System

DBMS Database Management SystemDefinition of DBMS Database Management System - A Database Management System (DBMS) is a collection of Programs that enable user to store, modify, and extract data or information from a large or small database. The data base management systems are used in small personal computers to huge mainframe computers. DBMS is an intermediate layer between programs and the data. Programs access the DBMS, which then accesses the data. A database management system is a piece of software/ program that enable you to accessing a database, while maintaining all the essential features of the data. The Commercially available DBMS in the market are dbase, MySQL, SQL Servers, FoxPro, IMS and Oracle and DB2 etc.

Some of the important examples of DBMS applications are

  1. Computerized library systems

  2. Flight reservation systems

  3. Computerised inventory machines

  4. Automated teller machines

  5. Railway reservation systems

Major Components involved in DBMS Environment

There are five major components which forms Database Management Systems environment. They are Hardware, Software, Data, Users and Procedures.

Hardware is used for keeping and accessing the database like Secondary Storage Device – Hard disks.

Software also called as DBMS Program which exhibits presence between hardware and users. The DBMS allows the users to communicate with their database. Or say it acts as the mediator between user and database. The DBMS is responsible for accessing and maintaining consistency of the data during operation.

The data involve the operational data, Meta data and data about data.

Users are the person who access data in different ways depending upon their access rights. There are no of users who can access or retrieve data on demand using the applications and interface provided by the DBMS. The different types of users are separated in terms of expertise, use and authorization. The different types of users are –

What are the different types of User in DBMS?

  1. Naïve Users – The naïve users are the end users who are not aware of the presence of the database system and work through a menu driven application program. The user using Automatic Teller Machine (ATM) for withdrawal of money fall under this category.

  2. Online Users – The users who access database through online terminal, user interface or via application program. These type of user know the presence of database system and have certain knowledge about database.

  3. Sophisticated Users – The users who interact with the database without writing any programs.

  4. Specialized Users – Those who write specialized database application that do not fit into the fractional data-processing framework. For example: Computer-aided design systems, knowledge base and expert system, etc.

  5. Database Administrator - The database administrator (DBA) is a person or group of person who implements the database system of an organization. The DBA has all the system privileges and rights which is allowed by the DBMS and can grant, remove levels of access to or from other users. DBA is responsible for the evaluation, selection and implementation of DBMS applications. DBMS Database Management System is a important concept involved during storing any data in computer hard drive. 

Popular posts from this blog

When Task Scheduler gets Infected by Malware

When Task Scheduler gets Infected by Malware

When Task Scheduler gets Infected by Malware - We are familiar with malware attacks on Computer. The hackers infect one or more files and thereby attaining full control on the System. There are millions of victims who had loosen either data or dollars in this respect. In this article we see a System file which is infected by these hackers at first stage. The System file infected by malware at first stage is Task Scheduler Engine (Taskeng.exe). The Task Scheduler Engine is a system file located in C:\Windows\System32 folder. This location is the default location for Taskeng.exe.

The Task Scheduler Engine is responsible for keeping track of tasks set to run at a time predefined by the user of the PC. As said earlier, the original location of this scheduler is C:\Windows\System32 folder. But it is suspicious if the location of scheduler gets change. If it is found in some other folder then it must be infectious. As a result, you constantly get a…

How to Project Android Phone Screen on Windows PC

How to Project Android Phone Screen on Windows PC

Project Android Phone Screen on Windows PC - Four out of Five of us have Smartphones in our Pocket. We spend lots of time on Smartphone utilities like Facebook, Twitter, WhatsApp, YouTube and other interesting Apps. These Smartphones are tremendously used due to Android Operating System installed in it. Android OS is one the successful mobile based OS running in the market.

On the Other side, Microsoft is emphasizing on features to ease Android user's connectivity with it. Microsoft has done lots of improvement for mobile utilities to the Windows 10 version 1809. With this upgradation, we can easily project Android phone screen on Windows PC. The extensive use of such features is seen on Digital Smart TVs Today. The introduction of Wi-Fi feature makes more reliable and user friendly.

So, if you are boredom with 5-6-inch Android Screen and want to mirror it on Computer screen, then read the full article to know the process, how to proj…

Fix Windows could not find a driver for your network adapter error

Fix Windows could not find a driver for your network adapter error

A Computer run smoothly with the coordination of Software & Hardware. In the absence of any one it will not run at all. Software being the Master utilizes each hardware attached to the System. And each hardware is operated with the help of Device Drivers installed in it. Operating System (OS) uses these device drivers to control & utilize each hardware when needed. Each hardware connected to the system must have their own Device Driver installed. A device driver is a program to initiate a hardware when required by Operating System.

Suppose, you want your PC to connect to the Network, it can only be possible when your PC has network related Device Driver. These Device Drivers are easily downloaded from Manufacturer Websites. In this article we focus on Network related problem. Suppose, your PC not obtaining Network connectivity. And each time you are getting an error message saying "Windows could not find a d…