database management system

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

Database Management System
A database management system (DBMS) is the main software tools of the database management approach because it controls the creation, maintenance and use of the databases of an organization and its end users.
There are several functions that a DBMS performs to ensure data integrity and consistency of data in the database. There have ten function of database management system. there are data dictionary management, data storage management, data transformation and presentation, security management, multiuser access control, backup and recovery management, data integrity management, database access languages and application programming interfaces, database communication interfaces, and transaction management.
The first function of database management system is data dictionary. Database management system has been perform management functions to the elements in the database and how to connect the relationships with other data. When the system requires data in a database that will facilitate DBMS via SQL to access and search data. So that users can easily handle it. Data dictionary is used by database Administrators and Programmers and data dictionary is frequently hidden from the user.
Data storage also one of database management system. Database Management System has a primary function as data storage. Today`s, the sophistication of database management system it can store data in various types such as video and pictures. Users do not need to know how the data is stored or manipulated. Database Management System has procedures in this process and ensure that the data is sto...

... middle of paper ...

...of certain data at a single point. data will always be change and always there will be coming more.


Make appropriate use of diagrams to illustrate the underlying concepts/components of database management system and information retrieval system.

Differentiate between structured and non structured data. Give examples for each.

Structured data is defined as a data that are record and being filed in the database to make it can be used efficiently. frequent the case with the selection of the type of detailed data structures should be used to allow efficient algorithms can be used. Good design data structure allows a variety of critical operations carried out by using the time and little memory space, as possible. structured data will be represent in discrete form which is in column and row form. this can make the data in the database more organized.
Get Access