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

Application-specific multiprocessors, Application-Specific Multiprocessors ...

Application-Specific Multiprocessors Although this book details a variety of similar architectures, it specializes in the design of such architectures in the perspective of par

Define procedure of Building Assembler programs, In order to be able to mak...

In order to be able to make a program, quite a lot of tools are needed: Earliest an editor is used to create the source program. Next a compiler, which is nothing more than a progr

What is Router. Explain Network Router, A router is a device which has play...

A router is a device which has played an important role in the development and existence of the Internet. Routers are designed to transmit data from other network users to specific

What is electrical energy, the chemical reactions in a battery produce ____...

the chemical reactions in a battery produce ____________, each of which carries energy.

What is a signaling protocol, QUESTION (a) How VoIP Works and how VoIP ...

QUESTION (a) How VoIP Works and how VoIP helps today's business? (b) What is a signaling protocol? Explain about SIP components and their key benefits (c) What is IPTV? L

Compact diskette (cd), Compact Diskette (CD) CD-ROM ...

Compact Diskette (CD) CD-ROM CD-ROM stands for Compact Disk-Read Only Memory. This disk comes with data already stored in it. It can store around 640 MB of

Algorithms and flowcharts, write algorithm and draw flowchart to check whet...

write algorithm and draw flowchart to check whether the given number is palindrome or not

How should an ideal hospital software be? , How Should an Ideal Software be...

How Should an Ideal Software be? It should be easy to operate, with minimal training of nursing personnel. Should be reliable, and thoroughly tested in various nur

One dimensional array, One dimensional array: A one-dimensional arra...

One dimensional array: A one-dimensional array is a structured collection of elements that can be accessed individually by specifying the position of a component with ind

Networking.., write advantages and disadvantages of private and public netw...

write advantages and disadvantages of private and public network

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages