Key Attributes

Question 1

are defined to easily identify any row of data in a table.

Answer 1

Keys

Question 2

hey are used to establish and identify relationships between tables and also to uniquely identify any record or row of data inside a table.

Answer 2

Keys

Question 3

is defined as a set of attributes within a table that can uniquely identify each record within a table

Answer 3

Super Key

Question 4

is defined as the minimal set or subset of a Super Key

Answer 4

Candidate Key

Question 5

The candidate keys which are not selected as a primary key are known as

Answer 5

secondary keys or alternative keys

Question 6

is a candidate key that is most appropriate to become the main key for any table. It is an attribute, or collection of attributes, whose values uniquely identify each tuple in a relation.

Answer 6

Primary Key (PK)

Question 7

Key that consists of two or more attributes that uniquely identify any record in a table are called a

Answer 7

Composite Key

Question 8

But the attributes which together form the Composite key are not a key independently or individually. TRUE OR FALSE

Answer 8

true

Question 9

An attribute in one relation whose values must either match the primary key in another relation or be null.

Answer 9

Foreign Key (FK)

Question 10

are all attributes or fields of a relation, other than Candidate Key attribute(s).

Answer 10

Non-key attributes

Question 11

are attributes other than the Primary Key attribute(s).

Answer 11

Non-Prime Attributes