Define the dangers of the sequence of statements

Assignment Help Computer Engineering

Reference no: EM1335644

Consider the following relational database schema:

CREATE TABLE ACCOUNTS
(
account_no char(12),
amount money,
CONSTRAINT PK_ACCOUNTS PRIMARY KEY(account_no)
)

CREATE TABLE PENDING_TRANSFERS
(
from_account_no char(12),
to_account_no char(12),
amount money,
CONSTRAINT PK_ PENDING_TRANSFERS PRIMARY KEY(from_account_no,
to_account_no),
CONSTRAINT FK_PENDING_TRANSFERS_FROM_ACCOUNT
FOREIGN KEY(from_account_no) REFERENCES ACCOUNTS(account_no),
CONSTRAINT FK_PENDING_TRANSFERS_TO_ACCOUNT
FOREIGN KEY(to_account_no) REFERENCES ACCOUNTS(account_no),
)

(a) Write three SQL statements: the first statement should add the pending amounts to the appropriate accounts, the second statement should subtract the pending amounts from the appropriate accounts, and the third statement should delete the pending balance transfer information.

(b) Explain the dangers of the sequence of statements in part (a) above, in terms of what would happen in case the database server or SQL interface were to crash in between two of these three statements.

Reference no: EM1335644

Questions Cloud

Slander and libel : Which of the following is slander rather than libel? A defamatory statue. A defamatory TV broadcast.

Organizations multiple stakeholders : Please give an example of a business process where the interests of two (or more) stakeholders are in opposition.

Effective and successful project risk management : What can be done to ensure effective and successful project risk management? Please explain, provide examples.

Ethical obligations : In 200-300 words, describe three ethical obligations of a defense attorney and three ethical obligations of a prosecuting attorney.

Define the dangers of the sequence of statements : Write down three SQL statements: the first statement should add the pending amounts to the appropriate accounts, the second statement must subtract the pending amounts from the appropriate accounts, and the third statement should delete the pending..

Scope creep and feature creep kill a project : How can scope creep and feature creep kill a project?

Give general information satyam : Give general information satyam

Apparent authority and liability : What is apparent authority and its resulting liability?

Accommodate different languages : Accommodate different languages.

User Account

All Pages