What do you mean by atomicity and aggregation, Database Management System

Assignment Help:

What do you mean by atomicity and aggregation?

Atomicity: Either all actions are carried out or none are. Users should not have to worry about the effect of incomplete transactions. DBMS ensures this by undoing the actions of incomplete transactions.

Aggregation: A concept which is used to model a relationship among a collection of entities and relationships. It is used when we require to express a relationship between relationships.

Related Discussions:- What do you mean by atomicity and aggregation

horizontal fragmentation, Horizontal Fragmentation- Horizontal fragmentati...

Horizontal Fragmentation- Horizontal fragmentation groups together the tuples in a relation that are collectively used by the main transactions. A horizontal fragment is produced b

When are two schedules said to be view equivalent, When are two schedules s...

When are two schedules said to be view equivalent? Ans: Two schedules that is denoted as S and S' are said to be view equivalent if the subsequent three conditions are met

Describe the algorithm to draw the dependency graph, Describe the algorithm...

Describe the algorithm to draw the dependency graph? Ans: Algorithm to draw Precedence Graph is like this: a. For every transaction T i participating in schedule S, make

Define a view and a trigger, Define a view and a trigger. Construct a view ...

Define a view and a trigger. Construct a view for the above relations that have the information about suppliers and the elements they supply. The view holds the S#, SNAME, P# , PNA

Creating views with check option-data control, Creating views with check op...

Creating views with check option : This option limits those updates of data values that cause records to go off the view. The following instance tells this in more detail: Examp

IT Assignmnet, i need help for assignment ..

i need help for assignment ..

Concurrency control, discuss the purpose of the concurrency control?

discuss the purpose of the concurrency control?

State the rearranging the execution order for efficiency, Define the step -...

Define the step - Rearranging the Execution Order for Efficiency As we know that algorithm and data structure are closely related to one another, but data structure is conside

Removing a synonym, Removing a Synonym: DROP SYNONYM D30;

Removing a Synonym: DROP SYNONYM D30;

What is the meaning of recovery, What is the meaning of Recovery? In d...

What is the meaning of Recovery? In deferred update methods, if a transaction fails before arriving its commit point, it will not have altered the database in any way, so UNDO

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages