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

In-door patient department, In-door Patient Department Ideally all ...

In-door Patient Department Ideally all features of OPD. Both OPD and IPD modules should be inter-linked. In addition all details pertaining to the patient's medica

Algorithm writing, algorithm to simulate railway reservation process

algorithm to simulate railway reservation process

Readymade versus custom-made software, READYMADE VERSUS CUSTOM-MADE SOFTWAR...

READYMADE VERSUS CUSTOM-MADE SOFTWARE Nursing care software can be in two forms. Software can be custom-made with the help of a computer programmer, suited for a client with v

Data movement instruction, Example of register Assignment & R/M Assignment

Example of register Assignment & R/M Assignment

ICT IN BUSINESS, Explain how ICT can be used for achievement of each of the...

Explain how ICT can be used for achievement of each of the following business objectives, illustrating your answer with examples: 1. Customer intimacy 2. Low-cost leadership

Algorithmic, define it #Minimum 100 words accepted#

define it #Minimum 100 words accepted#

Artificial intelligence-intelligence performanc of computer , "Just how are...

"Just how are we capable to get a computer to performe intelligent tasks?" One thing to answer the question is to tell that: Logic generate a science out of many forms of re

OPERATING SYSEMS, Design an ER diagram for an IT training group. The compan...

Design an ER diagram for an IT training group. The company has 12 instructors and can handle upto 100 trainees for each training section. The company offers 5 advanced technology c

Algorithms and flowcharts, 1. Write an algorithm and draw a flowchart to ac...

1. Write an algorithm and draw a flowchart to accept the names and gross salary of 5000 employees and to generate the net pay. If the gross salary is greater than N 50,000 declare

Explain the probability and non-probability sampling methods, Question 1 W...

Question 1 Write a program to read four floating point numbers and find their sum and average. Question 2 Differentiate string constants and character constants with one exam

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages