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

Assignment - concept of programming language , Assignment : It is compose...

Assignment : It is composed of variable name, an assignment operator of the language and a value or variable or some expression as per composition allowed based on rules defined

Project of interactive powerpoint in human computer , Hi There, can you h...

Hi There, can you help me with my small project please, i have sent it yesterday and you dont replay. can you please ethir lem me know you can do it or no Regrads Meshari

C programming, input is n positive numbers and reverse it, out put gv the a...

input is n positive numbers and reverse it, out put gv the absolute difference and give the reverse(magic number),using function reverseinteger, and function generate magicnumber

Storage capacity and cost per bit of storage, Storage capacity and Cost per...

Storage capacity and Cost per bit of storage: Storage capacit y: It is the amount of data that can be stored in the storage unit. A large capacity is preferred. Cost pe

Overall functions , OVERALL FUNCTIONS : There are three points that must b...

OVERALL FUNCTIONS : There are three points that must be borne firmly in mind when considering the use of computers in laboratory management. Overall Function This includes

Flowchart looping, create a flowchart showing average score for the 3 quizz...

create a flowchart showing average score for the 3 quizzes assume that there are 3 sections each having 5 students the only valid number to be entered is 1-100 for the quizzes shou

What is the intent of the singleton pattern, QUESTION Consider a Univer...

QUESTION Consider a University system which has several sub systems: Student Registration Module Registration Time Tabling Library System Human Resource Manag

Artificial intelligence-general considerations for search, General Consider...

General Considerations for Search If we can specify the first state, the operators and the goal check for a look for difficulty, then we know where to create, how to move and w

Excell, grades computation

grades computation

Mini computers and micro computers, Mini Computers and Micro Computers: ...

Mini Computers and Micro Computers: The mini computers are intermediate in power, and may function as small mainframe computers. They are often dedicated to a particular purpo

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages