CMIS Fundamentals: Database

A ________ key refers to an attribute that appears as a non-primary key attribute in one entity and as a primary key attribute (or part of a primary key) in another entity.

Foreign

________ is a technique to make complex databases more efficient and more easily handled by the database management system (DBMS).

Normalization

A ________ key is a unique identifier that should be created and used when designing a database for each type of entity, in order to store and retrieve data accurately.

Primary

Elimination of data redundancy is the major goal and benefit of using data normalization techniques.

TRUE

Which of the following database models represent entities as two-dimensional tables, with records as rows, and attributes as columns?

relational database model