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
write short note on mobile database

Consistency error : These errors happen due to the inconsistent state of database caused may be due to wrong implementation of commands or in case of a transaction abort.  To overc

I am doing research in this area, especially in sime join and join efficacy when several relations have been queried. Relations located in different sites. I need something like n

What are the advantages of DBMS ? 1. Centralized Management and Control - One of the major advantages of using a database system is in which the organization could exert, thr

Ask questiwhat is row indicator in database on #Minimum 100 words accepted#

What are the Constituents of File? Also elaborates all the possible file operations? A file is organised logically as sequence of record. These records are mapped onto disk blo

#questiRegional Gardens has many nurseries, including Wagga Wagga, Bathurst, Albury, Orange, and Dubbo. Each nursery is known by its campus code, eg WW, B, A, O and D respectively.

In E-R Diagram how derived attribute are represented ? In E-R Diagram By Dashed ellipse derived attribute are represented.

Assignment #1 Data Management The questions on this exam are based on the Baxter Aviation case scenario. 1. (5 points) The systems analyst proposes the following two relationshi

Mention the various user privileges All privileges directly granted to the user or role. All privileges granted to roles that have been granted to the user or role.