Best Answer

DBMS Interfaces

User-friendly interfaces provided by a DBMS may include the following. � Menu-Based interfaces for Web Clients or Browsing: These interfaces present user with lists of options, called menus, that lead the user through the formulation a request. Menus do away with the need to memorize the specific commands and syntax of a query language. Pull-down menus are a very popular technique in Web based user interfaces. They are also often used in browsing interfaces, which allows a user to look through the contents of a database. � Forms-Based Interfaces: A forms-based interface displays a form to each user. Forms are usually designed and programmed for naive users as interfaces to canned transactions. Some systems have utilities that define a form by letting the end user interactively construct a sample form on the screen. � Graphical User Interfaces: A graphical interface (GUI) typically displays a schema to the user in diagrammatic form. The user can then specify a query by manipulating diagram. In many cases, GUls utilize both menus and forms. Most GUls use a pointing device, such as a mouse, to pick certain parts of the displayed schema diagram. � Natural Language Interfaces: These interfaces accept requests written in English, Hindi or some other language and attempt to "understand" them. A natural language interface usually has its own "schema," which is similar to the database conceptual schema, as well as a dictionary of important words. � Interfaces for Parametric Users: Parametric users, such as bank tellers, often have a small set of operations that they must perform repeatedly. Systems analysts and programmers design and implement a special interface for each known class of na�ve users. Usually, a small set of abbreviated commands is included, with the goal of minimizing the number of keystrokes required for each request. For example, function keys in a terminal can be programmed to initiate the various commands. � Interfaces for the DBA. Most database systems contain privileged commands that can be used only by the DBA's staff. These include commands for creating account, setting system parameters, granting account authorization, changing a schema, and reorganizing the storage structures of a database.

User Avatar

Wiki User

โˆ™ 2009-10-06 05:27:52
This answer is:
User Avatar
Study guides

Create a Study Guide

Add your answer:

Earn +20 pts
Q: What is the classification of DBMS and its interfaces?
Write your answer...
Related questions

What program enables you to create custom designed forms to enter or retrieve data from your database?

Your Database Management System (DBMS) should provide this facility. However, most DBMS will also allow you to create user-defined interfaces in a programming language of your choosing. Consult your DBMS documentation for specifics.

What are highlights of DBMS?

NA_ what are highlights of advanced DBMS what are highlights of advanced DBMS what are highlights of advanced DBMS



What is the importance of database design in DBMS?

DBMS is Database management system .Database design is very important in DBMS, It serves as a foundation of DBMS.

Why Microsoft Excel is dbms?

Microsoft Excel is not a DBMS. It is a spreadsheet application. A DBMS is a database management system. While Excel does have some database capabilities, it is not a DBMS.

How many interfaces are there?

There are nearly an infinite number of "interfaces." You need to clarify the question: Interfaces to what?

What are rows in dbms?

In DBMS the data is stored in the form of table . Each row in DBMS is known as tuple.

What is DBMS in Microsoft?

DBMS is Database Management System.

What are the importance of dbms in industrial environment?

importance of DBMS

What is the difference between DBMS and GIS?

gis and dbms

What does an DBMS do?

DBMS is database management system and it stores data that are related. DBMS maintains data security and integrity as well.

When was Polyhedra DBMS created?

Polyhedra DBMS was created in 1993.

Is java DBMS?

no, Java is not dbms.. Java is a programming language Dbms is database

What are advantages of rdbms over dbms?

advantage of rdbms over dbms

What is the full form of DBMS?

fullform of DBMS is Database Management System

What does a DBMS log registry contain?

"log" rigestary of DBMS contains

Is ms access is DBMS?

No. MS Access is an application which uses a (sort of) DBMS. The power of the DBMS it uses is limited which is why it is not used for larger applications.

Relationship of Microsoft access to dbms?

Relationship of Microsoft access to dbms

When was Innovative Interfaces created?

Innovative Interfaces was created in 1978.

What is the purpose of dbms?

What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.

What are dbms languages?

DBMS is Database management system . The DBMS language are those that are used to store and maintain the data in the database. Example PL/SQL.

What is the difference between flat file and DBMS?

A DBMS and a flat file are similar but diffrent. A flat file can not link files together however a DBMS can.

What is the purpose of the DBMS?

What is the purpose of dbms?DBMS is a software that organises the creation, storage and maintenance of Databases for end users.

Advantage and disadvantage of oracle dbms?

Answering "Advantage and disadvantage of oracle dbms?"

What do you mean by lossiess join in dbms?

what do u mean by lossiess join in dbms