2. What is the term for an identifier that references a database column in which each value is unique?

A. Foreign key
B. Field
C. Primary key
D. Relation

3. What process do data professionals use to eliminate data redundancy, increase data integrity, and reduce complexity in a database?

A. Iteration
B. Normalization
C. Manipulation
D. Composition



Answer :

Final answer:

Primary and foreign keys are essential in establishing relationships between tables in a database. Normalization helps in optimizing database structures.


Explanation:

In a database, a primary key is a field that uniquely identifies each record in a table, while a foreign key links to the primary key in another table, establishing a relationship. Data professionals use a process called normalization to eliminate data redundancy, enhance data integrity, and simplify database structures.


Learn more about Database Management here:

https://brainly.com/question/31733141