Write a short note on qbe, Database Management System

Assignment Help:

Write a short note on QBE?

Stands for "Query By Example." QBE is a feature involved along with various database applications which gives user-friendly techniques of running database queries. Typically without QBE, a user must write input commands using right SQL (Structured Query Language) syntax. This is a standard language in which nearly all database programs support. Therefore, if the syntax is slightly incorrect the query might return the wrong results or may not run at all. The Query By Example feature gives a simple interface for a user to enter queries. Instead of writing an whole SQL command, the user can just fill in blanks or select items to describe the query she needs to perform. For instance, a user may need to select an entry from a table called "Table1" with an ID of 123. Using SQL, the user would required to input the command, "SELECT * FROM Table1 WHERE ID = 123". The QBE interface might permit the user to just click on Table1, type in "123" in the ID field and click "Search." QBE is offered along with most database programs, by the interface is often different among applications. For example, Microsoft Access has a QBE interface known as "Query Design View" which is totally graphical. The phpMyAdmin application used along with MySQL, offers a Web-based interface whereas users can choose a query operator and fill in blanks with search terms. Whatever QBE implementation is given with a program, the purpose is the similar - to make it easier to run database queries and to prevent the frustrations of SQL errors


Related Discussions:- Write a short note on qbe

What are the drawbacks of file oriented system in details, What are the dr...

What are the drawbacks of File Oriented System in details?

What is bcnf boyce-codd normal form, BCNF Boyce-Codd Normal Form A rel...

BCNF Boyce-Codd Normal Form A relation schema R is in BCNF if it is in 3NF and accepts an additional constraint that for every FD X A, X has to be a candidate key. If a relati

Consistency-transaction , Consistency: This property makes sure that a com...

Consistency: This property makes sure that a complete transaction implementation takes a database from one consistent state to another consistent state. If the transaction fails e

Objectives of data management, The traffic data mgmt. systems infrastructur...

The traffic data mgmt. systems infrastructure plan describes the software, hardware, data network, and other elements that will support the TDMS. The infrastructure plan is based o

What is oracle databse structure, What is Oracle databse structure? Or...

What is Oracle databse structure? Oracle database structure: The relational model has three main aspects: Structures: Structures are well-defined objects which store th

Draw the dependency diagram for the relation, Consider the subsequent relat...

Consider the subsequent relation   Professor (Pfcode, dept, head, time)   It is assumed that      (i) A professor can work in much more than one

What are domain constraints, What are domain constraints? A domain is a...

What are domain constraints? A domain is a set of values that might be assigned to an attribute .all values that appear in a column of a relation must be taken from the similar

HYRISE, how to implement hyrise in C plus plus

how to implement hyrise in C plus plus

Windows 8 Administrative Tools, Which two tools are used to administer user...

Which two tools are used to administer users for Active Directory?

How to design a formal and exact model, How to design a formal and exact mo...

How to design a formal and exact model How to design a formal and exact model of real-world problems by applying findings of analysis phase of OMT. The object design phase find

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