Integrity constraints means..? how many and what are they?
Answer Posted / swetcha
Integrity constraints provide a way of ensuring that
changes made to the database by authorized users do not
result in a loss of data consistency.
An integrity constraint can be any arbitrary predicate
applied to the database.
They may be costly to evaluate, so we will only consider
integrity constraints that can be tested with minimal
overhead.
Types of integrity constraints
(1) Non-null
(2) Key
(3) Referential integrity
(4) Attribute-based
(5) Tuple-based
(6) General assertions
plzz let me know if it's wrong
| Is This Answer Correct ? | 18 Yes | 9 No |
Post New Answer View All Answers
Explain database partitioning.
What are the types of indexes that are present inside a database?
What are the types of joins?
What is Data Modelling?
i applied prompt on country when i run report it shows list of all countries but want it to show only four countries name
How do I setup a database connection?
wHat Is THE difference between MOVEL and MOVEL(P)……….. CAN ANYONE EXPLAIN ME..
Two tables emp(empid,name,deptid,sal) and dept(deptid,deptname) are there.write a query which displays empname,corresponding deptname also display those employee names who donot belong to any dept.
What is database client?
what is data access layer?
What are the advantages of normalizing a database.
What is sharded database?
How to do performance tunning a database in DB2 V8.2 UDB in linux
What are different types of clusters present?
What do you mean by foreign key and primary key?