Q3 - Q3. What do you understand by a database management...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Q3. What do you understand by a database management system? Explain the advantages of database management system over conventional file oriented data processing system. Ans: DATABASE MANAGEMENT SYSTEM (DBMS) A Database Management System (DBMS) is the software that functions as the interface between users, other programs and the database itself. It allows the data to be stored, maintained, manipulated, and retrieved. Database Management System is a collection of programs required to store and retrieve data from the database. The principal components of a DBMS are a data description module and a data manipulation module. The data description module of the DBMS analyzes the data requirements of application programs and transfers control to the data manipulation module, which retrieves the data from the database. A DBMS can organize, process, and present selected data elements from the database. When properly prepared, database management systems enable people to access complex file systems without difficulty. Most people are able to use a database management without knowing its underlying structure. This ease of access is made possible by four components of DBMS software: data definition language, data manipulation language, query language, and report generator.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Data Base Fig: Database Management System Data Definition Language (DDL) This language is used to define the structure of the database. The structure, or schema, outlines the data to be included in the database. In the schema, each field in a record must be defined with
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/19/2012 for the course FINANCE 121 taught by Professor Aktiwari during the Spring '11 term at Amity University.

Page1 / 5

Q3 - Q3. What do you understand by a database management...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online