Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
What is a transaction?
The Transaction is a unit of data processing. For instance, many of the transactions at a bank may be withdrawal or deposit of money; transfer of money from A's account to B's account etc. A transaction would include manipulation of one or more data values in a database. Therefore, it may need reading and writing of database value. For instance, the withdrawal transactions can be written in pseudo code as:
Example:
; Suppose that we are doing this transaction for person
; whose account number is X.
TRANSACTION WITHDRAWAL (withdrawal_amount)
start transaction
IF X exist then
READ X.balance
IF X.balance > withdrawal_amount THEN
SUBTRACT withdrawal_amount
WRITE X.balance
COMMIT
ELSE
DISPLAY "TRANSACTION CANNOT BE PROCESSED"
ELSE DISPLAY "ACCOUNT X DOES NOT EXIST"
End transaction;
Another same example may be transmitting of money from Account no x to account number y. This transaction may be written as:
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
Write short notes on domain relational calculus The domain relational calculus uses domain variables that take on values from an attribute domain rather than values for whole t
Which method of access uses key transformation? A Hash method of access uses key transformation.
For every n-ary relationship type R where n>2, we make a new table S to represent R. We contain as foreign key attributes in s the primary keys of the relations that show the parti
Though all the ABAP/4 Dictionary Structures that exists in the structure of the LDB, being described in Database Program, we are explaining the Dictionary Structures in the Report.
Australian Bureau of Statistics (ABS) provides retail data for different groups and different states as well as the aggregate numbers. Table 11 " Retail Turnover, State by Industry
Question: This Question refers to the database schema given in the Appendix. (a) The integrity of a database is enforced by integrity rules. Discuss what should happen on a
What is association? Give an example of association Association is used for establishing relationships among classes. Association describe links among/between classes. For exa
What is ICR? A. ICR (Intelligent Character Recognition) is a technology that gives scanning and imaging systems the ability to identify images of hand-printed or script charact
Explain the differences between structured data and unstructured data. Structured data are facts concerning objects and events. The most significant structured data are numeric
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!
whatsapp: +91-977-207-8620
Phone: +91-977-207-8620
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd