Skip to main content

What is DBMS? What is the function of DBMS? What are the advantages of DBMS?

Database System and Database Management System- DBMS

A set of programs used to create, store, and perform various operations on a database by collecting interrelated data is called a database management system or DBMS. When the data is related to each other and collects information about a particular subject, it is called a database. Database Creation, Control, Maintenance, Modernization Data Editing The programs included in the management system are used to create database, enter database, modernize data, edit data etc. A database management system plays a coordinating role between the database and the user.

Some instance of the Database Management System Programs--

(i) dBase

(ii) Microsoft Foxpro

(iv) Microsoft Visual Basic

(iii) Microsoft Visual FoxPro

(vi) 4D

(v) Microsoft Access

(vii) SQL

(viii) Power Builder

(x) Oracle

(ix) Delphi 

(xi) Java

(xii) Informix

(xiii) File Marker Pro

(xiv) Paradox

(xv) MySql

(xvi) Postgress

(xvii) MariaDb etc.


Basic functions of database management system


(i) Creation of database

(ii) Inclusion of new records

(iii) Exclusion of unnecessary records

(iv) Correction of data inaccuracies

(v) Sorting database records based on a field

(vi) searching for any specific data

(vii) Querying data

(viii) Editing the database

 (ix) Preparation of reports

(x) Printing of reports.

Advantages of database management system


Through database management system, records are stored in different tables, files and database relationships can be created through queries, it is called relational database management system. Below are the advantages of standard relational debt management system

(i) Relational databases can be created with the help of relational database management systems.

(ii) Database indexes can also be arranged with the help of relational database management system. (iii) Data entry can be done easily by creating tables with the help of RDMS.

(iv) Information can be exchanged from one database to another.

(v) Retrieval of required data from database.

(vi) Data entry can be controlled.

(vii) Reports can be easily generated in various formats. (viii) Labels can be made and printed.

(ix) Necessary mathematical operations can be performed on numerical data.

(x) Necessary charts or graphs can be made with the help of the data.

(xi) Interesting reports can be created by adding images.

(xii) Graphical data entry forms can be created using Windows graphical wizard.

(xiii) Easily fetch information or data from other programs and use it.

(xiv) Application software or programs may be developed.

 (xv) Reports, labels in database management system can use different fonts.

(xvi) Menus can be created easily with menu builder in various database management systems
Labels:

Comments

Post a Comment

Popular posts from this blog

Unlocking Online Success: Why Justoctane SEO Services are the Best Choice for Businesses in Boca Raton, Florida.

Best Justoctane SEO Services Boca Raton in Florida Are you looking for the best SEO services in Boca Raton, Florida? Look no further than Justoctane SEO services. As a leading provider of SEO services, Justoctane has helped numerous businesses in the Boca Raton area achieve top rankings on search engine results pages. In this blog post, we will explore why Justoctane is the best choice for SEO services in Boca Raton. Experience and Expertise Justoctane has a team of experienced and highly skilled SEO professionals who have a deep understanding of search engine algorithms and the latest SEO techniques. Their expertise allows them to create customized SEO strategies that are tailored to the specific needs of each client. The Justoctane team has worked with businesses in various industries and niches, providing them with a wealth of knowledge and experience to draw from when creating effective SEO strategies. Comprehensive Services Justoctane offers a wide range of SEO services, incl...
2 comments
Read more

What is computer outsourcing and freelancing? What are the work areas of outsourcing and freelancing?

Outsourcing Computer Outsourcing: The word outsourcing information freelancing basically means free profession. That is, a profession to earn income by working freely. And a little more simply. In other words, different organizations do different types of work through the Internet system. By someone else outside your organization. Outsourcing is called outsourcing. Those who do outsourcing work are called freelancers. Jobs in multimedia, outsourcing sites or online marketplaces are divided into different categories, such as web development, software. Development, networking and information systems, writing and translation, administrative support, design and customer service, sales and marketing business services, etc. It is possible to earn online only if all these tasks are done through the internet system. There are also many other types of work available in the outsourcing world. . Freelancing Freelancing  means working independently without being under a specific person or orga...
Post a Comment
Read more

What is the purpose of operating system? Basic concepts of operating system?

Basic concepts of operating system The main purpose of the operating system is to-- • Creation of working environment: The operating system that creates a better working environment, the better and improved the operating system. • Coordinator: It coordinates between hardware and software. It acts as a coordinator between user tasks and all devices. • Automatic management: When a problem arises, it automatically understands what to do. If the appropriate solution is not provided, the operating system may automatically shut down the computer by itself. • Control of computer operations: The objective of the operating system is to control the speed of input/output operations by programs. • Memory management: helps the computer to work faster in stages by storing different files so that they can be found easily. this • Working based on priority: All the tasks that are directed to the computer are carried out based on priority. • Input/Output Management (I/O Management): It is the task o...
Post a Comment
Read more