answersLogoWhite

0

A relationship with attributes should be an associative entity when:

- All relationships for the associative entity should be many

- The associative entity could have meaning independent of the other entities

- The associative entity should have attribute(s), but it may or may not have an identifier

- The associative entity may participate in other relationships other than the entities of the associated relationship

- Ternary relationships should be converted to associative entities

User Avatar

Wiki User

13y ago

What else can I help you with?

Continue Learning about Information Science

What is difference between primary key and foreign key?

A primary key is an attribute (or combination of attributes) that uniquely identifies each row in a relation. A primary key is designated by underlining the attribute name. The primary key of an entity set allows us to distinguish among the various entities of the set. A foreign key is an attribute in a relation of database that serves as the primary key of another relation in the same database.


Differences between metadata and attribute data?

Metadata is the data that describes information: language, who it is for, the source etc. Attribute data is composed of the attribute name and attribute value for example: "Color=red" where color is the attribute name and red is the attribute value.


Discuss the difference between a composite key and a composite attribute.How would each be indicated in an ERD?

Attribute is the property of entity.The composite attribute is like address(where street no,house no,town name all include).Composite key is also an attribute,but only which attribute are work as a unique identifier. Example:> In an ERD if vendor placed with orders then order(order day, order number) vendor(vendor code,vendor address) Here, order and vendor both are entity and order number, vendor code both are Composite key(because those are unique)but vendor address is a Composite attribute and order day(may be not unique)is an attribute only. So, we can conclude that all attribute not Composite key.


What is the difference between data and data element?

Data refers to raw facts and figures, while a data element is a unique unit of data that represents a specific attribute or characteristic. Data elements are used as building blocks to organize and structure data within a database or system.


What is the difference between a primary key and a foreign key?

A primary key uniquely identifies each record in a table and ensures data integrity. A foreign key establishes a relationship between two tables, referencing the primary key of another table to enforce referential integrity.

Related Questions

What is the difference between numeric array and associative array?

Numeric array has numbers(+integers) that represent the values Associative array has strings that represent the values


What is the difference between a skill and attribute?

Skill is something you attain through training and repetition, while attribute is a character trait.


Why associative entity use in ER model?

Associative entities are used in Entity-Relationship (ER) models to represent relationships between two or more entities. They help to model complex relationships that have attributes of their own. By using associative entities, we can accurately capture the associations between the main entities and represent them in a clear and normalized way.


What is the difference between an attribute and a behavior in c plus plus?

An attribute is a class member variable while a behaviour is a class member method.


What is the difference between is-a and has-a relationship?

is a and a


What is non transitive dependency?

Non-transitive dependency occurs in a database when a relationship between three or more attributes does not imply a direct relationship between all of them. Specifically, if attribute A is dependent on attribute B, and attribute B is dependent on attribute C, it does not necessarily mean that attribute A is dependent on attribute C. This type of dependency can complicate database normalization and design, as it can lead to redundancy and anomalies in data management. Understanding non-transitive dependencies is crucial for ensuring data integrity in relational databases.


What is the connotative meanings of relationship?

it means explain the relationship between what ever you are talking about. so say what the relationship is. State what is happening in the relationship


What is the difference between line relationship and staff relationship?

The difference between line relationship and staff relationship is that, line relationship receives command from the top management, while staff relationship is managed by all staff.


Difference between partial dependency and fully functional dependency?

The difference is that partial dependency is when a database's attribute is only partially dependent on the primary key. Fully functional dependency is when the attribute is entirely dependent on the key.


What is the difference between derived attribute and normal attribute?

A normal attribute is an attribute present in a schema and which has to be entered while entering a tuple.A derived Attribute is one which can be inferred(derived) from another normal attribute and it need not be a part of a schema.For e.g.-> In a schema, Date-of-Birth is a normal attribute.While Age is a derived attribute which can be derived from the Date-of-Birth


What is the fullform of REL in HTML?

The REL attribute in HTML is a shortened version of "relationship." REL attributes are used to define the relationship between one file and another.


What is the difference between a symbiotic relationship and socialism?

A symbiotic relationship is a relationship between 2 organisms. Socialism is a form of government.