Howard is a database designer for an e-commerce website working on creating a table to store customer information. He wants to ensure that each customer can be uniquely identified within the table…

The correct answer is A. Primary Key. A Primary Key is a column (or combination of columns) that uniquely identifies each row in a table - exactly what Howard needs to ensure no two customers share the same identifier. A Foreign Key (C) is wrong because it links rows between tables rather than uniquely identifying…

Database Fundamentals

Question

Howard is a database designer for an e-commerce website working on creating a table to store customer information. He wants to ensure that each customer can be uniquely identified within the table. Which database concept should Jack use to accomplish this goal?

Options

APrimary Key
BTuple
CForeign Key
DRelation

How the community answered

(31 responses)

A
74% (23)
B
3% (1)
C
13% (4)
D
10% (3)

Explanation

A Primary Key is a column (or combination of columns) that uniquely identifies each row in a table - exactly what Howard needs to ensure no two customers share the same identifier. A Foreign Key (C) is wrong because it links rows between tables rather than uniquely identifying rows within one. A Tuple (B) refers to a single row/record in a table, not a mechanism for uniqueness. A Relation (D) is simply the formal term for the table itself, not a constraint or identifier.

Memory tip: Think "Primary = #1 = one-of-a-kind" - the primary key is the one value that makes each record stand out from all others in its table.

Topics

#Primary Key#Table Design#Unique Identification

Community Discussion

No community discussion yet for this question.

Full DS0-001 Practice