Information Technology Reference
In-Depth Information
Question 5.2
Perform a query translation from the following SQL to OSQL:
*LYHQWKHUHODWLRQDOVFKHPD
5HODWLRQ0RWRU3ROLF\,QVXUDQFH3UHPLXP
5HODWLRQ9HKLFOH9HKLFOH'HVFULSWLRQ
5HODWLRQ&RYHU3ROLF\9HKLFOH
*LYHQWKH64/TXHU\
6HOHFW9HKLFOH'HVFULSWLRQ9HKLFOH9HKLFOH0RWRU3ROLF\
0RWRU3UHPLX
)URP 9HKLFOH&RYHU0RWRU
:KHUH 9HKLFOH9HKLFOH &RYHU9HKLFOH
$QG
0RWRU3ROLF\ &RYHU3ROLF\
$QG
0RWRU3UHPLXP!
Question 5.3
Translate the following update transaction from SQL to OSQL so that a student with
HKID of E123456 can change from his/her department from 'IT' to 'CS'.
Given the relational schema as follows:
5HODWLRQ3(5621+.,'1DPH
5HODWLRQ678'(17+.,'0DMRU'HSWBQDPH
5HODWLRQ67$))+.,'3RVLWLRQ
5HODWLRQ&2856(&RXUVH&RXUVHBQDPH
5HODWLRQ&2856((152/&RXUVH+.,'
5HODWLRQ'(3$570(17'HSWBQDPH)DFXOW\
5HODWLRQ2)),&(5RRP2IILFHBORFDWLRQ+.,'
Given the SQL update transaction:
8SGDWH678'(17VHWGHSWBQDPH µ&6¶ZKHUH+.,'
(
References
CA (1992a) Logical Record Facility of CA-IDMS/DB 12.0 Computer Associates International
Limited
CA (1992b) SQL Reference of CA-IDMS/DB 12.0 Computer Associates International Limited
CA (1992c) Escape DL/1 user's guide. Computer Associates International Limited
Cattell RRG et al (eds) (1997) The object database standard: ODMG 2.0. Morgan Kaufmann
Publishers, Burlington
Fong J, Chitson P (1997) Query translation from SQL to OQL for database reengineering. Int J Inf
Technol 3(1):83-101
Search WWH ::
Custom Search