Database Management System

 Introduction to DBMS


Function of DBMS

A database's role is to store and organize information.

A database is a logically structured set of interconnected data that supports a variety of business purposes. The database not only records the values of different entities' attributes but also the relationships between them. A database's role is to store and organize information.

A database is a logically structured set of interconnected data that supports a variety of business purposes. The database not only records the values of different entities' attributes but also the relationships between them.

Advantages of DBMS

Reducing Data Redundancy is one of the benefits of DBMS, and Various files were stored in several different places within a system, or also through multiple systems, in file-based data processing systems. Also, Data Exchange Users of a database may exchange data between themselves. As well as Data Quality, refers to the accuracy and consistency of the data in the database. These are just a few of the advantages of BDMS. 

Additional DBMS benefits as mentioned above.


Disadvantage of DBMS

  • Complexity
  • Size
  • Cost of DBMS
  • Additional Hardware cost
  • Cost of Conversion
  • Performance
  • Higher impact of a failure







Comments

Post a Comment

Popular posts from this blog

Image
XML Extensible Markup Language (XML) is an abbreviation for Extensible Markup Language. It is a text-built markup language based on the Standard Generalized Markup Language (SGML). Unlike HTML tags, which define how to show the data, XML tags describe the data and are used to store and arrange it rather than defining how to display it. XML will not replace HTML in the immediate future, but it will add new possibilities by incorporating several successful HTML features. JSON JSON is an abbreviation for JavaScript Object Notation. JSON is a lightweight data storage and transport format. When data is transmitted from a server to a web page, JSON is often used. JSON is "self-describing" and simple to grasp. AJAX AJAX stands for Asynchronous JavaScript. AJAX is a methodology for designing interactive and fast-loading websites. AJAX enables asynchronous web page updates by sharing tiny volumes of data with the server behind the scenes. This ensures that portions of a web page can b
Read more

Experiences and Lessons Learned in Work Environment

Image
  E xperiences and Lessons Learned in Work Environment My OJT was at Angel C Manglicmot High School in Brgy. Angeles San Antonio Zambales. At first, I was scared and thrilled, and it was difficult for me to engage with them since it was work from home. To think about it, they were professionals, and I was just a student trainee, and I couldn't interact with them effectively over internet. After the training, I realized that OJT is more than simply a need to be fulfilled; it is also an opportunity to demonstrate my abilities, knowledge, and talents, as well as to experience the sense of being a professional. In my OJT, I learn a lot of things, some of which I embrace and apply to myself, and others of which help me expand my abilities and knowledge. I was thrilled to have my OJT in this office. I learn to be more patient with every work that is assigned to me, to be polite and modest with everyone with whom I contact, and, most importantly, to LOVE MY WORK. The training helped me un
Read more
Image
 What exactly is SQL?      SQL (pronounced "ess-cue-el") stands for Structured Query Language. SQL is a language that is used to interact with databases. It is the basic language for relational database management systems, according to ANSI (American National Standards Institute). SQL statements are used to do things like update data on a database or extract data from a database. SQL Partitions The SQL language is divided into three parts: DML is used to retrieve and edit data in a table, such as inserting, deleting, and updating records. On the other hand, Select becomes a special declaration in this subset despite being a read-only instruction that does not modify data at all. DCL is used to manage access to data in a network, such as granting or robbing other users' privileges to execute specific tasks. DDL is used to describe data structures, such as creating, altering, or deleting tables. TCL commands, or transaction management language commands, deal with databas
Read more