Consistency or data in dbms, computer science, Basic Computer Science

Assignment Help:

Consistency or data in DBMS

Consistency - data in DBMS(Database) is accurate in modeling real world, follows integrity constraints
User may ensure transaction consistent by itself
If DBMS is consistent before transaction then it will be after also.

System checks ICs & if they fail, the transaction rolls back (example is aborted).
DBMS enforces some Ics or depending on the ICs declared in CREATE TABLE statements.
DBMS does not understand the semantics of the data.

Related Discussions:- Consistency or data in dbms, computer science

Wap and wml, what is charactersics of mobile computing

what is charactersics of mobile computing

System software, System software: System software helps run the compu...

System software: System software helps run the computer hardware and system. It is designed to control the operations of a computer and coordinate all external devices like c

Electronic transmission frequency, Electronic transmission Frequency: ...

Electronic transmission Frequency: Frequency is the rate at which a wave or cycle alternates between high and low (analog mode) or on and off (digital mode). For example, the

Analogue and digital signals, Analogue and digital signals: Analogue (c...

Analogue and digital signals: Analogue (continuous) information is made available in virtually all aircraft equipment. Figure 1 shows the analogue signal created by a variable

Create a queue, QUESTION (a) Give the representation of a queue as an a...

QUESTION (a) Give the representation of a queue as an abstract data type. (b) What is a priority queue? Give two types of priority queues. (c) The following program does

Circuit switching and , Circuit Switching: Many switching techniques a...

Circuit Switching: Many switching techniques are in use. One of them is line or circuit switching in which a communications path is actually established before the message is

Unix/linux, I need someone to help me with my Unix/Linux homework.

I need someone to help me with my Unix/Linux homework.

Calculate simple interest -algorithm, Algorithm : 1. Read the values of pri...

Algorithm : 1. Read the values of principal amount, time and rate of simple interest into the locations labelled as P, T, R. 2. Set the count T to 1 implying the end of a year. 3.

Bidirectional search-artificial intelligence, Bidirectional Search-Artifici...

Bidirectional Search-Artificial intelligence: We've concentrated so far on searches where the point of the search is to search a solution, not the path to the solution. In anot

Acting Rationally - artificial intelligence, Acting Rationally: Al Capo...

Acting Rationally: Al Capone was finally convicted for tax evasion. Were the police acting rationally? To answer this, we must first look at how the performance of police force

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages