1. A Non-key Attribute A) should not be repeated in another table. B) is also a

ID: 2331919 • Letter: 1

Question

1. A Non-key Attribute

A) should not be repeated in another table.

B) is also a foreign key in another table.

C) must be unique within that table.

D) is also a primary key in another table.

2. A foreign key

A) must be either null or a primary key in another table.

B) must be a primary key in another table and cannot be null.

C) may be a primary key or a non-key attribute in another table.

D) may be a non-key attribute in another table and cannot be null.

3. A primary key may be made up of more than one field joined together.

A) True

B) False

1 ) The Answer is "C".

A Non Key attribute must be unique within that table.

Example - Name and Age Columns in Customer Table.

2) The Answer is "B"

A foreign key must be a primary key in another table and cannot be null.

Example - There are Two Tables, Customer and Order

They are relationship between by a foreign key. Name of Foreign key is Customer ID.

Customer ID column exists in both customer and order tables. Customer ID in order table

called foreign key, referring to the primary key in customer table.

3) The Answer is False

Because, Primary key is unique in the table. they cann't made up of more than one field joined

together.

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