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

Write query to insert data in student table, Consider student (std_id, std_...

Consider student (std_id, std_name, date_of_birth, phone, dept_name). Put the data for a student with student id200, name arun, birth date 1 February, 1985, phone number (01110 328

Structure of distributed database, Structure Of Distributed Database: A di...

Structure Of Distributed Database: A distributed database system haves of a collection of sites, each of which keeps a local databases system. Every site is able to process local

Transaction managenment, can you please explain with the help of suitable e...

can you please explain with the help of suitable example the difference between conflict equivalence and conflict serializability?

Transactions and concurrency management, Transactions And Concurrency Manag...

Transactions And Concurrency Management  Introduction One of the main benefits of storing data in an integrated repository or a database is to permit sharing of it betwee

Explain entity integrity and referential integrity rules, Explain entity in...

Explain entity integrity and referential integrity rules within relational model. Show how these are realized in SQL? Entity Integrity Rule - No primary key value could be nu

What is interaction diagram, What is Interaction Diagram An interactio...

What is Interaction Diagram An interaction diagram shows an interaction, comprises of a set of objects and their relationships including the messages that may be dispatched be

Outer join, Outer Join: The use of Outer Join is that it still joins those...

Outer Join: The use of Outer Join is that it still joins those tuples that do not have matching values in common columns are also contained in the result table. Outer join places

What is middleware, Question: a) What is Client/Server and what benefit...

Question: a) What is Client/Server and what benefits can be expected from Client/Server systems? b) Explain what middleware is and what it does. Why would MIS managers be p

What is an e-r model and draw an e-r diagram for the company, What is an E-...

What is an E-R model? Draw an E-R Diagram for the company database with following Descriptions? The company is organized within departments. Each department has a unique name a

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

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

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