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

Hill climbing - artificial intelligence , Hill Climbing - artificial intell...

Hill Climbing - artificial intelligence: As we've seen, in some particular problems, searching the search path from primly to goal state is the point of the exercise. In anothe

Trap doors and Logic Bombs, Trap doors: This is a way of bypassing normal...

Trap doors: This is a way of bypassing normal authentication procedure (windows/ operating system user name and password) to access a system. Once a system is compromised (impac

BUS STRUCTURE, Ask question #WHAT IS TWO BUS STRUCTURE

Ask question #WHAT IS TWO BUS STRUCTURE

Execute a command in operating system, Execute a command in operating syste...

Execute a command in operating system: In order to execute a command OS does the following steps: It accepts a command from a user through mouse clicks or from t

HOMEWORK 9.., AsBased on Chapter Review Problems from the book. 1 #1. Wh...

AsBased on Chapter Review Problems from the book. 1 #1. What is meant by data independence? Explain your answer. #2. Identify two benefits of separating application software fr

Explain the protection features of ms access, Question 1 Explain the pr...

Question 1 Explain the protection features of MS Access? 2 What is Query Parameter? 3 What are the steps to be taken for improving performance of Microsoft Access database? 4 W

High level languages, High level languages: High level languages (conv...

High level languages: High level languages (converted to machine code by compiler or equivalent) are much easier to program, as well as to understand. Several high level langu

Create email account, Create Email Account: For sending or receiving e...

Create Email Account: For sending or receiving email, you need to have to an email account. The email account may be provided by the organization for which you are working or

Micro-computer, explain the function of each block in the block diagram of ...

explain the function of each block in the block diagram of micro-computer

[email protected], Excel spreadsheet answers

Excel spreadsheet answers

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages