Foreign key constraints can only reference the primary key

Assignment Help Basic Computer Science

Reference no: EM131058054

In SQL, foreign key constraints can only reference the primary key attributes of the referenced relation, or other attributes declared to be a super key using the unique constraint. As a result, total participation constraints on a many-to-many relationship (or on the "one" side of a one-to-many relationship) cannot be enforced on the relations created from the relationship, using primary key, foreign key and not null constraints on the relations.

a. Explain why.

b. Explain how to enforce total participation constraints using complex check constraints or assertions (see Section 4.4.7). (Unfortunately, these features are not supported on any widely used database currently.)

Reference no: EM131058054

Questions Cloud

Use deriva gem to calculate the value : Format requirement: Please submit your assignment in PDF or WORD format online. The whole assignment must not exceed 10 pages in length, with 1.5 line spacing, 12-point Times New Roman font, 1-inch (i.e., 2.54-cm) side and top/bottom margins.

Interest on the declining balance : Your mortgage payments, which are made at the end of each year (one payment each year), include both principle and 9% interest on the declining balance. How large will your annual payments be? What amount will your normal annual payment be?

What makes it feel better or worse : Create a picture log of your family or friends that have habitual holding patterns. Use 10 pictures that look like they're from 10 different people. From the pictures guess what area of the body is creating the holding pattern, pain or discomfort ..

Cost of borrowing in cash and cost of borrowing : Calculate the difference between cost of borrowing in cash and cost of borrowing in gold (in dollar amount). Note in calculating the difference, deduct the cost of borrowing in gold from the cost of borrowing in cash. All rates are quoted in conti..

Foreign key constraints can only reference the primary key : Explain how to enforce total participation constraints using complex check constraints or assertions (see Section 4.4.7). (Unfortunately, these features are not supported on any widely used database currently.)

Evaluation of asset composition useful for capital structure : 1. Why is the evaluation of asset composition useful for capital structure analysis? 2. Is net income a reliable measure of cash available to meet fixed charges?

How to treat e as a weak entity set : Modify the E-R diagram of Figure 7.27b to introduce constraints that will guarantee that any instance of E, A, B,C, RA, RB, and RC that satisfies the constraints will correspond to an instance of A, B,C, and R. c. Modify the translation above to h..

Need a final paper for finance : Each student is required to conduct a detailed analysis of a company as part of a term paper. The analysis will look at issues like:Industry description; composition (domestic versus imports; large firms versus small firms); prospects.

Fantastic holding payout policy : Write an essay about Fantastic Holding's Payout policy - outline, analyse and interpret the company's payout policy over the review period. How is this payout policy compared (a) to that of its major competitors, and/or (b) to that of the industry..

User Account

All Pages