Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Match the term with the best (most exact) description. Put a 1, 2, 3? after Answ

ID: 3561794 • Letter: M

Question

Match the term with the best (most exact) description. Put a 1, 2, 3? after Answer: to represent the match. 1) A set of tuples of attributes. 2) The smallest set of attributes that uniquely identifies a tuple. 3) A tuple of values cannot appear in a relation if those values do not appear in the primary key attributes of another relation. 4) Uniquely identifies a tuple 5) Choose one from the candidate keys 6) Like a blueprint a) Database Schema Answer: b) Superkey Answer: c) Candidate key Answer: d) Primary Key Answer: e) Foreign Key Answer:

Explanation / Answer

a)

Database Schema

Answer: 6

Reason:

-------------------------------------------------------------------------------------------------------------------------------------

b)

Super key

Answer: 4

Reason:

-------------------------------------------------------------------------------------------------------------------------------------

c)

Candidate Key

Answer: 2

Reason:

-------------------------------------------------------------------------------------------------------------------------------------

d)

Primary Key

Answer: 5

Reason:

-------------------------------------------------------------------------------------------------------------------------------------

e)

Foreign Key

Answer: 3

Reason:

-------------------------------------------------------------------------------------------------------------------------------------

f)

Relation

Answer: 1

Reason: