This textbook is available atAmazon.com Logo
Systems Analysis and Design in a Changing World 7th Edition

Systems Analysis and Design in a Changing World (7th Edition)

Book Edition7th Edition
Author(s)Jackson, Satzinger
ISBN9781305117204
PublisherCengage
SubjectComputer Science
Chapter 9, End of Chapter, REVIEW QUESTIONS, Exercise 1
Page 287

List the components of a DBMS and describe the function of each.

Explanation

There are four main components of Database Management System, namely, Application Programming Interface (API), Direct SQL or Query Interface, Data Access Language, and Data definition Interface.

API is a set of programming instructions to access any software application. Its main feature is to make applications interactive.

Direct SQL interface allows the user to access queries without writing them to support fast and easy formulation of data.

Data Access Language is easy and user-friendly. The user can create database and tables. Data can be inserted, fetched, and updated using Data Access Language.

All security and privacy is provided under administrative interface, which is its main feature. It is an interactive work area for the DBA.

Verified Answer

The main components of DBMS and their features are:

  • Application Programming Interface: It is a library of predefined subroutines that enables application program to interact with database.
  • Query Interface: It allows user to retrieve data and generate reports without composing the program.
  • Data Access Language: It maintains internal data structure and also has the control over the physical database.
  • Data definition interface: It is a program that allows data administrators to modify the content and define the structure of the database.
How would you rate this answer and explanation?
Did you like this example?
Subscribe for full access
Page 287