Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
104 views
in Structuring Database for Accounting by (15.2k points)

What integrity constraints are specified on database scheme? Why each is considered important?

Please log in or register to answer this question.

1 Answer

0 votes
by (15.7k points)

While key and entity constraints are specified on invidividual relation, the referential integrity is specified between two or more relations. This constraint is specified to maintain consistency among the tuples of such relations.

Accordingly, a tuple in one relation that refers to another relation must refer to an existing tuple in that other relation. In referencing Accounts Type, Accounts relation uses its attribute Type, which acts as foreign key to reference the tuples of relation Accounts Type through its primary key Catld. The value of Type cannot be null because of total participation of Accounts in classify relationship.

For example, there are two tables EMP (EMPNO, ENM, SAL, DPTNO (Foreign Key) DEPT (DPTNO {Primary key}, DNM, LOC). The foreign key DPTNO of EMP table takes its value as a reference from DEPT TABLE DPTNO.

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...