Register

DBMS Korth Edition 6 Exercise 7 Question 10 (Page No. 317)

667 views
4 votes
4 votes
Consider a many-to-one relationship R between entity sets A and B. Suppose
the relation created from R is combined with the relation created from
A. In SQL, attributes participating in a foreign key constraint can be null.
Explain how a constraint on total participation of A in R can be enforced
using not null constraints in SQL.
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
0 answers
3
ajaysoni1924 asked Mar 28, 2019
322 views
DBMS Korth Edition 6 Exercise 7 Question 9 (Page No. 317)
Suppose the advisor relationship was one-to-one. What extra constraints are required on the relation advisor to ensure that the one-to-one cardinality constraint is enforced?
Suppose the advisor relationship was one-to-one. What extra constraintsare required on the relation advisor to ensure that the one-to-one cardinalityconstraint is enforce...
User Avatar
0 votes
0 votes
0 answers
4
ajaysoni1924 asked Mar 28, 2019
284 views
DBMS Korth Edition 6 Exercise 7 Question 8 (Page No. 317)
Consider a relation such as sec_course, generated from a many-to-one relationship sec_course. Do the primary and foreign key constraints created on the relation enforce the many-to-one cardinality constraint? Explain why.
Consider a relation such as sec_course, generated from a many-to-one relationshipsec_course. Do the primary and foreign key constraints created onthe relation enforce the...
User Avatar
Link Copied!