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:
What is meant by the degree of relationship set? The degree of relationship type is the number of participating entity types.
This assignment concerns the Research database. The database ER model is shown above, where attributes are omitted for clarity. The relational model for the database is: Departm
The Proliferation of Object-Oriented Methods The first few years of the 1990s saw blossoming of around fifty various object oriented methods. This proliferation is a sign of g
Explain the use of constraints in functional model with suitable example. A constraint shows relationship between two objects at same time, or among various values of the sam
Insertion Anomaly: Inability to show certain information-The primary key of the over relation be (enrolment number, Cno). Any new tuple to be inserted in the relation should have
Explain weak and strong entity type ? Weak and Strong entity type: An entity set which does not have a primary key is referred to as a weak entity set. The existence of a wea
Higher Normal Forms Is there more normal forms beyond BCNF? Yes, though, these normal forms are not based on the concept of functional dependence. More normalisation is needed if
What are the uses of the information in the Data dictionary? The following information is directly taken from the Data dictionary: Information on fields displayed with
What are advantages of object models? Object models are efficient for communicating with the application experts and reaching a consensus about the significant aspects of the p
The basic merits of decomposition. The Advantages of Decomposition 1. Separate person can work on each subsystem. 2. A particular software engineer can specialize in a
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