Select the appropriate output in the spaces below, the avialble options are show

Question

Select the appropriate output in the spaces below, the avialble options are shown in the drop down menu. If its blank, then leave it blank.

A ____ is _____ of attributes that  _____ identifies a tuple in a relation

A  _____ is a  _____ chosen by the database admin to be used as the identifying attribute(s) in a relation

A  _____ is  _____ of attributes that  _____ identifies each tuple, but without neccesarily being  _____

A  _____ is a 'logical pointer' in a dependent relation that refers to a  _____ in a parent relation

Options of words:

* Candidate key

* Primary key

* Super key

* Foreign key

* Composite key

* Multi value attribute

* a set

* a list

* a relationship

* a maximal set

* a minimal set

* an entity

* uniquely

* minimal

* composite

Explanation / Answer

(a)Superkey is any subset of attributes that uniquely identifies the tuple in a relation (b)primay key is a set of attributes or an attribute chosen by the database administrator to be used as the identfying attribute(s) in a relation (c)candidate key is set of attributes that uniquely identifies each tuple but without necessarily being primary key (d)foreign key is a "logical pointer" in a dependent relation that refers to the primary key in a parent relation

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

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