Question: Consider three relations: R ( A , B ) , S ( C , D , E ) , and T ( F , G

Consider three relations: R(A,B),S(C,D,E), and T(F,G,H).
S.C is a foreign key referencing R.A
S.D is a foreign key referencing T.F
R contains 10 tuples, S contains 30 tuples, and T contains 15 tuples. Attribute S.E is a nonnullable attribute of type integer. Indicate the minimum and maximum cardinality of the result of each relational algebra expression:
\table[[,\table[[Minimum],[Cardinality]],\table[[Maximum],[Cardinality]]],[R2(A)(C(S))-A(R),,],[|))>|A||=((CR,,],[A=C??D=F((TR)S),,],[R|||>|A||=CS,,],[S????D=FT,,]]
Consider three relations: R(A,B),S(C,D,E), and T(F,G,H).
S.C is a foreign key referencing R.A
S.D is a foreign key referencing T.F
R contains 10 tuples, S contains 30 tuples, and T contains 15 tuples. Attribute S.E is a nonnullable attribute of type integer. Indicate the minimum and maximum cardinality of the result of each relational algebra expression:
\table[[,\table[[Minimum],[Cardinality]],\table[[Maximum],[Cardinality]]],[R2(A)(C(S))-A(R),,],[|))>|A|=((CR,,],[A=C??D=F((TR)S),,],[R||>|A|=CS,,],[S????D=FT,,]]
Consider three relations: R ( A , B ) , S ( C , D

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!