Display how records can be deleted and updated in qbe, Database Management System

With the help of an example display how records can be deleted and updated in QBE.
(i) Increase Pay_Rate of employees along with the skill of ‘cook' by 10%.
(ii) Delete employee record for EMP# 123459

Ans: (i)
EMPLOYEE Emp# Name Skill Pay_Rate
EX Cook PX
U. EX PX * 1.1
(ii)
EMPLOYEE Emp# Name Skill Pay_Rate
D. 123459

 

Posted Date: 5/10/2013 5:19:42 AM | Location : United States







Related Discussions:- Display how records can be deleted and updated in qbe, Assignment Help, Ask Question on Display how records can be deleted and updated in qbe, Get Answer, Expert's Help, Display how records can be deleted and updated in qbe Discussions

Write discussion on Display how records can be deleted and updated in qbe
Your posts are moderated
Related Questions

What functions does a data dictionary perform? In a (DBMS)data management system, the principal functions performed by the data dictionary are Management of data defini

What is assertion? Mention the forms available. An assertion is a predicate expressing a condition that we wish the database always to satisfy. Domain integrity constraints.

Define Single Value and Multivalued attribute Single value attribute comprise a single atomic value for an entity and multivalued attribute may have much more than one value f

1.  Develop a flowchart using the decision structure to solve the following problem. A Box Lunch Bonanza is a small catering company that offers 2 different types of box lunches

List the set operations of SQL? 1) Union 2) Intersect operation 3) The except operation

Define Deadlock recovery measures                   To recover from deadlock, the cycle in the wait-for-graph should be broken. The common technique of doing this is to rollbac

Define the Wait for graph Ans: The wait-for-graph is a directed graph and consist of nodes and directed arcs; the nodes of the graph are active transactions. An arc of the grap

Differance between DDL and SDL? DDL and SDL - The data definition language (DDL) is used through DBA and database designers to describe internal schema, conceptual schema, and

Package classes and associations into models  Programs are made of separate physical units which could be edited, imported, complied or otherwise manipulated. The careful part