Explain the concept of qbe, Database Management System

Assignment Help:

Explain the concept of QBE?

Query-by-example represents a visual/graphical approach for accessing information in a database by the use of query templates called as skeleton tables. It is used through entering example values directly within a query template to represent what is to be achieved. QBE was developed at IBMs. T.J. Watson Research Centre and it is used through many database systems for personal computers. QBE is an extremely powerful facility that gives the user the capability to access the information a user needs without the knowledge of any programming language.

Queries in QBE are expressed through skeleton tables. QBE has two distinct features:

- QBE has two-dimensional syntax: Queries look like tables.
- QBE queries are expressed "by example". Instead of giving a process for obtaining the desired answer, the user provides an example of what is desired.
An example of QBE is given as
EMPNO NAME SALARY DESIG DEPTNO
P..x "Manager"

This query tells the system to such as for tuples in EMP relation which have designation Manager. For each such tuple, the system assigns the value of the Ename attribute to the variable x and prints it.


Related Discussions:- Explain the concept of qbe

Traffic data management, This report identifies and outlines my CIS 499 pro...

This report identifies and outlines my CIS 499 project named Traffic Data Management  Systems (TDMS) .   My goal is to design a replica of all traffic issues to be implemented i

Create student db and execute insert query, Create Student DB and execute I...

Create Student DB and execute Insert query? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, course

Explain about data independence, Data Independence This brings us to ou...

Data Independence This brings us to our next topic: data independence. It is the property of the database which tries to make sure that if we make any change in any level of sc

System error-database errors, System error :These contain errors in databas...

System error :These contain errors in database system or the OS, example, deadlocks.Such errors are fairly hard to detect and need reprogramming the erroneous components of the sys

E-R, Mention various steps required to draw an E-R Diagram. Draw an E-R Dia...

Mention various steps required to draw an E-R Diagram. Draw an E-R Diagram for Student Information System. Mention all suitable assumptions to justify your answer.

Define the terms entity type and entity set, Define the terms i) Entity typ...

Define the terms i) Entity type ii) Entity set Entity type: An entity type describes a collection of entities that have the similar attributes. Entity set: The set of all en

The sap profile parameter, While sorting, if the main storage available is ...

While sorting, if the main storage available is not enough, the system writes data to an external help file.  The SAP profile parameter, which determines DIR_SORTTMP

What are the types of indices, Normal 0 false false false ...

Normal 0 false false false EN-IN X-NONE X-NONE MicrosoftInternetExplorer4

Explain relational model and their use in dbms, Explain Relational model an...

Explain Relational model and their use in DBMS? Relational Model - The relational model was first introduced through E.F. Codd of the IBM Research in the year of 1970. The mode

Method of analyzing association traversal, Analyzing Association Traversal ...

Analyzing Association Traversal Till now, we have supposed that associations are bi-directional. But in the case of traversal, it is in only one direction in any application,

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd