Question

A functional dependency between ________ key attributes is also called a transitive dependency.

A) Non-primary
B) Primary
C) Composite
D) Unique

Answer 1

A transitive dependency occurs between non-primary key attributes in database normalization. A software developer usually works in the tertiary or quaternary sectors of an economy.

Step-by-step explanation:

The functional dependency between non-primary key attributes is known as a transitive dependency. In the context of database normalization, a transitive dependency occurs when a non-primary key attribute depends on another non-primary key attribute, which in turn depends on the primary key.

Regarding the economy sectors, a software developer would typically work in the tertiary sector if they are providing services such as software development and IT consultancy. However, as the economies evolve, the role of software developers is becoming more prevalent in the quaternary sector, which includes information technology and knowledge-based services. The quaternary sector is a subset of the tertiary sector and focuses on intellectual activities and knowledge-oriented services.