Let Ai , 1 ? i ? 5, be the domains for a table D ? A1 A2 A3 A4 A5, where A1 {U,

Question

Let Ai , 1 ? i ? 5, be the domains for a table D ? A1 A2 A3 A4 A5, where A1 {U, V,W, X, Y, Z} (used as
code names for different cereals in a test), andA2 A3 A4 A5 Z+. The table D is given as Table 5.7.

Table 5.7
Grams of % of RDAa of %of RDA of %of RDA of
Code Name Sugar per Vitamin A per Vitamin C per Protein per
of Cereal 1-oz Serving 1-oz Serving 1-oz Serving 1-oz Serving
U 1 25 25 6
V 7 25 2 4
W 12 25 2 4
X 0 60 40 20
Y 3 25 40 10
Z 2 25 40 10


a) What is the degree of the table?
b) Find the projection of D on A3 A4 A5.
c) A domain of a table is called a primary key for the table
if its value uniquely identifies each list of D. Determine the
primary key(s) for this table.

Explanation / Answer

The degree of the table is 5

Related Questions

Navigate

• Browse (All)
• Browse L
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.