A transitive dependency determinant is not candidate key o exists when a determi

Question

A transitive dependency determinant is not candidate key o exists when a determinant is not part ofthe primary key determinant is both candidate iey and is part of the primary key. o exists when a determinant is pat of the primary key QUESTION 21 Base tables are only stored in memory. O True QUESTION 22 Foreign keys cannot reference the primary key of their own table. True @ Ful.. QUESTION 23 The attributes of a relation that can server as a primary kay are called O Primary key candidates O Surrogate keys O Candidate keys foreign kys QUESTION 24 Foreign keys must always have a value True O False QUESTION 25 What ane 2 properties that are important for a concatenmed primary key? Can onty contain 1 coumn Whenever possible, yau should use meaningless icencities W henever possible, you should use meaningful identies D uses the smallest number of column necessary

Explanation / Answer

Q20) B

                 A transitive dependency exists when a determinant is not part of the primary key.

Q21) A

                Base tables are the tables which stores data about the tables, which is metadata.

                They stored in memory in a cryptic format.

Q22) A

                Foreign keys can refer the primary key of their own table

Q23) C

                Candidate keys can serve as a primary key.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

---

---

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