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

Hotel database, Create a database,show all ojectives and give a fruitful in...

Create a database,show all ojectives and give a fruitful introduction and also state how it will be implemented

COMPUTERS IN EDUCATION, What is CAI?Explain its pitsfalls

What is CAI?Explain its pitsfalls

Subroutine and functions, Subroutine and Functions: In a program, it ...

Subroutine and Functions: In a program, it is often necessary to repeat a statement or group of statements at several points to accomplish a particular task. Repeating the sa

Principal structures in flow charting, PRINCIPAL STRUCTURES IN FLOW CHARTIN...

PRINCIPAL STRUCTURES IN FLOW CHARTING Structured programing calls for the usage of four principal structures to help simplify the program. They are: Sequential contro

Operating system (o.s), Operating System (O.S) An operating syst...

Operating System (O.S) An operating system is the complete set of programs written to utilize the computer resources in an optimal manner. The operating system supervise

What are the uses of the internet, Question 1 What are many of the modern ...

Question 1 What are many of the modern browsers in use today? Describe all in detail Question 2 Write a long note on the uses of Domain Names Question 3 What are the use

How to crack a password, how can i crack the password of vmware virtual mac...

how can i crack the password of vmware virtual machine

Frequency and bandwidth, Frequency and Bandwidth: Let us try to unders...

Frequency and Bandwidth: Let us try to understand a little about how information is transmitted. The information may be in the form of sound (human voice, music) or it may be

Input/output (i/o) unit, Input/output (I/o) unit: This unit provides th...

Input/output (I/o) unit: This unit provides the interface between the computer and the computer peripherals. A computer peripheral is any unit, which is attached to, but is no

Project of human computer interacation, Hi are you doing an interactive po...

Hi are you doing an interactive powerpoint porject

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages