What is an associative entity? What four conditions should exist in order to convert a relationship to an associative entity?

What will be an ideal response?


An associative entity is an entity type that associates the instances of one or more entity types and contains attributes that are peculiar to the relationship between those entity instances. Often, a many-to-many relationship is converted to an associative entity. The following four conditions should exist in order to do this:
1. All the relationships for the participating entities types are many relationships.
2. The resulting associative entity has independent meaning.
3. The associative entity has one or more attributes other than the identifier.
4. The associative entity participates in one or more relationships independent of the entities in the associative relationship.

Business

You might also like to view...

"Cloud computing" is different from currently available technologies in all of the following aspects except:

A) it is performed "in the cloud." B) applications are delivered through a Web browser. C) it is installed in the computer's hard drive. D) computer files can be accessed remotely. E) archives are stored on massive remote servers.

Business

Careful planning of every aspect of the sales call helps the salesperson be organized and prepared to interact with the customer.

Answer the following statement true (T) or false (F)

Business

The ________, a United States regulatory agency, regulates the use of broadcast media

A) Consumer Product Safety Commission B) Environmental Protection Agency C) Federal Communications Commission D) Federal Trade Commission E) Food and Drug Administration

Business

Macy's department stores carry a wide range of product lines, including clothing, jewelry, kitchenware, and home furnishings Macy's typically charges a relatively high markup, but also holds frequent sales, in particular offering discounts to customers who use a Macy's credit card. These are examples of Macy's adjusting the ________ element of the 4 Cs of the marketing mix.

A) customer value B) cost C) convenience D) channel E) credit

Business