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

Data base software, Data Base Software: Another major type of applicat...

Data Base Software: Another major type of application comes under the heading database software; which allows for the collection of, searching for and manipulation of informat

Autonomous rational agents - artificial intelligence, A utonomous Rational...

A utonomous Rational Agents: In many cases, it is not accurate to talk about a particular program or a particular robot, as the combination of and software and hardware in so

How do you install a new printer, Question 1 Briefly explain the classific...

Question 1 Briefly explain the classification of the computers Question 2 What is arithmetic logic unit? How it is helpful in CPU? Question 3 How do you install a

Input devices, Input Devices: i) Keyboard is the most common form of ...

Input Devices: i) Keyboard is the most common form of input devices. It was originally designed in the last century. Since then, only minor improvements have taken place in k

Database management software, Database Management Software: For storage of...

Database Management Software: For storage of large amounts of varied data, and rapid retrieval and interpretations of data, the database is the ideal tool. It is most useful for s

Explain kinematics modeling in virtual reality, Question 1 How can you cre...

Question 1 How can you create surface with 3D Scanner in geometric modeling? Question 2 Explain kinematics modeling in virtual reality Question 3 Describe object hierarc

Input - output services, Input/Output Services: Every operating syst...

Input/Output Services: Every operating system, large or small, provides input/output services for each device in the system. The operating system includes I/O device driver

Grammar, Given the following grammar: -> [ , ] | -> | { } -> a...

Given the following grammar: -> [ , ] | -> | { } -> a | b | cwhich are the strings generated by the grammar? Show the parse tree(s). a). { [ a , b ] }b). [ { a } , b ]

Cai, what is cai

what is cai

COMputer fundamentals, explain the expression "A=5"

explain the expression "A=5"

Write Your Message!

Name

Email id

Message

Verfication Code

User Account

All Pages