Database Mangement and Retrieval System

Question 1.

Differentiate between database management system and information retrieval system by focusing on their functionalities.

Database Management System (as known as DBMS) is a set of application that enable user to create, edit, update, store and retrieve data from database files. By using DBMS, data in a database can be added, deleted, changed, sorted and searched. DBMSs are usually used to manage employee information of a big company, customer information and stock information.

By using the DBMS, there are advantages and disadvantages. The advantages of a DBMS is the same information can be available to any user, minimizing redundancy can reduce the cost of storing information on other devices, the accuracy in using DBMS because of their up to date data and data is easy to access. The disadvantages of DBMS is implementing this system can be high cost and time consuming, even the training.

When we mentioned about the functionalities of DBMS, there are four main components. The four components are data, hardware, software and user. The data is something plain, raw, unorganized facts that needs to be processed to be meaningful. Hardware is physical component of the computer system and also known as peripheral. Software is application inside the computer. Lastly, the user is the one who clearly understand what it means to use the system on a daily basis.

There are a number of functions that a typical DBMS will support.

• Data Definition Language as known as DDL – to define a database. The DBMS must allow users to create database definitions

• Data Manipulation Language as known as DML – to insert, update, delete, and query data in the database.

• Concurrency control that is allows shared access to the database, with multip...

... middle of paper ...

...t, then the result will fast.

Works Cited

1. Joey F. George et.al. 2004 Object-Oriented System Analysis and Design 2d ed. Pearson International Edition :Pg144

2. Raghu Ramakrishnan & Johannes Gehrke 2003 Database Management System 3d ed. McGraw-Hill Higher Education : pg9.

3. Patricia Ward & George Dafoulas 2006 Database Management Systems Thomson : pg4&5

4. Ralph M. Stair & George W. Reynolds 2006 Principles of Information Systems, A Managerial Approach, 7th ed Thomson : pg5&7

5. Ramez Elmasri & Shamkant B. Navethe 1989 Fundamentals of Database Systems 6th ed Pearson : pg1000

6. http://www.personal.psu.edu/glh10/ist110/topic/topic07/topic07_05.html

7. http://smithaprahlad.blogspot.com/2006/05/distinguih-between-irs-and-dbms.html?m=1

8. http://www.ask.com/question/what-is-different-between-data-and-information

9. http://en.m.wikipedia.org/wiki/Unstuctured_data