Blogpost #2

What is A DBMS  DATABASE MANAGEMENT SYSTEMS

  • A Collection of Computer Programs that Allow Storage, Modification and Extraction of information from a Database.
      DBMS Functions

  • Data Definition - the DBMS must be able to Accept Data definitions (external, internal and conceptual schemas, and all associated mappings) in source form and convert to the appropriate object form

  • Data Manipulation - The DBMS must be able to handle request from the user to retrieve and possibly update existing data in the database, or to add a new data to the database.

  • Data Security and Integrity - the DBMS must be able to monitor user requests and reject any attempts to violate the security and integrity checks defined by the database administrator

  • Data Recovery and Concurrency - the DBMS must have the capability of recover from, or minimize the effects of a system crash

  • Data Dictionary - The DBMS must provide  a system database dictionary.


Advantages of DBMS

Disadvantages of DBMS
1.  High cost of DBMS
  • Purchasing Database Management software Are Expensive
2. Higher Hardware Cost 
  • DBMS software requires Powerful Hardware to Work Properly and Efficiently 
  • requires large size memory and high speed processor
3. Appointing Technical Staff 
  • A DBMS is a complex system
  • technical staff such as Database Administrator and Application A Programmer is Required to Manage DBMS
  • You have to pay Good wage to the Technical Staff




Comments

Post a Comment

Popular posts from this blog

XML | JSON | AJAX TERMINOLOGIES DEFINED

Image
  DEFINE THE FF. XML, JSON AND AJAX A. XML (Extensible Markup Language): XML is a markup language that is used for storing and exchanging structured data. It provides a set of rules for encoding documents in a format that is both human-readable and machine-readable. XML uses tags to define elements and attributes to provide additional information about those elements. It is widely used in various domains, such as web development, data interchange, configuration files, and more. B. JSON (JavaScript Object Notation): JSON is a lightweight data interchange format that is easy for humans to read and write and easy for machines to parse and generate. It is often used to transmit data between a server and a web application as an alternative to XML. JSON is based on key-value pairs and supports arrays, objects, numbers, strings, boolean values, and null values. It has become popular in web development due to its simplicity and compatibility with many programming languages. C. AJAX (Asynch...
Read more

What Is SQL

Image
  Relational databases are managed and worked on using the standard programming language SQL (Structured Query Language). It is frequently used to carry out a number of actions on databases, including adding, deleting, and changing tables and records.  Users can run SQL queries, which are used to extract particular data from databases. These queries might be as straightforward as simple data searches or as intricate as procedures involving several tables and conditions.  Database administrators, data analysts, and developers all utilize SQL to store, retrieve, and alter data. It is a vital tool for data management in contemporary enterprises and is widely utilized in a variety of sectors, including banking, healthcare, and retail. SQL is frequently used in various industries and applications where data storage and retrieval are essential. Some of the common areas where SQL is used are: 1. Business applications: SQL is used in business applications such as Enterprise Resou...
Read more