1.A) Differentiate between database management system and information retrieval system by focusing on their functionalities.
Database Management System or DBMS or short, is a set of computer programs that are responsible for creating, editing, deleting and generally maintain a database or a collection of data records. database management system is determined by the database system. The database model is how the method of collecting the data is stored, managed and administered.
Among them are:
catalogs, books or other types of documents
newspapers, magazines, journals
intranet search engines
Advantages of DBMS are :
increase unavailable: One of the principle advantages of DBMS is the same information can be provided to different users.
surplus Scale : Data in a DBMS is easier because , as a general rule , information appears only once . This can reduce data redundancy, or in other words , constantly repeating the same data . Lose excess because it can reduce the cost of storing data on disks and other storage devices .
Accuracy : Accurate , consistent, and regularly update the date data is a sign of data integrity. The opportunity to make mistakes is higher if you need to change the same data to several different places where you need to make changes in one place.
consistent programs and files : Using database management systems , file formats and programs of the system are standard. This makes all data files will be maintained as the rules and guidelines to be used in all types of the same data . Consistency across files and programs also makes it easier to manage data when multiple programmers are involved.
User friendly : Data is easily accessed and manipulated by the DBMS . In most cases, the DBMS also reduce dependence on computer experts to meet the needs of individual users of their data.
Improved security : As stated before, the DBMS allows multiple users easy to access data sources alike. Capacity is usually viewed in terms of benefit, but there are risks faced by the organization . Some sources of information that should be protected and only viewed by the individuals themselves.
Lack of DBMS are:
• There are two major drawbacks to using DBMS among them the cost and data security threats
- Cost: Implement DBMS is to use high cost and time consuming, especially in large organizations.
- Security: The security cover is not allowed to access the database. When the user is not allowed to enter into the database, they do not Boley access all files, not just some. Depending on the type of data involved, security breaches can also pose a threat to individual privacy. Steps should also be taken to make a backup copy of the database file and save it so that eventuality can be avoided such as fire and earthquakes that can destroy the system.
Information retrieval systems:
information process begins when a user enters a query into the system.