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

Working of a computer, Working of a Computer Computer may be div...

Working of a Computer Computer may be divided into the following units Input Unit Main Memory or Primary Storage Unit Arithmetic-Logic Unit

Exchanging the values of two variables, Ask question #Minimum 10 pages ac...

Ask question #Minimum 10 pages accepted#

Ascii & unicode, ASCII code: An alphanumeric code has to represent 10...

ASCII code: An alphanumeric code has to represent 10 decimal digits, 26 alphabets and certain other symbols such as punctuation marks and special characters. Therefore, a min

File management, explain the objectives of file management?

explain the objectives of file management?

Explain the tcp/ip reference model with diagram, Question 1 Define the fol...

Question 1 Define the following terms 1) Analog Signals and Digital Signals 2) Composite signals Question 2 Define the following terms

Block diagram of computer, Input unit: These are used to read data and tran...

Input unit: These are used to read data and transfer to primary memory contained in CPU through keyboard or floppy disk or mouse etc. Central Processing Unit (CPU): This consists o

Global positioning system, How does GPS work in the field of Sport or athle...

How does GPS work in the field of Sport or athletics?

Determine recursive c function computes, QUESTION (a) Give the two cond...

QUESTION (a) Give the two conditions required by a binary tree of depth d to be an almost complete binary tree. (b) Determine what the following recursive C function compute

What is the difference between kernel mode and user mode fun, The differenc...

The difference between kernel mode and user mode gives a rudimentary form of security in the following manner. Convinced instructions could be executed only when the CPU is in kern

Interpreter, Interpreter: An interpreter is a program that translates...

Interpreter: An interpreter is a program that translates each statement in the programming language into machine code and runs it. Such an arrangement means that to run the

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages