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

Variables and constants, Variables and Constants: These are the smalle...

Variables and Constants: These are the smallest components of a programming language. For writing a program, one must know how to use the internal memory of a computer. A Com

Explain application and system software, Question 1 Explanation of impact ...

Question 1 Explanation of impact of Information Technology on governments Question 2 Explain application and system software Question 3 Briefly explain real time a

statistics, write a 2 page essay operational gaming and monte carlo simula...

write a 2 page essay operational gaming and monte carlo simulation

Types of search engine, Types of Search Engine: Some of the basic ca...

Types of Search Engine: Some of the basic categories of Search engines are : a. Primary Search Engines: Such search engines use web crawlers or spiders to traverse the w

Use Decision Tree Technique to Optimize Institution’s Studen, Use Decision ...

Use Decision Tree Technique to Optimize Institution’s Student Admission Process– A Case Study

Data representations, explain data representation in details

explain data representation in details

Office accounts system, how to reduce total amount give amount

how to reduce total amount give amount

The terms ''row-major order'' and ''column-major order", What is meant by t...

What is meant by the terms 'row-major order' and 'column-major order'? Ans: (i) Storing the array column by column is called as column-major order and storing the array row by

Cryptography, Question 1 Consider the one-time pad encryption scheme to e...

Question 1 Consider the one-time pad encryption scheme to encrypt a 1-bit message m, and assume m is chosen with uniform distribution from message space M={0,1}. Let E1 be the ev

Explain popular way commonly used to evaluate interfaces, Question: Usi...

Question: Using a questionnaire is a popular way commonly used to evaluate interfaces. (a) Describe advantages of using questionnaires as a means to evaluate interfaces.

Write Your Message!

Name

Email id

Message

Verfication Code

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

User Account

All Pages