Acar_Activity Task Module 1_Lecture_DBMS

 

---Activity Task Module 1---

---Functions, Advantages and Disadvantages of DBMS---


A. Functions of DBMS

(Click to see the photo)

*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 called the database dictionary.



B. Advantages of DBMS

(Click to see the photo)

*Reduced Data Redundancy - In database system, data redundancy is avoided by keeping a single copy of the data.

*Data Integrity - Since a single copy of a particular data is stored in the database, you can be certain that the changes to the data will be reflected in all future uses of that data.

*Data Independence - The structure of the database system requires that data be independent of other data in the database and the software used to access the database.

*Data Security - A database system can have additional security measures as part of the database software product.

*Data Consistency - Data consistency is maintained in the database environment.

*Easier Use of Data - Data is easier to use in the database environment.

*Less Storage - Since data redundancy is reduce if not eliminated, the database will occupy less storage space.


C. Disadvantages of DBMS


*Complexity - Databases and their associated DBMS are extremely complex.

*Expense - The installation of the DBMS and its databases onto the current system requires careful planning because of the possibility of the need for additional hardware.

*Vulnerability - Because data in a database is in a central location, it is vulnerable to partial or complete destruction when a breakdown of hardware components occur or in software mistake.

*Size - A typical mainframe database is very large.

*Training Costs - When a company purchase a database product, it must first train one or more individuals to be the database administrator for the new product.

*Compatibility - One of the pitfalls of most database systems is their incompatibility with other database systems.

*Locking-in Technology - What if the vendor expresses a desire to abandon the product? There is a possibility that they will have to redesign their system from scratch.


Thank you for reading! <3


Comments

Post a Comment

Popular posts from this blog

Acar_Module-4 Blogging _INFMNGT LECTURE

Image
Module 4_INFMNGT LECTURE A. What is SQL? SQL is a language that is used to communicate with databases. We can use it to access and manipulate databases. SQL stands for Structured Query Language , and it is the standard language for relational database management systems, according to ANSI (American National Standards Institute). SQL can be used to insert, search, update, and delete records in a database. It may perform a variety of different tasks, including database optimization and maintenance. Here’s a list of some of the most commonly used  SQL commands : CREATE  – defines the database structure schema INSERT  – inserts data into the row of a table UPDATE  – updates data in a database DELETE  – removes one or more rows from a table SELECT  – selects the attribute based on the condition described by the WHERE clause DROP  – removes tables and databases
Read more

Acar_Module-6_INFMNGT

Image
  Module 6_INFORMATION MANAGEMENT_Blogging_Activity-1 A. XML The acronym XML stands for "extensible markup language." A markup language is a collection of codes, known as tags, that describe the text in a digital document. Hypertext Markup Language (HTML) is the most well-known markup language, and it is used to format Web pages. XML, a more flexible cousin of HTML, enables complicated business transactions to be conducted via the Internet. B. JSON JSON is a standard text-based format for encoding structured data that is based on JavaScript object syntax. It is often used for data transmission in web applications. It is a widely used data format for electronic data interchange, particularly for the interaction of web applications with servers. It's a language-independent data format. C. AJAX AJAX is a set of web development approaches that construct asynchronous web applications by utilizing multiple web technologies on the client side. Ajax allows web applications to tra...
Read more

Acar_Learning Task Module 1-Blogging

Image
  --Learning Task Module 1-- A. WHAT IS A DATABASE? A database is a structured collection of information or data that is often stored electronically on a computer system. A database management system (DBMS) is usually in charge of a database. The data and the DBMS, as well as the applications that are associated with them, are collectively referred to as a database system, which is frequently abbreviated to just "database." B. WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE EXCEL?  Microsoft Excel is a spreadsheet program included in the Microsoft Office suite of applications. With Office 365, you are able to download the application to your hard drive and will also have access to the online version. C. WHAT TYPE OF SOFTWARE IS MICROSOFT OFFICE ACCESS? Microsoft Access is a database management system (DBMS) used to store and manage data. Access is part of the Microsoft 365 suite, and is made for business and enterprise users.           D.THINK OF ATLEAST TWO...
Read more